MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 10 Mcqs, each offering curated multiple-choice questions to sharpen your Technical MCQs knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
How many types of file groups in SQL Server? |
| A. | 1 |
| B. | 3 |
| C. | 4 |
| D. | 2 |
| E. | |
| Answer» E. | |
| 2. |
Rollback operations are also logged |
| A. | TRUE |
| B. | FALSE |
| C. | Can be true or false |
| D. | Can not say |
| Answer» B. FALSE | |
| 3. |
The size of the page is? |
| A. | 2 kb |
| B. | 4 kb |
| C. | 8 kb |
| D. | 16 kb |
| Answer» D. 16 kb | |
| 4. |
How much maximum file can be there in one database? |
| A. | 65536 |
| B. | 16384 |
| C. | 32764 |
| D. | 32767 |
| Answer» E. | |
| 5. |
Which checkpoints runs just like any other T-SQL statement, once you issue checkpoint command it will run to its completion? |
| A. | Automatic |
| B. | Indirect |
| C. | Manual |
| D. | Internal |
| Answer» D. Internal | |
| 6. |
Which of the following lies between the host machine (Windows OS) and SQL Server? |
| A. | Storage Engine |
| B. | SQL OS |
| C. | Query Executor |
| D. | Query Optimizer |
| Answer» C. Query Executor | |
| 7. |
SQL Server works in client-server architecture, supports how many types of components? |
| A. | 2 |
| B. | 3 |
| C. | 4 |
| D. | 5 |
| Answer» B. 3 | |
| 8. |
Which programming language is used to developed MS SQL? |
| A. | C |
| B. | C++ |
| C. | Both A and B |
| D. | Java |
| Answer» D. Java | |
| 9. |
Which of the following statement are true about SQL Server? |
| A. | It is also an ORDBMS |
| B. | It is platform dependent |
| C. | It is both GUI and command based software |
| D. | All of the above |
| Answer» E. | |
| 10. |
MS SQL Server is a ? |
| A. | Centralised database |
| B. | Distributed database |
| C. | Relational database |
| D. | Personal database |
| Answer» D. Personal database | |