When setting up the Flashback Data Archive, which of these key parameters are required?
(Choose all that apply.)
A. Tablespace name
B. Storage quota
D. Table name
E. Create a default archive
To clean up old records that are in a Flashback Data Archive and are past the retention period, what must the DBA do?
A. TRUNCATE the archive table.
B. DROP the Flashback Data Archive.
C. Nothing; expired rows are automatically removed.
D. Nothing; expired rows are moved to an archive table.
E. Delete entries from the archive where the metadata date retained is greater than the retention period.
Which of the following initialization parameters have been deprecated in Oracle 11g because of the introduction of the Automatic Workload Repository? (Choose all that apply.)
F. All of the above
Which of the following statements is true regarding the initialization parameter DIAGNOSTIC_DEST?
A. The default value is the value of the environment variable $ORACLE_HOME; if $ORACLE_HOME isn’t set,
then the default is set to $ORACLE_BASE.
B. The default value is the value of the environment variable $ORACLE_BASE; if $ORACLE_BASE isn’t set,
then it is set to $ORACLE_HOME.
C. DIAGNOSTIC_DEST is always equal to $ORACLE_HOME.
D. DIAGNOSTIC_DEST is always equal to $ORACLE_BASE.
Which of these formats represents the correct hierarchy for the ADR?
D. None of the above
Which of the following are not fundamental tasks of the Support Workbench? (Choose all that apply.)
A. View long-running SQL workloads
B. View problem details
C. Gather additional diagnostic information
D. Create a Service Request
E. Clean up incident data after upload to Oracle Support
Which of the following tasks does the tool Incident Packaging Service (IPS) perform?
A. Cleans up the ADR by deleting files not associated with an incident uploaded to Oracle Support.
B. Identifies all files associated with a critical error and adds them to a zip file to be sent to Oracle Support.
C. Automatically opens a Service Request with Oracle Support for each critical error and sends all relevant files.
D. Displays a high-level view of critical errors on the database home page.
Choose the correct order to package and upload data for an incident to Oracle Support.
A. Schedule, create new package, view manifest, view contents
B. Create new package, view manifest, view contents, schedule
C. Schedule, create new package, view contents, view manifest
D. Create new package, view contents, view manifest, schedule
E. None of the above.
Which of the following is not an advantage of block media recovery (BMR)?
A. Reduced MTTR.
B. Datafiles remain offline while corrupt blocks are repaired.
C. Datafiles remain online while corrupt blocks are repaired.
D. A and C
Which of the following methods can be used to detect block corruption?
A. ANALYZE operations
C. SQL queries that access the potentially corrupt block
E. All of the above
Identification of Corrupt Blocks
The V$DATABASE_BLOCK_CORRUPTION view displays blocks marked corrupt by database components such as RMAN, ANALYZE, dbv, and SQL queries. The following types of corruption result in the addition of rows to this view:
Physical corruption (sometimes called media corruption)
The database does not recognize the block: the checksum is invalid, the block contains all zeros, or the block header is corrupt.
Physical corruption checking is enabled by default. You can turn off checksum checking by specifying the NOCHECKSUM option of the BACKUP command, but other physical consistency checks, such as checks of the block headers and footers, cannot be disabled.
The block has a valid checksum, the header and footer match, and so on, but the contents are logically inconsistent. Block media recovery may not be able to repair all logical block corruptions. In these cases, alternate recovery methods, such as tablespace point-in-time recovery, or dropping and re-creating the affected objects, may repair the corruption.
Logical corruption checking is disabled by default. You can turn it on by specifying the CHECK LOGICAL option of the BACKUP, RESTORE, RECOVER, and VALIDATEcommands.
The database can detect some corruptions by validating relationships between blocks and segments, but cannot detect them by a check of an individual block. The V$DATABASE_BLOCK_CORRUPTION view does not record at this level of granularity.
If you want to pass Oracle 1Z0-053 successfully, donot missing to read latest lead2pass Oracle 1Z0-053 practice exams.
If you can master all lead2pass questions you will able to pass 100% guaranteed.
|One Time Purchase||✔||✖||✖||✖||✖|
|100% Pass Guarantee||✔||✖||✖||✖||✖|
|100% Money Back||✔||✖||✖||✖||✖|