SQL Server MCQ Test – 4 Que.1. Which of the following prevent "Dirty Reads"? A: Read commited B: Read Uncommitted C: Repeatable Read D: Serializable Right Answer : C Que.2. A filtered index is an optimized non-clustered index A: False B: True Right Answer : B Que.3. ___________ enables the DBA for managing the work load of SQL Server and critical system resource consumption A: SQL manager B: SQL profiler C: Resource Governor D: Resource manager Right Answer : C Que.4. Which join combines all rows from both tables? A: Inner Join B: Left Outer Join C: Right Outer Join D: Cross Join Right Answer : D Que.5. SQL Server 2008 supports two types of compression. Which of the following below are they? A: Row level and column level B: Row level and page level Right Answer : B Que.6. ______________ Allows you to provide the full path to a template. A: Trace file name B: Trace file path C: Template name D: Trace name Right Answer : A Que.7. Which of the following is the default isolation level in SQL Server? A: Read Committed B: Read Uncommitted C: Repeatable Read D: Serializable Right Answer : A Que.8. An index can be defined for a single column A: True B: False Right Answer : A Que.9. For every unique constraint on a column, SQL server will create A: Does not create any index B: clustered index for that column C: index for that column D: non-clustered index for that column Right Answer : D Que.10. Which of the following below are Compound Operators in sql server 2008 A: += B: %= C: *= D: all of above Right Answer : D Que.11. Which of the following commands below are used to run a stored procedure? A: EXEC MyStoredProcedure B: EXECUTE MyStoredProcedure C: RUN MyStoredProcedure D: Both a and b above Right Answer : D Que.12. A database schema is a way to logically group objects such as tables,rows, views, stored procedures etc. A: True B: False Right Answer : B Que.13. What is a MULTI_USER in sql server? A: users that have the appropriate permissions to connect to the database are allowed B: One user at a time is allowed to connect to the database C: Only some members are allowed to access the database D: Only the system admin and some members are allowed to access the database Right Answer : A Que.14. ____________ is a set of graphical tools that allows you to transfer data between disparate sources into one or more destinations. A: Data Transfer Services B: Data Transformation Services C: Data Disperse Services D: Data transform Services Right Answer : B Que.15. Which of the following below are capabilities of SQL Server Integration Services (SSIS)? A: integrate smoothly with other applications and data sources. B: copy or download files C: ALL D: send e-mail messages in response to events Right Answer : C Que.16. Why type of user is the default in sql server? A: SINGLE_USER B: MULTI_USER C: RESTRICTED_USER D: ROOT_USER Right Answer : B Que.17. Issuing ___________ will cause the named savepoint to be discarded A: TRUNCATE SAVEPOINT B: DELETE SAVEPOINT C: DISCARD SAVEPOINT D: RELEASE SAVEPOINT Right Answer : D Que.18. DTS Run utility is used for A: run DTS packages from the command prompt B: transfer data to and from a SQL Server database C: schedule and run a DTS package. D: both a and b above Right Answer : C Que.19. Which of the following below are valid database states? A: OFFLINE B: SUSPECT C: EMERGENCY D: All choices are correct. Right Answer : D Que.20. In which type of cursor, the key values of the rows are saved in tempdb? A: Static B: Keyset C: Dynamic D: Forward_only Right Answer : B
Posted on: Mon, 16 Sep 2013 05:33:16 +0000
Recently Viewed Topics
© 2015