Explore topic-wise MCQs in Structured Query Language (SQL).

This section includes 17 Mcqs, each offering curated multiple-choice questions to sharpen your Structured Query Language (SQL) knowledge and support exam preparation. Choose a topic below to get started.

1.

THE_ACTIONS_WHICH_ARE_PLAYED_IN_THE_ORDER_WHILE_RECORDING_IT_IS_CALLED________________HISTORY.?$

A. Repeating
B. Redo
C. Replay
D. Undo
Answer» B. Redo
Discussion
2.

THE_________RECOVERY_MODEL_IS_A_SPECIAL-PURPOSE_MODEL_THAT_WORKS_IN_A_SIMILAR_MANNER_TO_THE_FULL_RECOVERY_MODEL.?$

A. Simple
B. Full
C. bulk-logged
D. None of the mentioned
Answer» D. None of the mentioned
Discussion
3.

A special redo-only log record < Ti, Xj, V1> is written to the log, where V1 is the value being restored to data item Xj during the rollback. These log records are sometimes called$

A. Log records
B. Records
C. Compensation log records
D. Compensation redo records
Answer» D. Compensation redo records
Discussion
4.

Which_of_the_following_statement_is_used_for_changing_Recovery_Model_with_T-SQL_?$

A. ALTER DATABASE
B. ALTER TABLE
C. ALTER COLUMN
D. None of the mentioned
Answer» B. ALTER TABLE
Discussion
5.

In the __________ phase, the system replays updates of all transactions by scanning the log forward from the last checkpoint?

A. Repeating
B. Redo
C. Replay
D. Undo
Answer» C. Replay
Discussion
6.

How many type of backups you can run when the data is in the “Full” recovery model ?#

A. 5
B. 6
C. 7
D. All of the mentioned
Answer» C. 7
Discussion
7.

____________ using a log record sets the data item specified in the log record to the old value.

A. Deferred-modification
B. Late-modification
C. Immediate-modification
D. Undo
Answer» E.
Discussion
8.

Which of the following recovery models requires log backups ?

A. Simple
B. Full
C. Bulk
D. All of the mentioned
Answer» C. Bulk
Discussion
9.

If database modifications occur while the transaction is still active, the transaction is said to use the ___________technique.

A. Deferred-modification
B. Late-modification
C. Immediate-modification
D. Undo
Answer» D. Undo
Discussion
10.

Which the following feature cannot be used in simple recovery mode ?

A. Media recovery without data loss
B. Log shipping
C. Database mirroring
D. All of the mentioned
Answer» E.
Discussion
11.

If a transaction does not modify the database until it has committed, it is said to use the ___________ technique.

A. Deferred-modification
B. Late-modification
C. Immediate-modification
D. Undo
Answer» B. Late-modification
Discussion
12.

The current copy of the database is identified by a pointer, called ____________ which is stored on disk.

A. Db-pointer
B. Update log
C. Update log records
D. All of the mentioned
Answer» B. Update log
Discussion
13.

No log backups is a feature of __________ recovery model.

A. Simple
B. Full
C. Bulk-logged
D. All of the mentioned
Answer» B. Full
Discussion
14.

The ____________ scheme uses a page table containing pointers to all pages; the page table itself and all updated pages are copied to a new location.

A. Shadow copy
B. Shadow Paging
C. Update log records
D. All of the mentioned
Answer» C. Update log records
Discussion
15.

How many types of recovery model is provided by SQL Server ?

A. 2
B. 3
C. 4
D. 5
Answer» C. 4
Discussion
16.

In the ___________ scheme, a transaction that wants to update the database first creates a complete copy of the database.

A. Shadow copy
B. Shadow Paging
C. Update log records
D. All of the mentioned
Answer» B. Shadow Paging
Discussion
17.

SQL Server backup and restore operations occur within the context of the _______ model of the database.

A. backup
B. recovery
C. restore
D. None of the mentioned
Answer» C. restore
Discussion