默认题库 - 1Z0-031

单选题

he DBA is about to enable auditing on the Oracle database in an attempt to discover some suspicious activity. Audit trail information is stored in which of the following database object names?（）

A. SYSOURCE$
B. SYAUD$
C. DBA_SOURCE
DBA_AUDIT_TRAIL

单选题

By default, checkpoints happen at least as often as（）.

A. Redo log switches.
B. UPDATE statements are issued against the database.
C. The SYSTEM tablespace is accessed.
D. SMON coalesces free space in a tablespase.

查看答案

单选题

A table was just created on your Oracle database with six extents allocated to it. Which of the following factors most likely caused the table to have so many extents allocated?（）

A. The value for MINEXTENTS setting
B. The value for PCTINCREASE setting
C. The value for MAXEXTENTS setting
D. By default, Oracle allocates six extents to all database object

查看答案

单选题

In a situation where no multiplexing of redo logs takes place, what happens when Oracle cannot read data from the online redo log group for archiving?（）

A. Nothing happens
B. Oracle will automatically switch redo logs when detected
C. Oracle eventually won't allow new records to be added to the database
D. The instance crashe

查看答案

单选题

ou are implementing control file multiplexing. Which of the following choices identifies the method you can use in order to generate the control file copies that Oracle will maintain?（）

A. Issue ALTER DATABASE BACKUP CONTROLFILE TO filename
B. Make a copy of the control file with the database shut down
C. Issue ALTER DATABASE BACKUP CONTROLFILE TO trace
D. Make a copy of the control file with the database still running&e

查看答案

单选题

You are using the Database Configuration Assistant to configure your Oracle database. Which of the following terms pertains to the creation of an object from which creation of the other database can be based? （）

A. Clone
B. Copy
C. Template
D. Terminal&e

查看答案

单选题

A user issues a SELECT command against the Oracle database. Which of the following choices describes a step that Oracle will execute in support of this statement?（）

Acquire locks on table queried
B. Generate redo for statement
C. Fetch data from disk into memory
D. Write changes to disk

查看答案

单选题

Which of the following choices correctly describes the difference between a data load via the conventional path and the direct path?（）

A. One runs faster than the other
B. A conventional path data load bypasses most of the Oracle RDBMS, whereas a direct path load is a high-speed version of the SQL INSERT
C. A direct path data load bypasses most of the Oracle RDBMS, whereas a conventional path load is a high-speed version of the SQL INSERT
D. The conventional path runs when the CONVENTIONAL command-line parameter is set to TRUE

查看答案

单选题

Your application regularly issues the following statement: SELECT * FROM BANK_ACCT WHERE ACCT_BALANCE BETWEEN 1000 and 10000; Which of the following database objects would be inappropriate for use with this statement?（）

A. Materialized views
B. Indexes
C. Index-organized tables
D. Hash cluster

查看答案

单选题

When determining the number of UNDO segments in a database, which of the following choices identifies a factor to consider? （）

A. Size of typical transactions
B. Concurrent transactions
C. Size of rows in table most frequently changed
D. Number of anticipated disk sort

查看答案