MS SQL Server Test

Question 2: ACID stands for _______.

• Atomic, Cryptic, Independent, Durable
• Atomicity, Consistency, Isolation, Durability
• Automatic, Concurrent, Isolation, Durability
• Atomicity, Consistency, Isolation, Decoupled

Question 3: What is Primary Key?

• Primary keys are unique names of a table.
• Primary keys are integer ids in a table rows.
• Primary keys are unique identifiers for each row in a table.
• None of the above.

Question 4: A table can have more than one combination of columns that uniquely identify the row in a table; each combination is called_________.

• Foreign Key
• Primary key
• Composite Key
• Candidate Key

Question 5: A column that automatically generates numeric values is called __________.

• Unique column
• Integer column
• Identity column
• Candidate column

Question 6: What is the correct order of query operators in a SQL query?

• SELECT -> FROM -> OUTER -> WHERE
• FROM -> OUTER -> WHERE -> ON
• SELECT -> FROM -> WHERE -> OUTER
• FROM -> OUTER -> GROUP BY -> WHERE

Question 7: What are indexes?

• Index speed up the data retrieval
• Index stores large number of integer values
• Index minimize the data redundancy
• None of the above.

Question 8: How many types of indexes in SQL server?

• Integer and string
• Unique and non-unique
• Clustered and Nonclustered
• None of the above

Question 9: RAID stands for ________.

• Reduce Array of Independent Disks
• Redundant Array of Independent Disks
• Redundant Automatic Individual Durable
• Redundancy Accelerator Independent Disks

Question 10: What is the difference between Primary key and Unique key?

• Primary key doesn't allow null value whereas unique key allows multiple null values
• Primary key allows one null value whereas unique key doesn't allow null value.
• Primary key doesn't allow null value whereas unique key allows one null value.
• Primary key allows one null value whereas unique key allows multiple null values.

Question 11: OLTP stands for _________.

• Online Transaction Processing
• Offline Transaction Processing
• Ontime Transaction Program
• Online Timebound Processing

Question 12: Which of the followings are the types of locks in SQL Server?

• Shared locks
• Exclusive locks
• Schema locks
• All of the above

Question 13: What are the authentication modes in SQL Server?

• Windows mode
• Mixed mode
• All of the above
• None of the above

Question 14: What is a trigger?

• A trigger is a SQL procedure that initiates an action when an event (INSERT, DELETE or UPDATE) occurs.
• A trigger is an event that can be raised from Stored Procedures.
• A trigger is a SQL procedure that performs some tasks on accessing db tables.
• A trigger is a procedure which executes when an error occurred.

Question 15: What are the different types of trigger

• DDL and DCL
• DDL and DUL
• DML and DTL
• DML and DDL

Question 16: What are the different types of temporary tables in SQL server?

• Indexed and non-index temporary tables
• Global and local temporary tables
• Unique and shared temporary tables
• Small and large temporary tables

Question 17: Which of the following is not a valid data type in SQL server

• xml
• nvarchar
• money
• blob

Question 18: Which of the followings are valid Transaction levels in SQL Server?

• READ COMMITTED
• READ UNCOMMITTED
• REPEATABLE READ
• All of the above

Question 19: Which of the following keyword is used to raise an error in stored procedure?

• THROW
• THROWERROR
• RAISERROR
• ERROR

Question 20: What are the different types of replication available in SQL server?

• Snapshot Replication
• Transactional Replication
• Merge Replication
• All of the above