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

In databases, ON UPDATE CASCADE ensures which of the following?

  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

What is decode equivalent function in Teradata

  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

SET clause in CREATE statement allows duplicate rows whereas MULTISET will not

  1. True

  2. False


Correct Option: B
  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
  1. SELECT

  2. UPDATE

  3. DELETE

  4. ALTER


Correct Option: D

SQL is case sensitive

  1. True

  2. False


Correct Option: B
  1. DROP

  2. DELETE

  3. TRUNCATE

  4. All the Above


Correct Option: A

The AND operator displays a record if both the first condition and the second condition is true. The OR operator displays a record if either the first condition or the second condition is true.

  1. True

  2. False


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

The Correct Statement to select all the columns from a table named "Employee".

  1. SELECT *.Employee

  2. SELECT [all] FROM Employee

  3. SELECT * FROM Employee

  4. SELECT Employee


Correct Option: C
  1. fgg

  2. sb

  3. gsgsg

  4. sgsgs


Correct Option: C
- Hide questions