Tag: databases

Questions Related to databases

Suppose you are working in a test database where instance recovery takes a considerable amount of time. How can reduce the recovery time? (Choose two)
technology databases

  1. By multiplexing the control files.

  2. By multiplexing the redo log files.

  3. By decreasing the size of redo log files.

  4. By configuring the Mean Time Recover (MTTR) to a lower value.

  5. By setting UNDO_RETENTION parameter to a higher value.

Show answer
Correct Option: C,D

Database Vault is available as a standard product included in the Enterprise Edition of Oracle Database 10g Release 2.
technology databases

  1. True

  2. False

Show answer
Correct Option: A

An enhancement in Oracle Database 10g Release 2 is that Enterprise manager computes statistical alert threshold using either static ( user-defined) or dynamic ( self- adjusting) baseline.
technology databases

  1. True

  2. False

Show answer
Correct Option: A

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

CREATE OR REPLACE PACKAGE BODY COMPILE_THIS IS PROCEDURE A IS BEGIN G_VALUE := (‘HELLO WORLD’); END A; PROCEDURE B IS BEGIN C; DBMS_OUTPUT. PUT_LINE (‘PROCEDURE B CALLING C’); END B; PROCEDURE C IS BEGIN B; DBMS_OUTPUT. PUT_LINE (‘PROCEDURE C CALLING B’); END; END COMILE_THIS; / Procedure C is a local construct to the package. What happens when this package is compiled?
technology databases

  1. It produces the output Procedure B calling C

  2. It produces the output Procedure C calling B

  3. It produces a compilation error because procedure C requires a forward declaration

  4. It produces a compilation error because procedure B requires a forward declaration.

  5. It produces a compilation error because identified g_value is not declared in procedure A

Show answer
Correct Option: C

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

  1. True

  2. False

Show answer
Correct Option: B