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

You want to administer your database servers, which are running on different host machines using the web enabled grid control interface. You have configured the agent in the host machines. You have started Oracle database10g grid control utility on your machine. Which two additional components would you configure to achieve this objective?

  1. Application server control.

  2. Oracle Management service.

  3. Oracle enterprise manager repository.

  4. Oracle enterprise manager database control.


Correct Option: C,D

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

Suppose you are using three databases, DB01, DB02, and DB03 on different host machines in development environment. The database server configuration such as server IP address and listener Port number changes frequently due to development requirements. And you have the task of notifying the developers of the changes. Which connection method would you use to overcome the overhead?

  1. Host naming

  2. Local naming

  3. Easy Connect

  4. External naming

  5. Directory naming


Correct Option: E

In your database server, the parameter PLSQL_OPTIMIZE_LEVEL has been set to 2. What would this setting achieve?

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

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

  1. True

  2. False


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.

  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.

  1. binary

  2. Character

  3. ASCII

  4. All of the above


Correct Option: A

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

  1. True

  2. False


Correct Option: B

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

  1. CLOB

  2. BLOB

  3. LONG

  4. All of the above


Correct Option: B

AI Explanation

To answer this question, you need to understand the different data types used to store unstructured binary data in databases.

Option A) CLOB - The CLOB (Character Large Object) data type is used to store large amounts of character data. It is not specifically designed to store binary data.

Option B) BLOB - The BLOB (Binary Large Object) data type is specifically designed to store unstructured binary data. It can store binary data up to 4GB in length. This makes option B the correct answer.

Option C) LONG - The LONG data type is used to store variable-length character data of up to 2GB in length. It is not specifically designed to store binary data.

Option D) All of the above - This option is incorrect because option C (LONG) is not a suitable data type for storing unstructured binary data. Only option B (BLOB) is designed for this purpose.

Therefore, the correct answer is B) BLOB. This option is correct because the BLOB data type is specifically designed to store unstructured binary data up to 4GB in length.

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.

A Rollback statement cannot be used to close transaction.

  1. True

  2. False


Correct Option: B

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