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

The keyword return is compulsory in

  1. Procedure definition

  2. Function definition

  3. both A & B

  4. Option in both A & B


Correct Option: B

Examine this database trigger CREATE OR REPLACE TRIGGER prevent_gross_modification {additional trigger information} BEGIN IF TO_CHAR(sysdate, DY) = MON THEN RAISE_APPLICATION_ERROR(-19999,'user Defined error'); END IF; END; This trigger will error out

  1. True

  2. False


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

AI Explanation

To answer this question, you need to understand how PL/SQL handles exceptions.

Option A) Only one - This option is incorrect. PL/SQL does not process only one exception before exiting the block.

Option B) All that apply - This option is correct. PL/SQL will process all exceptions that occur within a block before exiting the block.

Option C) I don't know - This option is incorrect. We can determine the maximum number of exceptions that PL/SQL will process.

Option D) None of the above - This option is incorrect. The correct answer is option B.

The correct answer is B) All that apply. This option is correct because PL/SQL will process all exceptions that occur within a block before exiting the block.

A procedure can have a procedure declaration inside

  1. True

  2. False


Correct Option: B

Multiload will not support

  1. USI

  2. NUSI

  3. Both a and b

  4. Neither a nor b


Correct Option: A

In Teradata, indexes are maintained by the Senior Database Administrator

  1. True

  2. False


Correct Option: B

Secondary Index is used for

  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

Primary Index is mandatory for teradata table

  1. True

  2. False


Correct Option: B

Primary Index is used for

  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

Reading the rows using Non-Unique Secondary index is

  1. One or Two AMP operation

  2. All AMP operation

  3. Many AMP operation

  4. Full table scan


Correct Option: B

For PPI table, rows are first sorted by ------ at each AMPs

  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

Reading the rows using Unique Secondary index is

  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

Two functions can be used with the same name in a PL/SQL block

  1. True

  2. False


Correct Option: A

What is the maximum number of statements that can be specified in a trigger statement?

  1. 1

  2. 2

  3. 3

  4. 4


Correct Option: A

Which of the following is not a schema object?

  1. Index

  2. Tables

  3. Public Synonymns

  4. Triggers


Correct Option: C
- Hide questions