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
Q71. You issue the RMAN commands:
RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk;
RKAN> CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COPY;
RMAN>CONFIGURE CONTROLFILE AUTOBACKUP ON;
RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;
Which three tasks are performed by the BACKUP DATABASE command?
A. switching the online redo log file
B. backing up all data files as image copies and archive log files, and deleting those archive log files
C. backing up only the used blocks in the data files
D. backing up all used and unused blocks in the data files
E. backing up allarchived log files and marking them as obsolete
Answer: A,C,E
Q72. You want the execution of large database operations to suspend, and then resume, in the event of space allocation failures.
You set the value of the initialization parameter resumable_timeout to 3600.
Which two statements are true?
A. A resumable statement can be suspended and resumed only once during execution.
B. Data Manipulation Language (DML) operations are resumable, provided that they are not embedded in a PL/SQL block.
C. A suspended statement will report an error if no corrective action has taken place during a timeout period.
D. Before a statement executes in resumable mode, the alter session enable resumable statement must be issued in its session.
E. Suspending a statement automatically results in suspending a transaction and releasing all the resources held by the transaction.
Answer: A,D
Q73. You want to create a guaranteed restore point for your database by executing the command:
SQL> CREATE RESTORE POINT dbrsp1 GUARANTEE FLASHBACK DATABASE;
Identify two prerequisites for the successful execution of this command.
A. The database must be running in archivelog mode.
B. Flashback Database must be enabled.
C. Fast Recovery Area must be enabled.
D. The recyclebin must be enabled for the database.
E. Undo retention guarantee must be enabled.
F. A database backup must be taken.
Answer: A,C
Reference:http://docs.oracle.com/cd/B19306_01/backup.102/b14192/rpfbdb002.htm
Q74. What can be automatically implemented after the SQL Tuning Advisoris run as part of the Automated Maintenance Task?
A. statistics recommendations
B. SQL profile recommendations
C. SQL statement restructure recommendations
D. creation of materialized views to improve query performance
Answer: C
Reference:http://docs.oracle.com/cd/E11882_01/server.112/e16638/sql_tune.htm#PFGRF
Q75. Evaluate these statements:
CREATE TABLE purchase_orders
(po_idNUMBER(4),
po_dateTIMESTAMP,
supplier_idNUM8ER(6),
po_totalNUMBER(8,2), CONSTRAINT order_pk PRIMARY KEY(po_id))
PARTITIONBYRANGE(po_date)
(PARTITIONQ1 VALUESLESSTHAN (TO_DATE('01-apr-2007','dd-mon-yyyy')),
PARTITIONQ2VALUESLESSTHAN(TO_DATE('01-jul-2007','dd-mon-yyyy')), PARTITIONQ3VALUESLESSTHAN (TO~DATE('01-oct-2007','dd-non-yyyy')), PARTITIONQ4VALUESLESSTHAN (TO_DATE('Ol-jan-2008','dd-non-yyyy' )));
CREATETABLEpurchase_order_items
(po_idNUM3ER(4)NOTNULL,
product_idNUMBER(6)NOTNULL,
unit_prlceNUMBER(8,2),
quantity NUMBER(8),
CONSTRAINTpo_items_f k
FOREIGNKEY(po_id)REFERENCESpurchase_orders(po_id) )
PARTITIONBYREFERENCE(po_items_fk);
Which two statements are true?
A. Partitions of purchase_order_items are assigned unique names based on a sequence.
B. The purchase_orders and purchase_order_items tables are created with four partitioneach.
C. purchase_order_items table partitions exist in the same tablespaces as the purchase_orders table partitions.
D. The purckase_order_:teks table inherits the partitioning key by duplicating the key columns from the parent table.
E. Partition maintenance operations on the purchase_order_items table require disabling the foreign key constraint.
Answer: C,E
Q76. Which two statements are true about unified auditing?
A. A unified audit trail captures audit information from unified audit policies and audit settings.
B. Unified auditing is enabled by executing make-fins_rdbms.mk uniaud_onioracle ORACLE_HOME=SORACLE_HOME.
C. Audit records are created for all users except sys.
D. Audit records are created only for the DML and DDL operations performed on database objects.
E. Unified auditing is enabled by setting the audit_trail parameter to db, extended.
F. A unified audit trail resides in a read-only table in the audsys schema in the system tablespace.
Answer: A,F
Q77. Users report this error message when inserting rows into the orders table:
ERROR atline1:
ORA-01654f:unable to extend index USERS.ORDERS_IND by 8in tablespace INDEXES
You determine that the indexes tablespace is out of space and there is no free space on the filesystem used by the Oracle database.
Which two must you do to fix this problem without affecting currently executing queries?
A. drop and re-create the index
B. coalesce the orders.ind index
C. coalesce the indexes tablespace
D. perform an on line table rebuild using dbns_redefir.ition.
E. rebuild the index online moving it to anothertablespace that has enough free space for the index
Answer: A,C
Q78. Which two statements are true about service creation for pluggable databases (PDBs)?
A. When a PDB is created, a service is automatically started in the instance with the same name as the PDB.
B. The defaultservice that is automatically created by a database at the time of PDB creation can be dropped, provided a new additional service is created.
C. A database managed by Oracle Restart can have additional services created or existing services modified by usingthe srvctl utility for each PDB.
D. Only a common user can create additional services for a PDB.
E. When a PDB is created, a service with the same name as the PDB is created in the PDB.
Answer: C,D
Q79. You notice that the performance of your production 24x7 Oracle 12c database has significantly degraded. Sometimes, you are not able toconnect to the database instance because it hangs.
How can you detect the cause of the degraded performance?
A. by performing emergency monitoring using Real-Time Automatic Database Diagnostic Monitor (ADDM) to fetch data directly from SGA for analysis
B. by running ADDM to fetch information from the latest Automatic Workload Repository (AWR) snapshots
C. by using Active Session History (ASH) data and performing hang analysis
D. by running ADDM in diagnostic mode
Answer: B
Q80. You want to consolidate databases for the CRM, ERP, and SCM applications by migrating them to pluggable databases (PDBs).
You have already created a test system to support the consolidation of databases in a multitenant container database (CDB) that has multiple PDBs.
What is the easiest way to perform capacity planning for consolidation?
A. capturing the most resource-intensive SQL statements in a SQL Tuning Set on the production system and using the SQL Performance Analyzer on the test system
B. capturing the workload on the production system and replaying the workload for one PDB at a time on the test system
C. capturing the workload on the production systemand using Consolidated Database Replay to replay the workload of all production systems simultaneously for all PDBs
D. capturing the most resource-intensive SQL statements in a SQL Tuning Set on the production system and using the SQL Tuning Advisor on thetest system
Answer: D
