SQL Advance

SQL

1. What are the different types of replication available in SQL server?

Snapshot Replication
Transactional Replication
Merge Replication
All of the above.


2. ACID stands for _______.

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


3. Which of the followings are valid Transaction levels in SQL Server?

READ COMMITTED
READ UNCOMMITTED
REPEATABLE READ
All of the above


4. 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


5. RAID stands for ________.

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


6. OLTP stands for _________.

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


7. Which of the followings are the types of locks in SQL Server?

Shared locks
Exclusive locks
Schema locks
All of the above


8. 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


9. What are the different types of trigger

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


10. Which of the following is not a valid data type in SQL server

xml
nvarchar
money
blob