Saturday 5 September 2015

SQL Server 2008 Online Quiz Questions And Answers

31. 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

32. By default "FILLFACTOR" value is
A. Zero
B. One
C. Two
D. Five
Ans: A

33. 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

34. Can a clustered index also be a unique index?
A. Yes
B. No
Ans: A

35. Is a composite index key always part of a covering index?
A. Yes
B. No
Ans: B

36. 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

37. How many Primary key constraints can be included in a table definition?
A. One
B. Two
Ans: A

38. 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

39. 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

40. Default is a type of constraint although it does not really enforce anything
A. Yes
B. No
Ans: A

More Questions and Answers:
Page1 Page2 Page3 Page4

No comments:

Post a Comment