Answer d explanation rman will generate several

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: RMAN will generate several backupsets, one for each block size, when you issue the RMAN BACKUP command. Answer: D Explanation: RMAN will generate several backupsets, one for each block size, when you issue the RMAN BACKUP command. Incorrect Answers 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 size. 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 BACKUP command. 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 QUESTION 115: 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 immediately? A. Execute a full table scan of the EMPLOYEES table. B. Execute the command ANALYZE TABLE employees COMPUTE STATISTICS. C. Execute the command DBMS_STATS.GATHER_TABLE_STATISTICS on the EMPLOYEES table. D. Execute the DBMS_REPAIR.SEGMENT_FIX_STATUS procedure on the EMPLOYEES table. Answer: D Actualtests.com - The Power of Knowing 1Z0-030 QUESTION 116: 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 QUESTION 117: Orcale9i supports the creation of constraints on views. Which constraint states are supported? A. enforced B. EXCEPTIONS INTO clause C. [RELY|NORELY] DISABLE NOVALIDATE D. ON DELETE actions for foreign key constraints Answer: C QUESTION 118: 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 Oracle En...
View Full Document

Ask a homework question - tutors are online