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
No comments:
Post a Comment