Sql-server online test, online practice test, exam, quiz

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

Options
- OLE DB
- DBLib
- ODBC
- OLE DB and ODBC

CORRECT ANSWER : OLE DB and ODBC

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

Options
- @@NESTLEVEL
- @@FETCH_STATUS
- @@TRANCOUNT
- @@CONNECTIONS

CORRECT ANSWER : @@TRANCOUNT

By default sql server has ___________ isolation level

Options
- READ COMMITTED
- READ UNCOMMITTED
- SERIALIZABLE
- REPEATABLE READ

CORRECT ANSWER : READ COMMITTED

Problems occurs if we don’t implement proper locking strategy

Options
- Dirty reads
- Phantom reads
- Lost updates
- Unrepeatable reads
- ALL of the above

CORRECT ANSWER : ALL of the above

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

Options
- Ascending
- Descending

CORRECT ANSWER : Ascending

Which of the following is not correct for DELETE and TRUNCATE?

Options
- DELETE table can be rolled back
- TRUNCATE table cannot have triggers
- TRUNCATE table can have criteria
- DELETE table can have criteria

CORRECT ANSWER : TRUNCATE table can have criteria

Choose the incorrect option about the sql server index

Options
- Two types of indexes - clustered indexes and non-clustered indexes
- Both types use B-TREE for searching data
- Only one clustered index on a table
- More than one clustered index on a table

CORRECT ANSWER : More than one clustered index on a table

By default "FILLFACTOR" value is

Options
- Zero
- One
- Two
- Five

CORRECT ANSWER : Zero

Which of the following DBCC command is used to see when was the last time the index rebuild?

Options
- DBCC SHOW_STATISTICS
- DBCC SHOWCONFIG
- DBCC DBREINDEX

CORRECT ANSWER : DBCC SHOW_STATISTICS

Can a clustered index also be a unique index?

Options
- Yes
- No

CORRECT ANSWER : Yes

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

Options
- Yes
- No

CORRECT ANSWER : No

Which type of integrity preserves the defined relationship between tables when records are entered or deleted?

Options
- Entity integrity
- Domain integrity
- Referential integrity
- User-defined integrity

CORRECT ANSWER : Referential integrity

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

Options
- One
- Two

CORRECT ANSWER : One

Which statement is used to delete all rows in a table without having the action logged? Options - Drop table statement - Delete table statement - Truncate table statement CORRECT ANSWER : Truncate table statement Tools for importing and exporting data in sql server Options - bcp command utility - BULK inserts statement - DTS - ALL of the above CORRECT ANSWER : ALL of the above Default is a type of constraint although it does not really enforce anything Options - Yes - No CORRECT ANSWER : Yes