MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 9 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. |
PURPOSE_OF_CLOSE_MASTER_KEY_IS_:?$ |
| A. | Deletes the master key of the current database |
| B. | Closes the private key of the current database |
| C. | Closes the public key of the current database |
| D. | None of the mentioned |
| Answer» B. Closes the private key of the current database | |
| 2. |
Which of the following statement decrypts a symmetric key ?$ |
| A. | OPEN SYMMETRIC KEY |
| B. | DECRYPT SYMMETRIC KEY |
| C. | CLOSE SYMMETRIC KEY |
| D. | None of the mentioned |
| Answer» B. DECRYPT SYMMETRIC KEY | |
| 3. |
Which of the following is- a security statement ? |
| A. | ADD SIGNATURE |
| B. | EXECUTE AS |
| C. | SETUSER |
| D. | All of the mentioned |
| Answer» E. | |
| 4. |
Purpose of GET_TRANSMISSION_STATUS is : |
| A. | Returns the status for the first transmission for end side of a conversation |
| B. | Returns the status for the first transmission for one side of a conversation |
| C. | Returns the status for the last transmission for end side of a conversation |
| D. | Returns the status for the last transmission for one side of a conversation |
| Answer» E. | |
| 5. |
Which of the following Statement ends one side of an existing conversation ? |
| A. | BEGIN CONVERSATION TIMER |
| B. | END CONVERSATION TIMER |
| C. | END CONVERSATION |
| D. | GET CONVERSATION GROUP |
| Answer» C. END CONVERSATION | |
| 6. |
RECEIVE service broker statement applies to which of the versions ? |
| A. | 2000 |
| B. | 2005 |
| C. | 2008 |
| D. | All of the mentioned |
| Answer» D. All of the mentioned | |
| 7. |
Which of the following is not a SERVICE BROKER statement ? |
| A. | BEGIN CONVERSATION TIMER |
| B. | END CONVERSATION |
| C. | CREATE USERS |
| D. | None of the mentioned |
| Answer» D. None of the mentioned | |
| 8. |
Applications that can generate Transact-SQL can be : |
| A. | General office productivity applications |
| B. | Applications that use a graphical user interface (GUI) to let users select the tables and columns from which they want to see data |
| C. | Applications that use general language sentences to determine what data a user wants to see |
| D. | All of the mentioned |
| Answer» E. | |
| 9. |
Which of the following is proprietary extension of SQL for Microsoft SQL Server ? |
| A. | PL-SQL |
| B. | T-SQL |
| C. | PG-SQL |
| D. | P-SQL |
| Answer» C. PG-SQL | |