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