databases Online Quiz - 3

Description: databases Online Quiz - 3
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  1. The field mentioned in the where clause should be one of the columns selected

  2. The distinct function can not be used on a field of type Char

  3. The Integer value mentioned in the where clause should not be enclosed by quotes since it is of integer type.

  4. none of the above.

Correct Option: C
  1. Select employee_name,count() from employee_Details group by employee_id where count()>2;

  2. Select employee_name,employee_id,count() from employee_Details group by employee_id having count()>2;

  3. Select employee_name,employee_id,count() from employee_Details order by employee_id where count()>2;


Correct Option: B
  1. Under Read

  2. neither a,c or d

  3. Uncommitted Read

  4. Uncommitted Ride

Correct Option: C
  1. can read data that has been changed and committed.

  2. can read data that has been changed but is not yet committed.

  3. both a and b

  4. neither a or b

Correct Option: C

Select the right syntax to delete all the rows from the table employee_Details but retain the table :

  1. delete * from employee_Details

  2. delete from employee_Details

  3. truncate table employee_Details

  4. drop table employee_Details

Correct Option: B,C

What command(s) you have to execute to know the processes running inside SQL server.

  1. Sp_helpdb

  2. sp_helpprocess

  3. sp_who2

  4. select * from sys.sysprocesses

Correct Option: C,D

Wchich recovery model should database be in for database mirroring to be configured on it

  1. Bulk logged

  2. Half

  3. Full

  4. Simple

Correct Option: C
  1. Builtin/Administrator

  2. Windows authentication

  3. Mixed mode

  4. SQL authentication

Correct Option: B,C

What is process to truncate a transaction log in SQL server

  1. Fire truncate command

  2. Backup the transaction log

  3. Backup the database

  4. Logs cannot be truncated in SQL Server

Correct Option: B
  1. Bit Map

  2. clustered

  3. Non clustered

  4. filter

  5. covering

  6. Composite

Correct Option: B,C,D,E,F

How many types of system database are therand which database stores information about jobs running on the SQL server

  1. 4,Model

  2. 4,MSDB

  3. 5,MSDB

  4. 5,Master

Correct Option: C

Waht is page size and Extent size in SQL server

  1. 8,64 MB

  2. 8,64 KB

  3. 16,64 KB

  4. 10,86 MB

Correct Option: B
  1. Logical form of table

  2. Physical view of table

  3. Logical view of table

  4. View are thoes which are created on Stored procedure

Correct Option: C

What are HA Options in SQL server 2005 database.

  1. Data Guard

  2. Clustering

  3. Mirroring

  4. Transaction log shipping

  5. RAC

Correct Option: B,C,D
- Hide questions