0

databases Online Quiz - 103

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

  2. Function definition

  3. both A & B

  4. Option in both A & B


Correct Option: B

_________ is the maximum nuber of Exceptions that the PL/SQL engine will process before exiting out of the BLOCK.

  1. only one

  2. All that apply

  3. I Dont know

  4. None of the above


Correct Option: B
  1. USI

  2. NUSI

  3. Both a and b

  4. Neither a nor b


Correct Option: A
  1. Access the rows

  2. Distribution of the rows

  3. Both a and b

  4. Only for distribution of rows to particular AMPs


Correct Option: A
  1. Access the rows

  2. Distribution of the rows

  3. Both a and b

  4. Only for distribution of rows to particular AMPs


Correct Option: C

Fastload will not support

  1. USI

  2. NUSI

  3. Both a and b

  4. Neither a nor b


Correct Option: C
  1. At a cost of row redistribution

  2. At a cost of table recreation

  3. When the table is empty

  4. None of the above


Correct Option: A
  1. One or Two AMP operation

  2. All AMP operation

  3. Many AMP operation

  4. Full table scan


Correct Option: B
  1. Hash Value

  2. Partition Number

  3. First column of the table

  4. Both a and b


Correct Option: B

Reading the rows using Non-Unique Primary index is one AMP operation

  1. True

  2. False


Correct Option: B

Teradata table will have ------ Primary Index

  1. Many

  2. Two

  3. One

  4. 64


Correct Option: C
  1. One or Two AMP operation depends on the base row location

  2. Always two AMP operation irrespective of the base row location

  3. Many AMP operation

  4. All AMP operation


Correct Option: A

Views can be specified in a trigger statement

  1. True

  2. False


Correct Option: B

Which of the following is not a schema object?

  1. Index

  2. Tables

  3. Public Synonymns

  4. Triggers


Correct Option: C
- Hide questions