0

databases Online Quiz - 15

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

  2. Data Integrity

  3. Materialized Views

  4. None of these


Correct Option: B
  1. The two tables had their same Primary Index

  2. Teradata redistributed one or both tables by rehashing them by thePrimary index in spool

  3. Teradata placed the smaller table on all AMPs

  4. All the Above


Correct Option: D
  1. NOT, Parenthesis AND, OR

  2. Parenthesis,NOT, AND, OR

  3. Parenthesis, OR ,NOT, AND

  4. Parenthesis,NOT, OR, AND


Correct Option: B
  1. Self Join

  2. Cartesian Join

  3. Cross Join

  4. Hash Join


Correct Option: A
  1. CAST

  2. COALESCE

  3. PARTITION BY

  4. RANDOM


Correct Option: B
  1. INTERSECT

  2. UNION

  3. EXCEPT

  4. MINUS

  5. All the above

  6. None of the above


Correct Option: E
  1. Product Join

  2. Exclusion Merge Join

  3. Merge Join

  4. All the Above


Correct Option: D
  1. Structured Question Language

  2. Structured Query Language

  3. Strong Question Language

  4. None


Correct Option: B

Select the DDL Statement from below:

  1. SELECT

  2. UPDATE

  3. DELETE

  4. ALTER


Correct Option: D
  1. DROP

  2. DELETE

  3. TRUNCATE

  4. All the Above


Correct Option: A

The below Query is to select the persons with a first name that starts with any character, followed by "la" from the "Persons" table. SELECT * FROM Persons WHERE FirstName LIKE '%la%'

  1. True

  2. False


Correct Option: B
  1. SELECT LastName FROM Employee

  2. EXTRACT LastName FROM Employee

  3. SELECT Employee.LastName

  4. None


Correct Option: A
  1. SELECT *.Employee

  2. SELECT [all] FROM Employee

  3. SELECT * FROM Employee

  4. SELECT Employee


Correct Option: C

sgsgsgsgsgasgteegsgsg

  1. fgg

  2. sb

  3. gsgsg

  4. sgsgs


Correct Option: C
- Hide questions