Act now and download your Oracle 1Z0-063 test today! Do not waste time for the worthless Oracle 1Z0-063 tutorials. Download Replace Oracle Oracle Database 12c: Advanced Administration exam with real questions and answers and begin to learn Oracle 1Z0-063 with a classic professional.
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for Oracle 1Z0-063 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Free Instant Download NEW 1Z0-063 Exam Dumps (PDF & VCE):
Available on:
http://www.surepassexam.com/1Z0-063-exam-dumps.html
Q51. Yourdatabase supports an OLTP workload. Examine the output of the query:
SQL> SSLECT target_mttr, estimated_mttr FROM v$instance_recovery Target_mttrestimated_mttr
To ensure faster instance recovery, youset the fast_start_mttrjtargh:t initialization parameter to
30.
What is the effect of this setting on the database?
A. Automatic checkpoint tuning is disabled.
B. The frequency of log switches is increased.
C. The overhead on database performance is increased because of frequent writes to disk.
D. The MTTR advisor is disabled.
Answer: A
Q52. Which two are prerequisites for setting up Flashback Data Archive?
A. Fast Recovery Area should be defined.
B. Undo retention guarantee should be enabled.
C. Supplemental logging should be enabled.
D. Automatic Undo Management should be enabled.
E. All users using Flashback Data Archive should have unlimitedquota on the Flashback Data Archive tablespace.
F. The tablespace in which the Flashback Data Archive is created should have Automatic Segment Space Management (ASSM) enabled.
Answer: D,F
Reference:http://www.oracle.com/technetwork/database/focus-areas/storage/total-recall-whitepaper-171749.pdf(page 8)
Q53. Examine the RMAN command:
RMAN> BACKUP VALIDATE DATABASE;
Which statement is true about the execution of the command?
A. Block change tracking must be enabled before executing this command.
B. The database must be running in archivelog mode for the successful execution of this command.
C. A complete database backup must exist before executing this command.
D. The command checks for blocks containing all zeros, an invalid checksum, or a corrupt block header.
E. The command checks for blocks that contain a valid checksum and matching headers and footers, but that has logically inconsistentcontents.
Answer: D
Q54. Examine the command to back up the ASM metadata:
ASMCMD>md_backup /backup/ASM_backup
In which three situations can you use the backup?
A. when one or more disks in an ASM disk group are lost
B. when the data file on an ASM disk group gets corrupted
C. when one of the disks in a disk group is accidentally unplugged
D. when one or more file directory paths are accidentally deleted from an ASM disk group
E. when all the ASM disk groups for the ASM instance are lost
Answer: B,C,D
Q55. Which two statements are true regarding SecureFile lobs?
A. The amount of undo retained is user controlled.
B. They can be used only for nonpartitioned tables.
C. Fragmentation is minimized by using variable-sized chunks.
D. They support random reads and writes of encrypted LOB data.
Answer: C,D
Reference:http://docs.oracle.com/cd/E11882_01/appdev.112/e18294/adlob_smart.htm#AD LOB46113
Q56. You restore and recover your database to anew host by using an existing RMAN open database backup.
Which step must you perform next?
A. Execute catproc.sqi to recompile invalid PL/SQL modules.
B. Open the database with the resetlogs option.
C. Set a new database identifier (DBID) for the newly restored database.
D. Use the RMAN set newname and switch commands to switch to new files.
Answer: A
Q57. You are administering a multitenant container database (CDB).
Identify two ways to access a pluggable database (PDB) that is open in read-only mode.
A. by using the connect statement as a local user having only the set container privilege
B. by using easy connect
C. by using external authentication
D. as a common user with the set container privilege
E. by executing the alter session set container command as a local user
Answer: A,D
Q58. Examine the parameters for your database instance:
NAMETYPEVALUE
optimizer_adaptive_reporting_onlybooleanFALSE
optimizer_capture_sql_plan_baselinesbooleanFALSE
optimizer_dynamic_samplinginteger2
optimizer_features_enablestring12.1.0.1
Which three statements are true about the process of automatic optimization by using statistics feedback?
A. The optimizer automatically changes a plan during subsequent execution of a SQL statement if there is a huge difference in optimizer estimates and execution statistics.
B. The optimizer can re optimize a query only once using cardinality feedback.
C. The optimizer enables monitoring for cardinality feedback after the first execution of a query.
D. The optimizer doesnot monitor cardinality feedback if dynamic sampling and multicolumn statistics are enabled.
E. After the optimizer identifies a query as a re-optimization candidate, statistics collected by the collectors are submitted to the optimizer.
Answer: A,C,D
Explanation: C: During the first execution of a SQL statement, an execution plan is generated as usual.
D: if multi-column statistics are not present for the relevant combination of columns, the
optimizer can fall back on cardinality feedback.
(not B)* Cardinality feedback. This feature, enabled by default in 11.2, is intended to
improve plans for repeated executions.
optimizer_dynamic_sampling optimizer_features_enable
Dynamic sampling or multi-column statistics allow the optimizer to more accurately estimate selectivity of conjunctive predicates.
Note:
* OPTIMIZER_DYNAMIC_SAMPLING controls the level of dynamic sampling performed by the optimizer. Range of values. 0 to 10
Cardinality feedback was introduced in Oracle Database 11gR2. The purpose of this feature is toautomatically improve plans for queries that are executed repeatedly, for which the optimizer does not estimate cardinalities in the plan properly. The optimizer may misestimate cardinalities for a variety of reasons, such as missing or inaccurate statistics, or complex predicates. Whatever the reason for the misestimate, cardinality feedback may be able to help.
Q59. LDAP_DIRECTORY_SYSAUTH is set to YES.
Users requiring DBAs access have been granted the sysdba enterpriserole in Oracle Internet Directory(OID). SSL has been configure for the database and OLD and the password file has been
configured for the database.
User scott with sysdba privilege tries to connect remotely using this command:
$sqlplusscott/tiger@DB0l As sysdba where DB01 is the net service name.
Which authentication method will be attempted first?
A. authentication by password file
B. authentication by using certificates over SSL
C. authentication by using the Oracle Internet Directory
D. authentication by using the local OS of the database server
Answer: A
Q60. Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?
A. By default, EM express is available for a database after database creation.
B. You can use EM express to manage multiple databases running on the same server.
C. You can perform basic administrative tasks for pluggable databases by using the EM express interface.
D. You cannot start up or shut down a database instance by using create and configure pluggable databases by using EM express.
E. You can create and configure pluggable databases by using EM express.
Answer: A
Explanation: EM Express is built inside the database.
Note: Oracle Enterprise Manager Database Express (EM Express) is a web-based database management tool that is built inside the Oracle Database. It supports key performance management and basicdatabase administration functions. From an architectural perspective, EM Express has no mid-tier or middleware components, ensuring that its overhead on the database server is negligible.
