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
C: bcp command utility
Which statement is used to delete all rows in a table without having the action logged?
A: Truncate table statement
C: 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: Entity integrity
B: User-defined integrity
C: Domain 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 SHOWCONFIG
B: DBCC DBREINDEX
C: DBCC SHOW_STATISTICS
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: Two types of indexes - clustered indexes and non-clustered indexes
C: Only one clustered index on a table
D: More than one clustered index on a table
Which of the following is not correct for DELETE and TRUNCATE?
A: TRUNCATE table cannot have triggers
B: DELETE table can be rolled back
C: TRUNCATE table can have criteria
D: DELETE table can have criteria
What is the default "SORT" order for a SQL?
Problems occurs if we do not implement proper locking strategy:
A: Phantom reads
B: Lost updates
D: Unrepeatable reads
E: Dirty reads
By default sql server has ___________ isolation level.
A: READ COMMITTED
B: READ UNCOMMITTED
C: REPEATABLE READ
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
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
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