PassLeader now are offering 100% pass ensure 1Z0-063 dumps! All 1Z0-063 exam questions have been updated with correct answers, welcome to download the newest PassLeader 1Z0-063 VCE dumps and PDF dumps: http://www.passleader.com/1z0-063.html (180 Q&As –> 236 Q&As)
BTW: Download PassLeader 1Z0-063 dumps from Google Drive for free: https://drive.google.com/open?id=0B-ob6L_QjGLpUjhWdDA4ZmNlLTg
QUESTION 127
Identify three benefits of unified auditing.
A. It helps to reduce disk space used to store an audit trail in a database.
B. It guarantees zero-loss auditing.
C. It reduces overhead on a database caused by auditing,by having a single audit trail.
D. An audit trail cannot be modified because it is read-only.
E. It automatically audits Recovery Manager (RMAN) events.
Answer: CDE
QUESTION 128
You notice that the performance of your production 24/7 Oracle 12c database has significantly degraded. Sometimes you are not able to connect to the instance because it hangs. You do not want to restart the database instance. How can you detect the cause of the degraded performance?
A. Enable Memory Access Mode, which reads performance data from SGA.
B. Use emergency monitoring to fetch data directly from SGA for analysis.
C. Run Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest Automatic Workload Repository (AWR) snapshots.
D. Use Active Session History (ASH) data and hang analysis in regular performance monitoring.
E. Run ADDM in diagnostic mode.
Answer: C
QUESTION 129
Examine the command used to perform an incrementallevel-0 backup:
RMAN>BACKUPINCREMENTALLEVEL0DATABASE;
To enable block change tracking, after the incremental level 0 backup, you issue the command:
SQL>ALTERDATABASEENABLEBLOCKCHANGETRACKINGUSING
FILE’/mydir/rman_change_track.f’;
To perform an incremental level-1 cumulative backup, you issue the command:
RMAN>BACKUPINCREMENTALLEVEL1CUMULATIVEDATABASE;
Which two statements are true in the preceding situation?
A. The block change tracking data is used only from the next incremental backup.
B. The incremental level 1 backup fails because a block change tracking file Is created after the level 0 backup.
C. The incremental level 1 backup does not use change tracking data for accomplishing the backup.
D. The block change tracking file scans all blocks and creates a bitmap for the blocks backed up in the level 0 backup.
E. The block change tracking data is used for the next incremental level 1 backup only after the next level 0 backup.
Answer: CE
QUESTION 130
You want to migrate your Oracle 11g database as a pluggable database (PDB) in a multitenant container database (CDB). The following are the possible steps to accomplish this task:
1. Place all the user-defined tablespace in read-only mode on the source database.
2. Upgrade the source database to a 12c version.
3. Create a new PDB in the target container database.
4. Perform a full transportable export on the source database withthe VERSION parameter set to 12 using the expdp utility.
5. Copy the associated data files and export the dump file to the desired location in the target database.
6. Invoke the Data Pump import utility on the new PDB database as a user with the DATAPUMP_IMP_FULL_DATABASE role and specify the full transportable import options.
7. Synchronize the PDB on the target container database by using the DBMS_PDS.SYNC_ODB function.
Identify the correct order of the required steps.
A. 2, 1, 3, 4, 5, 6
B. 1, 3, 4, 5, 6, 7
C. 1, 4, 3, 5, 6, 7
D. 2, 1, 3, 4, 5, 6, 7
E. 1, 5, 6, 4, 3, 2
Answer: C
QUESTION 131
Which four actions are possible during an Online Datafile Move operation?
A. Creating and dropping tables in the datafile being moved
B. Performing file shrink of the data file being moved
C. Querying tables in the datafile being moved
D. Performing Block Media Recovery for a data block in the datafile being moved
E. Flashing back the database
F. Executing DML statements on objects stored in the datafile being moved
Answer: ACEF
QUESTION 132
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 unlimited quota 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: DF
QUESTION 133
Which three statements are true about the startup and shutdown of multitenant container databases (CDBs) and pluggable databases (PDBs)?
A. A PDB opened in restricted mode allows only local users to connect.
B. When a CDB is open in restricted mode, PDBs must also be opened in restricted mode.
C. When a CDB is in mount state, PDBs are automatically placed in mount state.
D. All PDBs must be shut down before shutting down a CDB instance.
E. When a CDB instance is started, PDBs can be placed in open state by using database triggers or by executing the alter pluggable database command.
Answer:
QUESTION 134
After implementing full Oracle Data Redaction, you change the default value for the number data type as follows:
SQL> SELECT NUMBER_VALUE FROM REDACTION_VALUES_FOR_TYPE_FULL; NUMBER_VALUE 0
SQL> EXEC DBMS_REDACT.UPDATE_FULL_REDACTI0N_VALUES(-1)
PL/SQL procedure successfully completed.
SQL> select number_value from redaction_values_for_type_full; NUMBER VALUE -1
After changing the value, you notice that FULL redaction continues to redact numeric data with a zero. What must you do to activate the new default value for numeric full redaction?
A. Re-enable redaction policies that use FULL data redaction.
B. Re-create redaction policies that use FULL data redaction.
C. Re-connect the sessions that access objects with redaction policies defined on them.
D. Flush the shared pool.
E. Restart the database instance.
Answer: E
QUESTION 135
Your database instance is started using an SPFILE. You are connected to cdb$root, as a DBA. You issue:
SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SCOPE=BOTH;
Which two statements are true about the statistics level parameter?
A. It is immediately set to all in the SPFILE and the CDB instance.
B. It is immediately set to all in only those pluggable databases (PDBs) where the value is set to typical.
C. It is immediately set to all only for cd3Sroot.
D. It is immediately set to all in all PDBs where the statistics_level parameter is not set.
E. It is set to all for all PDBs only in the SPFILE.
Answer: A
QUESTION 136
Examine the commands:
SQL> ALTER SESSION SET RECYCLBIN = ON;
Session altered.
SQL> DROP TABLE emp; –(First EMP table)
Total dropped.
SQL> CREATE TABLE emp (id NUMBER CONSTRAINT emp_id_idx PRIMARY KEY, name VARCHAR2 (15), salary NUMBER(7,2) );
Table created.
You then execute multiple INSERT statements to insert rows into EMP table and drop the table again:
SQL> DROP TABLE emp; — (Second EMP table)
Table dropped.
SQL> FLASHBACK TABLE emp TO BEFORE DROP;
Which statement is true about the FLASHBACK command?
A. It recovers the structure, data, and indexes of the first emp table.
B. It recovers only the structure of the second emp table.
C. It returns an error because two tables with the same name exist in the recycle bin.
D. It recovers the structure, data, and indexes of the second emp table.
Answer: A
QUESTION 137
In your database, there are tablespaces that were read-only when the last backup was taken. These tablespaces have not been made read/write since then. You want to perform an incomplete recovery on the database by using a backup control file. What precaution must you take for the read-only tablespaces before performing an incomplete recovery?
A. All the read-only tablespaces should be taken offline.
B. All the read-only tablespaces should be restored separately.
C. All the read-only tablespaces should be renamed to have the MISSINGnnnn format.
D. All the read-only tablespaces should be made online with logging disabled.
Answer:
QUESTION 138
Which three statements are true about Oracle Secure Backup (OSB)?
A. It can encrypt client data written to tape.
B. It can be used to take image copy backups to tape.
C. It can be used to manage tape backup and restore operations for multiple databases.
D. It can be used along with an RMAN recovery catalog for maintaining records of backups in a tape library.
E. It can be used to perform file system backups at the file, directory, file system, or raw partition level.
Answer: ACE
QUESTION 139
Which three statements are true about compression of backup sets?
A. Compressed backups can only be written to media.
B. Binary compression creates performance overhead during a backup operation.
C. Unused blocks below the high-water mark are not backed up.
D. Compressed backups cannot have section size defined during a backup operation
E. It works only for locally managed tablespaces.
Answer: BCE
QUESTION 140
As part of a manual upgrade process, after installing the software for Oracle Database 12c and preparing the new Oracle home, you shut down the existing single-instance database. Which step should you perform next to start the upgrade of the database?
A. Start up the database instance by using the new location of the server parameter file and run the catuppst.sqi script to generate informational messages and log files during the upgrade.
B. Start up the database instance by using the new location of the server parameter file and run the cact1.pl script from the new Oracle home to use parallel upgrade options that reduce down time.
C. Start up the database instance by using the STARTUP UPGRADE command and gather fixed object statistics to minimize the time needed for recompilation.
D. Start up the database instance by using the STARTUP UPGRADE command, which opens the existing database, and then performs additional upgrade operations.
Answer: C
PassLeader now are offering 100% pass ensure 1Z0-063 dumps! All 1Z0-063 exam questions have been updated with correct answers, welcome to download the newest PassLeader 1Z0-063 VCE dumps and PDF dumps: http://www.passleader.com/1z0-063.html (180 Q&As –> 236 Q&As)
BTW: Download PassLeader 1Z0-063 dumps from Google Drive for free: https://drive.google.com/open?id=0B-ob6L_QjGLpUjhWdDA4ZmNlLTg