Tag: databases

Questions Related to databases

In databases, a view is which of the following?
technology databases

  1. A virtual table that can be accessed via SQL commands

  2. A virtual table that cannot be accessed via SQL commands

  3. There is no difference between a view and a table

  4. None of these

Show answer
Correct Option: A

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

technology databases

  1. Normalization

  2. Data Integrity

  3. Materialized Views

  4. None of these

Show answer
Correct Option: B

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

  1. True

  2. False

Show answer
Correct Option: B

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

technology databases

  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

Show answer
Correct Option: D

The command used to display the DDL of certain objects

technology databases

  1. EXPLAIN

  2. HAVING

  3. SHOW

  4. HELP

Show answer
Correct Option: C

Order of precedence for sql in teradata is

technology databases

  1. NOT, Parenthesis AND, OR

  2. Parenthesis,NOT, AND, OR

  3. Parenthesis, OR ,NOT, AND

  4. Parenthesis,NOT, OR, AND

Show answer
Correct Option: B

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

  1. True

  2. False

Show answer
Correct Option: B

Which join requires denormalisation of the table

technology databases

  1. Self Join

  2. Cartesian Join

  3. Cross Join

  4. Hash Join

Show answer
Correct Option: A

What is decode equivalent function in Teradata

technology databases

  1. CAST

  2. COALESCE

  3. PARTITION BY

  4. RANDOM

Show answer
Correct Option: B

The SET operators used in teradata sql are

technology databases

  1. INTERSECT

  2. UNION

  3. EXCEPT

  4. MINUS

  5. All the above

  6. None of the above

Show answer
Correct Option: E