databases Online Quiz - 174 Online Test

0

databases Online Quiz - 174

Description: databases Online Quiz - 174
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: databases

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?

technology databases

Application server control.
Oracle Management service.
Oracle enterprise manager repository.
Oracle enterprise manager database control.

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

technology databases

Hot backup
Online backup
Consistent backup
Incremental backup
Inconsistent backup

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

technology databases

Information about each oracle Net connection.
Information about each entry in the Listener.ora file
Information about the changes done in the database.
None

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

technology databases

Displays only the list of all default values.
Displays only the list of all basic parameters.
Displays currently in effect parameter values.
Displays only the list of all advanced parameter.

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

technology databases

Execute the ALTER DATABASE ARCHIVELOG statement
Select ARCHIVELOG option in database control and restart the database to apply the changes.
Shutdown and restart the instance, and in NOMOUNT state execute the ALTER DATABASE ARCHIVELOG statement.
Shutdown and restart the instance mount the database and execute the ALTER DATABASE ARCHIVELOG statement.

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?

technology databases

Host naming
Local naming
Easy Connect
External naming
Directory naming

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

technology databases

It degrades the run time and compiler performance
It provides better run time and compiler performance
It provides better optimization of the statement during parse time.
It forces the rule based optimizer to be used for statement optimization.
It provides better run time performance, but slightly degraded compiler performance.

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

technology databases

alert_Training.log
alertlog_Training.log
alert_log_Training.log
Training_alert_log.log

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

By multiplexing the control files.
By multiplexing the redo log files.
By decreasing the size of redo log files.
By configuring the Mean Time Recover (MTTR) to a lower value.
By setting UNDO_RETENTION parameter to a higher value.

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

technology databases

True
False

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

True
False

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

technology databases

%ROWTYPE
%TYPE
AS_COLUMN
None of the above

Raw types are used to store _________ data.

technology databases

binary
Character
ASCII
All of the above

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

technology databases

True
False

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

technology databases

CLOB
BLOB
LONG
All of the above

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

technology databases

DELCARE and BEGIN
DECALRE and EXCEPTION
EXCEPTION and END
BEGIN and END

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

It produces the output Procedure B calling C
It produces the output Procedure C calling B
It produces a compilation error because procedure C requires a forward declaration
It produces a compilation error because procedure B requires a forward declaration.
It produces a compilation error because identified g_value is not declared in procedure A

A Rollback statement cannot be used to close transaction.

technology databases

True
False

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

technology databases

Explicit Cursor
Implicit Cursor
Active Data Set
None of the above

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

A stored procedure on the server.
A block of code in a PL/SQL library.
A standalone procedure on the client machine.
A block of code in the body of the program unit ORDERTOTAL.
A local subprogram defined within the program unit ORDERTOTAL.

- Hide questions