SQL Statements - DBMS Questions and Answers

1.

By default sql server has ___________ isolation level

   A.) READ COMMITTED
   B.) READ UNCOMMITTED
   C.) SERIALIZABLE
   D.) REPEATABLE READ

Answer: Option 'A'

​READ COMMITTED

2.

Which of the following fixed database roles can add or remove user IDs?

   A.) db_accessadmin
   B.) db_securityadmin
   C.) db_setupadmin
   D.) db_sysadmin

Answer: Option 'A'

db_accessadmin

3.

Which of the following is not a property of transactions?

   A.) Atomicity
   B.) Concurrency
   C.) Isolation
   D.) Durability

Answer: Option 'D'

Durability

4.

Constraint checking can be disabled in existing _______________ and _____________ constraints so that any data you modify or add to the table is not checked against the constraint.

   A.) CHECK, FOREIGN KEY
   B.) DELETE, FOREIGN KEY
   C.) CHECK, PRIMARY KEY
   D.) PRIMARY KEY, FOREIGN KEY

Answer: Option 'A'

Check and foreign constraints are used to constraint the table data.

5.

Which of the following statements is/are not true for SQL profiler?

   A.) Enables you to monitor events
   B.) Check if rows are being inserted properly
   C.) Check the performance of a stored procedure
   D.) ALL of the mentioned

Answer: Option 'C'

​Check the performance of a stored procedure

SQL Statements - DBMS Questions and Answers Download Pdf