0

databases Online Quiz - 60

Description: databases Online Quiz - 60
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  1. Index

  2. Page deallocation

  3. Trigger creation

  4. None of the above


Correct Option: A
  1. Strong Question Language

  2. Structured Query Language

  3. Structured Question Language

  4. None of the Above


Correct Option: B

Which of the statement allows you to roll back and creates log in the transaction log?

  1. TRUNCATE

  2. DELETE

  3. DELETE ALL

  4. REMOVE


Correct Option: B

Arrange the keyword “FROM, WHERE, SELECT, HAVING,GROUP BY, ORDER BY ” in the proper ?order

  1. SELECT, FROM , WHERE,GROUP BY, ORDER BY, HAVING?

  2. SELECT, FROM, WHERE, ORDER BY, HAVING,GROUP BY

  3. SELECT, FROM, WHERE, ORDER BY, GROUP BY, HAVING

  4. SELECT, FROM , WHERE,GROUP BY, HAVING, ORDER BY


Correct Option: D
  1. UNION only selects distinct values, UNION ALL selects all values (excluding ?duplicates)?

  2. UNION ALL only selects distinct values, UNION selects all values (including ?duplicates)?

  3. UNION only selects distinct values, UNION ALL selects all values (including ?duplicates)?

  4. UNION ALL only selects distinct values, UNION selects all values (excluding ?duplicates)?


Correct Option: C

The Query has Main and Sub Query. If the main query returns 10 records and subquery returns 5 records, then how many times the subquery gets executed?

  1. 10

  2. 1

  3. 5

  4. 50


Correct Option: B

Which statement does not fire the Trigger?

  1. Delete

  2. Truncate

  3. Insert

  4. Update


Correct Option: B

Multiple indexes on a table will lead to...

  1. Increase the performance during SELECT operation

  2. Degrade the performance during INSERT operation?

  3. Degrade the performance during the UPDATE or DELETE operation

  4. All of the above


Correct Option: B

Which key has a logical relationship to the attributes within that row in a table??

  1. Natural Key

  2. Domain Key

  3. Candidate Key

  4. All of the Above


Correct Option: D
  1. AMP stores and retrieves data using the file system

  2. AMP parses the SQL to determine the type and validity

  3. AMP sorts and formats the output

  4. AMP environment is a Shared Nothing Architecture


Correct Option: B

Which of the following is true for Perm Space

  1. Perm space can be dynamically modified.

  2. All Perm space specifications are subtracted from the immediate owner or parent.

  3. Perm space currently unused is available to be used as Spool or Temp space.

  4. Perm space is only used for tables and stored procedures.

  5. Volatile Temporary tables and “derived” tables utilize Perm space.


Correct Option: A,B,C,D

We refer to a join as a self-join when…

  1. We are using left and right join together

  2. We are joining more than 2 tables

  3. We are joining table to itself

  4. we are joining 2 tables


Correct Option: C
  1. The AS clause is used with the JOIN clause only.

  2. The AS SQL clause is used change the name of a column in the result set or to assign a name to a derived column.

  3. The AS clause defines a search condition.

  4. The AS clause defines a join


Correct Option: B
  1. a column list.

  2. a table list.

  3. a list of values.

  4. a range to test in the SQL query search condition.


Correct Option: D
- Hide questions