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

What does SQL stand for??

  1. Strong Question Language

  2. Structured Query Language

  3. Structured Question Language

  4. None of the Above


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

The Minimum number of tables required to establish a many to many relationships are...

  1. 2

  2. 4

  3. 3

  4. 5


Correct Option: C

UNION vs. UNION ALL

  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

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 of the following is not true about an AMP?

  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

What is the purpose of the SQL AS clause?

  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

What does Source Definitions stands for in terms of ETL processes?

  1. Tranform

  2. Extract

  3. Load

  4. All of the Above


Correct Option: B
- Hide questions