Which_of_the_following_statement_is_used_for_changing_Recovery_Model_w – McqOptions

MCQOPTIONS

1.	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

No Comment Found

Related MCQs

THE_ACTIONS_WHICH_ARE_PLAYED_IN_THE_ORDER_WHILE_RECORDING_IT_IS_CALLED________________HISTORY.?$
THE_________RECOVERY_MODEL_IS_A_SPECIAL-PURPOSE_MODEL_THAT_WORKS_IN_A_SIMILAR_MANNER_TO_THE_FULL_RECOVERY_MODEL.?$
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$
Which_of_the_following_statement_is_used_for_changing_Recovery_Model_with_T-SQL_?$
In the __________ phase, the system replays updates of all transactions by scanning the log forward from the last checkpoint?
How many type of backups you can run when the data is in the ‚Äö√Ñ√∂‚àö√ë‚àö‚à´Full‚Äö√Ñ√∂‚àö√ë‚àöœÄ recovery model ?#
____________ using a log record sets the data item specified in the log record to the old value.
Which of the following recovery models requires log backups ?
If database modifications occur while the transaction is still active, the transaction is said to use the ___________technique.
Which the following feature cannot be used in simple recovery mode ?