SQL Server MCQ Test – 3 Que.1. In which database state, the database is in single-user mode and may be repaired or restored. A: OFFLINE B: SUSPECT C: EMERGENCY D: All choices are correct. Right Answer: C Que.2. _____________ can be used to connect to as many databases on as many servers A: Microsoft Management Console B: Enterprise Manager C: SQL Manager D: Both a and c above Right Answer: B Que.3. CREATE DATABASE has how many mandatory parameters? A: 1 B: 2 C: 3 D: None Right Answer: A Que.4. How many Primary key constraints can be included in a table definition? A: One B: Two Right Answer: A Que.5. Default is a type of constraint although it does not really enforce anything A: Yes B: No Right Answer: A Que.6. What is the difference between adhoc queries from stored procedures? A: Adhoc queries are placed embedded in the business logic code B: Stored procedures are placed embedded in the business logic code C: There is no difference as both are fired on the databases D: None of the above Right Answer: A Que.7. Which statement is used to delete all rows in a table without having the action logged? A: Drop table statement B: Delete table statement C: Truncate table statement Right Answer: C Que.8. Which of the following databases are created on installing SQL server? A: master B: msdb C: pub D: Both a and b above Right Answer: D Que.9. The SQL Query Analyzer is the main interface for running SQL queries against your database A: True B: False Right Answer: A Que.10. Tools for importing and exporting data in sql server A: bcp command utility B: BULK inserts statement C: DTS D: All choices are correct. Right Answer: D Que.11. Choose the incorrect option about the sql server index A: Two types of indexes - clustered indexes and non-clustered indexes B: Both types use B-TREE for searching data C: Only one clustered index on a table D: More than one clustered index on a table Right Answer: D Que.12. Can a clustered index also be a unique index? A: Yes B: No Right Answer: A Que.13. Is a composite index key always part of a covering index? A: Yes B: No Right Answer: B Que.14. Which type of integrity preserves the defined relationship between tables when records are entered or deleted? A: Entity integrity B: Domain integrity C: Referential integrity D: User-defined integrity Right Answer: C Que.15. Which of the following is not correct for DELETE and TRUNCATE? A: DELETE table can be rolled back B: TRUNCATE table cannot have triggers C: TRUNCATE table can have criteria D: DELETE table can have criteria Right Answer: C Que.16. By default "FILLFACTOR" value is A: Zero B: One C: Two D: Five Right Answer: A Que.17. Which of the following DBCC command is used to see when was the last time the index rebuild? A: DBCC SHOW_STATISTICS B: DBCC SHOWCONFIG C: DBCC DBREINDEX Right Answer: A Que.18. Which operation, when performed on a database can throw an error "The database could not be exclusively locked to perform the operation" A: DELETE database B: DROP database C: Rename database D: DISABLE database Right Answer: C Que.19. A candidate key cannot be regarded as a possible primary key A: True B: False Right Answer: B Que.20. The ______________ database is a system database which is used as a template whenever a new database is created. A: pubs B: tempdb C: model D: master Right Answer: C
Posted on: Sun, 28 Jul 2013 09:31:27 +0000
Trending Topics
© 2015