Tag: databases

Questions Related to databases

What are the different types of Replication?
technology databases

  1. Transactional

  2. Snapshot

  3. Mirroring

  4. Merge

Show answer
Correct Option: A,B,D

What component of SQL Server is used to send emails in SQL Server 2005?
technology databases

  1. SQL Mail

  2. Server Mail Utility

  3. Database Mail

  4. Mail Forms

Show answer
Correct Option: C

Which of the below commands is used to find more information about the SQL Server installed such as edition, product level etc. ?

technology databases

  1. Select * from sys.servers

  2. sp_get_serverinfo

  3. select @@version

  4. sp_serverproperty

Show answer
Correct Option: C

What is ACID property?
technology databases

  1. Atomicity,Concurrently,Isolation,Durability

  2. Atomicity,Consistency,Incremental,Durability

  3. Atomicity,Consistency,Isolation and Durability

  4. Atomicity,Concurrently,Incremental,Durability

Show answer
Correct Option: A

Identity is a column that automatically generates numeric values.
technology databases

  1. True

  2. False

Show answer
Correct Option: A

Which of the following are different locks in SQL SERVER?

technology databases

  1. Intent

  2. Shared

  3. Exclusive

  4. Delete

Show answer
Correct Option: A,B,C

Which of the following are different Isolation levels in SQL Server?

technology databases

  1. Read Uncommitted

  2. Read Committed

  3. Serializable

  4. Repeatable Read

Show answer
Correct Option: A,B,C,D

Linked Servers cannot be created to SQL and Non-SQL data sources such as Oracle, MySQL, Sybase etc.
technology databases

  1. True

  2. False

Show answer
Correct Option: B

Which of the following is a SQL Server 2005 Build number?
technology databases

  1. 10.5.1702

  2. 8.00.223

  3. 9.00.4285

  4. 7.00.1152

Show answer
Correct Option: C

Which of the following statements about subqueries are true? (Choose 3)
technology databases

  1. Subqueries can have up to 16 levels of nesting

  2. Subqueries can have up to 50 levels of nesting

  3. Subqueries returning only one row can follow “=” in a WHERE clause

  4. Subqueries returning only one row can follow “IN” in a WHERE clause

Show answer
Correct Option: A,C,D