This preview shows page 1. Sign up to view the full content.
Unformatted text preview: RMAN will generate several backupsets, one for
each block size, when you issue the RMAN BACKUP command.
RMAN will generate several backupsets, one for each block size, when you issue the
RMAN BACKUP command.
A: You don't have to issue a separate RMAN BACKUP command to group tablespaces
with the same block size. RMAN will generate several backupsets, one for each block
B: You don't need to use the RMAN BACKUP BLOCKSIZE=nK command to backup
these tablespaces with different block sizes.
C: One backup set cannot contain tablespaces of different block sizes. But RMAN will
generate several backupsets, one for each block size when you issue the RMAN
OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 183-189
Chapter 3: Manageability Enhancements
Oracle 9i New Features, Robert Freeman, p. 79-86
Chapter 3: New Oracle9i Availability and Recoverability Features
After changing the PCTFREE value of the automatic space management table
EMPLOYEES, which task can you perform in order for your change to take affect
A. Execute a full table scan of the EMPLOYEES table.
B. Execute the command ANALYZE TABLE employees COMPUTE
C. Execute the command DBMS_STATS.GATHER_TABLE_STATISTICS on the
D. Execute the DBMS_REPAIR.SEGMENT_FIX_STATUS procedure on the
Answer: D Actualtests.com - The Power of Knowing 1Z0-030
The dbms_logmnr_d.build database procedure allows the extraction of the data
dictionary to a flat file, or to the online redo log files in Oracle9i.
What are three benefits of using the online redo logs files for the data dictionary
storage? (Choose three)
A. Can be captured when the database is unmounted.
B. Allows for faster extraction than that to a flat file.
C. Can be used when the database is in NOARCHIVELOG mode.
D. Used with the DDL Tracking option, it ensures that the dictionary in use is
consistent with the data being analyzed.
E. Avoids the management of a different set of files, as the dictionary information is
available in the redo stream.
Answer: B, D, E
Orcale9i supports the creation of constraints on views.
Which constraint states are supported?
B. EXCEPTIONS INTO clause
C. [RELY|NORELY] DISABLE NOVALIDATE
D. ON DELETE actions for foreign key constraints
Which three statements are true about the implementation and functionality of
Fine- Grained Auditing (FGA)? (Choose three)
A. FGA is defined and enabled by calling DBMS_FGA procedures.
B. FGA enabled a procedure to be executed when sensitive data is accessed.
C. FGA is enabled by the AUDIT statement for each row of a table.
D. The triggering of an audit of a row access is limited to defined range of values of
the primary key only.
E. The triggering of an audit of a row access is defined by a general WHERE clause
for any row condition.
Answer: A, B, E
QUESTION 119: Actualtests.com - The Power of Knowing 1Z0-030
View Full Document
- Fall '09