MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 7 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. |
Which of the following stored procedure is used for detachment of database? |
| A. | sp_replicationdboption |
| B. | sp_replicationdb |
| C. | sp_replicationoption |
| D. | All of the mentioned |
| Answer» B. sp_replicationdb | |
| 2. |
Which of the following transfer method makes the database unavailable to users during the transfer? |
| A. | Detach and attach method |
| B. | SQL Management Object method |
| C. | Restore method |
| D. | None of the mentioned |
| Answer» B. SQL Management Object method | |
| 3. |
Which of the following returns a list of the database and log files? |
| A. | RESTORE FILELISTON |
| B. | RESTORE FILELIST |
| C. | RESTORE FILELISTONLY |
| D. | All of the mentioned |
| Answer» D. All of the mentioned | |
| 4. |
Point out the wrong statement related to the use of Copy database wizard: |
| A. | Pick a source and destination server |
| B. | System stored procedures |
| C. | Schedule when to move or copy the databases |
| D. | None of the mentioned |
| Answer» C. Schedule when to move or copy the databases | |
| 5. |
Which is not the preferred way of copying a database? |
| A. | Using the Copy Database Wizard |
| B. | Restoring a database backup |
| C. | Using the Generate Scripts Wizard to publish databases |
| D. | None of the mentioned |
| Answer» D. None of the mentioned | |
| 6. |
How many ways are provided by SQL Server to copy a database? |
| A. | 2 |
| B. | 3 |
| C. | 4 |
| D. | 5 |
| Answer» C. 4 | |
| 7. |
Which of the following wizard provides creation logins on the destination server? |
| A. | Copy Database |
| B. | Move Database |
| C. | Detach database |
| D. | Attach database |
| Answer» B. Move Database | |