Tag: databases

Questions Related to databases

procedure to create a customized ERROR message
technology databases

  1. RAISE_ERROR

  2. SQLERRM

  3. RAISE_APPLICATION_ERROR

  4. RAISE_SERVER_ERROR

Show answer
Correct Option: C

Which of the following is false statement of the package.
technology databases

  1. Dependency simplified

  2. Loaded once into memory , used subsequently

  3. Privileges to objects cannot be controlled

  4. Encapsulation of code logic

Show answer
Correct Option: C

The keyword return is compulsory in

technology databases

  1. Procedure definition

  2. Function definition

  3. both A & B

  4. Option in both A & B

Show answer
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

technology databases

  1. True

  2. False

Show answer
Correct Option: B

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

technology databases

  1. only one

  2. All that apply

  3. I Dont know

  4. None of the above

Show answer
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

technology databases

  1. True

  2. False

Show answer
Correct Option: B

Multiload will not support

technology databases

  1. USI

  2. NUSI

  3. Both a and b

  4. Neither a nor b

Show answer
Correct Option: A

In Teradata, indexes are maintained by the Senior Database Administrator

technology databases

  1. True

  2. False

Show answer
Correct Option: B

Secondary Index is used for

technology databases

  1. Access the rows

  2. Distribution of the rows

  3. Both a and b

  4. Only for distribution of rows to particular AMPs

Show answer
Correct Option: A

Primary Index is mandatory for teradata table

technology databases

  1. True

  2. False

Show answer
Correct Option: B