Default is a type of constraint although it does not really enforce anything

A. Yes
B. No
Ans: A

Read more »

Tools for importing and exporting data in sql server

A. bcp command utility
B. BULK inserts statement
C. DTS
D. ALL of the above
Ans: D

Read more »

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
Ans: C

Read more »

How many Primary key constraints can be included in a table definition?

A. One
B. Two
Ans: A

Read more »

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
Ans: C

Read more »

Is a composite index key always part of a covering index?

A. Yes
B. No
Ans: B

Read more »

Can a clustered index also be a unique index?

A. Yes
B. No
Ans: A

Read more »

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
Ans: A

Read more »

By default "FILLFACTOR" value is

A. Zero
B. One
C. Two
D. Five
Ans: A

Read more »

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
Ans: D

Read more »

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
Ans: C

Read more »

What is the default "SORT" order for a SQL?

A. Ascending
B. Descending
Ans: A

Read more »

Problems occurs if we don’t implement proper locking strategy

A. Dirty reads
B. Phantom reads
C. Lost updates
D. Unrepeatable reads
E. ALL of the above
Ans: E

Read more »

By default sql server has ___________ isolation level.

A. READ COMMITTED
B. READ UNCOMMITTED
C. SERIALIZABLE
D. REPEATABLE READ
Ans: A

Read more »

Which of the following connection type supports application role permissions and password encryption?

A. OLE DB
B. DBLib
C. ODBC
D. OLE DB and ODBC
Ans: D

Read more »

Which global variables can be used to determine if a transaction is still open?

A. @@NESTLEVEL
B. @@FETCH_STATUS
C. @@TRANCOUNT
D. @@CONNECTIONS
Ans: C

Read more »

Capabilities of RAISERROR

A.  It can be logged in the error log
B.  It can print a message to the application
C.  It can assign an error number, state and severity
D. a,b and c
Ans: D

Read more »

Cursor that reflects the changes made to the database table even after the result set is returned

A. Static
B. Dynamic
C. FORWARD_ONLY
D. Keyset
Ans: B

Read more »

Which statement is used to define a cursor?

A. OPEN
B. FETCH
C. DECLARE CURSOR
D. @@FETCH_STATUS
Ans: C

Read more »

How inserting data through stored procedure do reduces network traffic and increase database performance?

A. Stored procedure can accept parameter
B. Permission check is not required
C. The execution plan is stored in the cache after it was executed the first time.
Ans: C

Read more »