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

A NOT IN query will return rows if a NULL value is in the subquery or IN list

  1. True

  2. False


Correct Option: B

The possibilities for the two tables to be joined resides in the same AMP are

  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

The command used to display the DDL of certain objects

  1. EXPLAIN

  2. HAVING

  3. SHOW

  4. HELP


Correct Option: C

Order of precedence for sql in teradata is

  1. NOT, Parenthesis AND, OR

  2. Parenthesis,NOT, AND, OR

  3. Parenthesis, OR ,NOT, AND

  4. Parenthesis,NOT, OR, AND


Correct Option: B

Anytime you mix aggregates with non-aggregates you must use the group by statement

  1. True

  2. False


Correct Option: B

Which join requires denormalisation of the table

  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

These joins always requires SPOOL Files

  1. Product Join

  2. Exclusion Merge Join

  3. Merge Join

  4. All the Above


Correct Option: D

What does SQL stand for?

  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

The SQL statement used to delete a table:

  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

The Correct Statement to select a column named "LastName" from a table named "Employee".

  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

sgsgsgsgsgasgteegsgsg

  1. fgg

  2. sb

  3. gsgsg

  4. sgsgs


Correct Option: C
- Hide questions