SQL Server IQ Test Quiz Instructions:
SQL Server Quiz Test Questions and Options:
Default is a type of constraint although it does not really enforce anything.
Tools for importing and exporting data in sql server:
A: BULK inserts statement
B: bcp command utility
Which statement is used to delete all rows in a table without having the action logged?
A: Delete table statement
C: Drop table statement
D: Truncate table statement
How many Primary key constraints can be included in a table definition?
Which type of integrity preserves the defined relationship between tables when records are entered or deleted?
A: User-defined integrity
B: Referential integrity
C: Entity integrity
D: Domain integrity
Is a composite index key always part of a covering index?
Can a clustered index also be a unique index?
Which of the following DBCC command is used to see when was the last time the index rebuild?
A: DBCC DBREINDEX
B: DBCC SHOW_STATISTICS
C: DBCC SHOWCONFIG
By default "FILLFACTOR" value is __________.
What is the incorrect option about the sql server index?
A: Both types use B-TREE for searching data
B: More than one clustered index on a table
C: Two types of indexes - clustered indexes and non-clustered indexes
D: Only one clustered index on a table
Which of the following is not correct for DELETE and TRUNCATE?
A: DELETE table can have criteria
B: TRUNCATE table cannot have triggers
C: TRUNCATE table can have criteria
D: DELETE table can be rolled back
What is the default "SORT" order for a SQL?
Problems occurs if we do not implement proper locking strategy:
A: Unrepeatable reads
C: Lost updates
D: Dirty reads
E: Phantom reads
By default sql server has ___________ isolation level.
B: REPEATABLE READ
C: READ UNCOMMITTED
D: READ COMMITTED
Which of the following connection type supports application role permissions and password encryption?
B: OLE DB
D: OLE DB and ODBC
Recommended Other Related TopicsSQL Server DBA Online Exams MCQs Quiz Test
Window Server 2003 Online Exams MCQs Quiz Test
Data Interpretation Database Online Exams MCQs Quiz Test
Data-mining Database Online Exams MCQs Quiz Test
Database Online Exams MCQs Quiz Test
My SQL Database Online Exams MCQs Quiz Test
PLSQL Database Online Exams MCQs Quiz Test
Data Warehousing Online Exams MCQs Quiz Test
DBMS Online Exams MCQs Quiz Test
Microsoft Access Online Exams MCQs Quiz Test