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

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

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

Raw types are used to store _________ data.

  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

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




  4. BEGIN and END

Correct Option: B
  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

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