0

databases Online Quiz - 174

Description: databases Online Quiz - 174
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

Your database is in NOARCHIEVELOG mode and you want to perform a backup. Which type of backup would be appropriate in this case?

  1. Hot backup

  2. Online backup

  3. Consistent backup

  4. Incremental backup

  5. Inconsistent backup


Correct Option: C

You have enabled tracking while creating a listener to your database. What additional information is available to you when you enable tracking?

  1. Information about each oracle Net connection.

  2. Information about each entry in the Listener.ora file

  3. Information about the changes done in the database.

  4. None


Correct Option: A

In Oracle 10g , which statement regarding the contents of the V$PARAMETER view is true?

  1. Displays only the list of all default values.

  2. Displays only the list of all basic parameters.

  3. Displays currently in effect parameter values.

  4. Displays only the list of all advanced parameter.


Correct Option: C

Your database is opened in NOARCHIVELOG mode. You decide to place the database in ARCHIEVELOG mode. How would you do this? ( Choose two)

  1. Execute the ALTER DATABASE ARCHIVELOG statement

  2. Select ARCHIVELOG option in database control and restart the database to apply the changes.

  3. Shutdown and restart the instance, and in NOMOUNT state execute the ALTER DATABASE ARCHIVELOG statement.

  4. Shutdown and restart the instance mount the database and execute the ALTER DATABASE ARCHIVELOG statement.


Correct Option: B,D
  1. It degrades the run time and compiler performance

  2. It provides better run time and compiler performance

  3. It provides better optimization of the statement during parse time.

  4. It forces the rule based optimizer to be used for statement optimization.

  5. It provides better run time performance, but slightly degraded compiler performance.


Correct Option: E

You are working on the Training Database. What is default name of the alert log file in this database?

  1. alert_Training.log

  2. alertlog_Training.log

  3. alert_log_Training.log

  4. Training_alert_log.log


Correct Option: A

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)

  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.


Correct Option: C,D

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.

  1. True

  2. False


Correct Option: A

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

  1. %ROWTYPE

  2. %TYPE

  3. AS_COLUMN

  4. None of the above


Correct Option: B

AI Explanation

To answer this question, you need to understand the concept of declaring variables based on definitions of columns in a table.

Option A) %ROWTYPE - This option is incorrect because the %ROWTYPE attribute is used to declare a record variable that has the same structure as a row in a table or a cursor. It is not used to declare variables based on definitions of columns in a table.

Option B) %TYPE - This option is correct because the %TYPE attribute is used to declare variables based on the data type of a column in a table. By using %TYPE, you can ensure that the variable has the same data type as the column, making it easier to work with the data.

Option C) AS_COLUMN - This option is incorrect because there is no attribute called AS_COLUMN in Oracle SQL.

Option D) None of the above - This option is incorrect because option B, %TYPE, is the correct answer.

The correct answer is B) %TYPE. This option is correct because the %TYPE attribute is used to declare variables based on the data type of a column in a table.

Raw types are used to store _________ data.

  1. binary

  2. Character

  3. ASCII

  4. All of the above


Correct Option: A

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

  1. DELCARE and BEGIN

  2. DECALRE and EXCEPTION

  3. EXCEPTION and END

  4. BEGIN and END


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?

  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


Correct Option: C

AI Explanation

To answer this question, let's go through the code and understand what happens when the package is compiled.

The given code defines a package body named "COMPILE_THIS" with three procedures: A, B, and C. Procedure C is a local construct to the package.

When the package is compiled, the code will produce a compilation error because procedure C requires a forward declaration.

In the code, procedure B calls procedure C, and procedure C calls procedure B. Since procedure C is defined after procedure B, a forward declaration is required for procedure C to be able to call procedure B. However, no forward declaration is provided in the code, which leads to a compilation error.

Therefore, the correct answer is C. It produces a compilation error because procedure C requires a forward declaration.

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

  1. Explicit Cursor

  2. Implicit Cursor

  3. Active Data Set

  4. None of the above


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?

  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.


Correct Option: E
- Hide questions