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: bcp command utility
C: BULK inserts statement
Which statement is used to delete all rows in a table without having the action logged?
A: Truncate table statement
B: Delete table statement
D: Drop 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: Domain integrity
B: Entity integrity
C: User-defined integrity
D: Referential 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: More than one clustered index on a table
B: Two types of indexes - clustered indexes and non-clustered indexes
C: Both types use B-TREE for searching data
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: Phantom reads
D: Dirty reads
E: Lost updates
By default sql server has ___________ isolation level.
A: READ COMMITTED
B: REPEATABLE READ
D: READ UNCOMMITTED
Which of the following connection type supports application role permissions and password encryption?
A: OLE DB and ODBC
B: OLE DB
Recommended Other Related TopicsSQL Server DBA Online Exams MCQs Quiz Test
Data Interpretation Database Online Exams MCQs Quiz Test
Window Server 2003 Online Exams MCQs Quiz Test
Data-mining Database Online Exams MCQs Quiz Test
Database Online Exams MCQs Quiz Test
PLSQL Database Online Exams MCQs Quiz Test
My SQL Database Online Exams MCQs Quiz Test
DBMS Online Exams MCQs Quiz Test
Data Warehousing Online Exams MCQs Quiz Test
Microsoft Access Online Exams MCQs Quiz Test