Oracle Database 12c: Installation and Administration
Question No: 111
Your database instance has started using an SPFILE. Examine the RMAN configuration settings:
You execute the command:
RMANgt; BACKUP AS COPY TABLESPACETEST;
Which three types of files are backed up by using this command?
online redo log files
archived redo log files
Answer: B,C,E Explanation:
Question No: 112
Your database is open and the listener LISTNENER is up. You issue the command: LSNRCTLgt; RELOAD
What is the effect of reload on sessions that were originally established by listener?
Only sessions based on static listener registrations are disconnected.
Existing connections are not disconnected; however, they cannot perform any operations until the listener completes the re-registration of the database instance and service handlers.
The sessions are not affected and continue to function normally.
All the sessions are terminated and active transactions are rolled back.
Question No: 113
Which action takes place when a file checkpoint occurs?
The checkpoint position is advanced in the checkpoint queue.
All buffers for a checkpointed file that were modified before a specific SCN are written to disk by DBWnand the SCN is stored in the control file.
The Database Writer process (DBWn) writes all dirty buffers in the buffer cache to data files.
The Log Writer process (LGWR) writes all redo entries in the log buffer to online redo log files.
Question No: 114
You executed a DROP USER CASCADE on an Oracle 11g release 1 database and immediately realized that you forgot to copy the OCA.EXAM_RESULTS table to the OCP schema.
The RECYCLE_BIN enabled before the DROP USER was executed and the OCP user has
been granted the FLASHBACK ANY TABLE system privilege.
What is the quickest way to recoverthe contents of the OCA.EXAM_RESULTS table to the OCP schema?
Execute FLASHBACK TABLE OCA.EXAM_RESULTS TO BEFORE DROP RENAME TO OCP.EXAM_RESULTS; connected as SYSTEM.
Recover the table using traditional Tablespace Point In Time Recovery.
Recoverthe table using Automated Tablespace Point In Time Recovery.
Recovery the table using Database Point In Time Recovery.
Execute FLASHBACK TABLE OCA.EXAM_RESULTS TO BEFORE DROP RENAME TO EXAM_RESULTS; connected as the OCP user.
Answer: C Explanation:
RMAN tablespace point-in-time recovery (TSPITR).
Recovery Manager (RMAN) TSPITR enables quick recovery of one or more tablespaces in a database to an earlier time without affecting the rest of the tablespaces and objects in the database.
Fully Automated(the default)
In this mode, RMAN manages the entire TSPITR process including the auxiliary instance. You specify the tablespaces of the recovery set, an auxiliary destination, the target time, and you allow RMAN to manage all other aspects of TSPITR.
Thedefault mode is recommended unless you specifically need more control over the location of recovery set files after TSPITR, auxiliary set files during TSPITR, channel settings and parameters or some other aspect of your auxiliary instance.
Question No: 115
Which two statementsare true about Oracle Managed Files (OMF)?
OMF cannot be used in a database that already has data files created with user-
The file system directions that are specified by OMF parameters are created automatically.
OMF can beused with ASM disk groups, as well as with raw devices, for better file management.
OMF automatically creates unique file names for table spaces and control files.
OMF may affect the location of the redo log files and archived log files.
Answer: D,E Explanation:
D: The database internally uses standard file system interfaces to create and delete files as needed for the following database structures:
Tablespaces Redo log files Control files Archived logs
Block change tracking files Flashback logs
* Using Oracle-managed files simplifies the administration of an Oracle Database. Oracle- managed files eliminate the need for you, the DBA, to directly manage the operating system files that make up an Oracle Database. With Oracle-managed files, you specify file system directories in which the database automatically creates, names, and manages files at the database object level. For example, you need only specify that you want to create a tablespace; you do not need to specify the name and path of the tablespace#39;s datafile with the DATAFILE clause.
http://www.oracle-base.com/articles/9i/oracle-managed-files.php http://docs.oracle.com/cd/B10500_01/server.920/a96521/omf.htm References:
Question No: 116
Which three statements are true about SQL plan directives?
They are tied to a specific statement or SQL ID.
They instruct the maintenance job to collect missing statistics or perform dynamic sampling to generate a more optimal plan.
They are used to gather only missing statistics.
Theyare created for a query expression where statistics are missing or the cardinality estimates by the optimizer are incorrect.
They instruct the optimizer to create only column group statistics.
Improve plan accuracy by persisting both compilation andexecution statistics in the SYSAUX tablespace.
Answer: B,D,E Explanation:
During SQL execution, if a cardinality misestimate occurs, then the database creates SQL plan directives. During SQL compilation, the optimizer examines the query corresponding tothe directive to determine whether missing extensions or histograms exist (D). The optimizer records any missing extensions. Subsequent DBMS_STATS calls collect statistics for the extensions.
The optimizer uses dynamic sampling whenever it does not have sufficient statistics corresponding to the directive. (B, not C)
E: Currently, the optimizer monitors only column groups. The optimizer does not create an extension on expressions.
Not A: SQL plan directives are not tied to a specific SQL statement or SQL ID.
* A SQL plan directive is additional information and instructions that the optimizer can use to generate a more optimal plan. For example, a SQL plan directive can instruct the optimizer to record a missing extension.
Question No: 117
What happens if a maintenance window closes before a job that collects optimizer statistics completes?
The job is terminated and the gatheredstatistics are not saved.
The job is terminated but the gathered statistics are not published.
The job continues to run until all statistics are gathered.
The job is terminated and statistics for the remaining objects are collected the next time the maintenance window opens.
Question No: 118
Which two categories of segments are analyzed by the Automatic Segment Advisor?
segments in tablespaces that have exceeded a critical or warning space threshold
segments that have the highest growth rate in a database
segments that are sparsely populated and have more than 10% of free space below the high water mark.
segments that have unusable indexes
segmentsfor tables created using ADVANCED ROW COMPRESSION
Answer: A,B Explanation:
Question No: 119
A database uses Automatic Storage Management (ASM) as database storage, which has a diskgroup, DATA1, which is created as follows:
What happens whenthe FAILGRP1 failure group is corrupted?
Mirroring of allocation units occurs within the FAILGRP2 failure group.
Transactions that are using the diskgroup fail.
ASM does not mirror any data and newly allocated primary allocation units (AU) arestored in the FAILGRP2 failure group.
Data in the FAILGRP1 failure group is moved to the FAILGRP2 failure group and rebalancing is started.
Question No: 120
Your database is configured in ARCHIVELOG mode, and daily full database backups are taken. RMAN is configured to perform control file autobackups.
Which statement is true about the loss of aduplexed control file?
The database remains open but transactions are not permitted.
The database instance aborts, and media recovery is required after restoration of the control file to open the database.
The database instance remains open and the control file can be restored without shutting down the database.
The database instance aborts and a control file restore operation does not require media recovery.
100% Free Download!
–Download Free Demo:1z0-062 Demo PDF
100% Pass Guaranteed!
–Download 2018 Latesttests 1z0-062 Full Exam PDF and VCE
|Lowest Price Guarantee||Yes||No||No|
|Free VCE Simulator||Yes||No||No|