Tag: databases

Questions Related to databases

The __________ attribute is used to declare variables based on definitions of columns in table.
technology databases

  1. %ROWTYPE

  2. %TYPE

  3. AS_COLUMN

  4. None of the above

Show answer
Correct Option: B

Raw types are used to store _________ data.
technology databases

  1. Binary

  2. Character

  3. ASCII

  4. All of the above

Show answer
Correct Option: A

SQL has facility for programmed handling of errors that arise during the manipulation of data.
technology databases

  1. True

  2. False

Show answer
Correct Option: B

_________ data type stores unstructured binary data upto 4GB length.
technology databases

  1. CLOB

  2. BLOB

  3. LONG

  4. All of the above

Show answer
Correct Option: B

In a PL/SQL block structure, which parts are optional?
technology databases

  1. DELCARE and BEGIN

  2. DECALRE and EXCEPTION

  3. EXCEPTION and END

  4. BEGIN and END

Show answer
Correct Option: B

A Rollback statement cannot be used to close transaction.
technology databases

  1. True

  2. False

Show answer
Correct Option: B

If the Oracle Engine for its internal processing has opened a cursor they are known as _________
technology databases

  1. Explicit Cursor

  2. Implicit Cursor

  3. Active Data Set

  4. None of the above

Show answer
Correct Option: B

You want to create a PL/SQL block of code that calculates discounts on customer orders. This code will be invoked from several places, but only within the program unit ORDERTOTAL. What is the most appropriate location to store the code that calculates the discounts?
technology databases

  1. A stored procedure on the server.

  2. A block of code in a PL/SQL library.

  3. A standalone procedure on the client machine.

  4. A block of code in the body of the program unit ORDERTOTAL.

  5. A local subprogram defined within the program unit ORDERTOTAL.

Show answer
Correct Option: E

Implicit cursors are declared for
technology databases

  1. Some DML,PL/SQL statements

  2. All DML,PL/SQL statements

  3. Only PL/SQL statements

  4. None of the Above

Show answer
Correct Option: B

Which is the procedure used to issue User-Defined error messages from stored Sub-Programs?
technology databases

  1. Raise Application procedure

  2. Raise Application Error procedure

  3. Application Error procedure

  4. None of the Above

Show answer
Correct Option: B