Which of the following is a type of database backup? MCQ with Answer and Explanation

Which of the following is a type of database backup?
A. All of the above
B. Differential backup
C. Incremental backup
D. Full backup
Answer: Option A
Solution (By JKSSB Mock Tests)
Full, incremental, and differential backups are common backup strategies.

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Database Management System (DBMS) Questions

Question #1
What does a database constraint called a 'CHECK' constraint do?
A. It limits the range of values that can be placed in a column based on a specific condition.
B. It automatically links tables together.
C. It checks if the database server is running safely.
D. It verifies user authentication passwords.

Correct Answer: Option A


Explanation:
A CHECK constraint enforces domain integrity by limiting the values accepted by a column to only those that satisfy a specified Boolean predicate.

This question belongs to: Computer Database Management System (DBMS)
Question #2
Which of the following commands is a Data Manipulation Language (DML) statement?
A. RENAME
B. COMMENT
C. UPDATE
D. TRUNCATE

Correct Answer: Option C


Explanation:
UPDATE is a DML statement because it is used to modify existing data values within rows of a database table, rather than modifying the structural schema.

This question belongs to: Computer Database Management System (DBMS)
Question #3
In SQL, which statement is used to create a new database?
A. CREATE SCHEMA
B. CREATE DATABASE
C. NEW DATABASE
D. CREATE TABLE

Correct Answer: Option B


Explanation:
CREATE DATABASE is used to create a new database in SQL.

This question belongs to: Computer Database Management System (DBMS)