0

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

fill up:A LEFT JOIN Return all rows from the _________ table, even if there are no matches in the __________ table

  1. left,right

  2. right,left

  3. left,left

  4. right,right


Correct Option: A
  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;

  4. NONE of THE ABOVE


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
  1. delete * from employee_Details

  2. delete from employee_Details

  3. truncate table employee_Details

  4. drop table employee_Details


Correct Option: B,C
  1. Sp_helpdb

  2. sp_helpprocess

  3. sp_who2

  4. select * from sys.sysprocesses


Correct Option: C,D
  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
  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
  1. Data Guard

  2. Clustering

  3. Mirroring

  4. Transaction log shipping

  5. RAC


Correct Option: B,C,D
- Hide questions