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. |
WHICH_OF_THE_FOLLOWING_TOOL_IS_USED_FOR_DESIGNING_SCHEMA_OF_THE_DATABASE_IN_SSMS_??$ |
| A. | Query Designer |
| B. | Database Diagrams |
| C. | Table designer |
| D. | Query Editor |
| Answer» D. Query Editor | |
| 2. |
Which of following is database object? |
| A. | Tables |
| B. | Triggers |
| C. | Functions |
| D. | All of the mentioned |
| Answer» E. | |
| 3. |
_________ is tool in SSMS used to manage multiple servers. |
| A. | Registered Servers |
| B. | Query Editor |
| C. | Template Explorer |
| D. | Context Explorer |
| Answer» B. Query Editor | |
| 4. |
Which command is used to reset default configuration in SSMS ? |
| A. | Clear |
| B. | Hide |
| C. | Reset all |
| D. | Reset |
| Answer» E. | |
| 5. |
_____________ is not available on standard toolbar. |
| A. | Error List |
| B. | Object Explorer |
| C. | Query Editor |
| D. | Properties windows |
| Answer» B. Object Explorer | |
| 6. |
Which of the following shortcut is used for displaying error list ? |
| A. | Ctrl + / |
| B. | Ctrl + | |
| C. | Ctrl + \ |
| D. | Ctrl + ! |
| Answer» D. Ctrl + ! | |
| 7. |
Template Explorer is used to manage ____________ |
| A. | T-SQL scripts |
| B. | Registered Servers |
| C. | Properties |
| D. | Query design |
| Answer» B. Registered Servers | |
| 8. |
Which panel presents a list of objects under the selected node ? |
| A. | Template Explorer |
| B. | Object Explorer |
| C. | Properties window |
| D. | Query Editor |
| Answer» C. Properties window | |
| 9. |
Management Studio is ________ used for development of SQL Server database. |
| A. | Front end tool |
| B. | Back end tool |
| C. | Database engine |
| D. | SQL Server |
| Answer» B. Back end tool | |