1z0-063 by Oracle Actual Free Exam Questions And Answers

Question 1

Which three statements are true about Oracle Restart? (Choose three.)

A. It can be used to only start Oracle components.

B. It can be configured to automatically restart a database in case of normal shutdown of the database instance.

C. While starting any components, it automatically attempts to start all dependencies first and in proper order.

D. It can be configured to automatically attempt to restart various components after a hardware or software failure.

E. It runs periodic check operations to monitor the health of Oracle components.

Discussion 0

Correct Answer: C,D,E Vote an answer

Question 2

You execute the command to recover your database:

Which statement is true?

A. It restores all data files and control files from the most recent backup taken before the "until time", and then recovers up to the "until time" using any restored archive logs that are needed to complete the task.

B. It restores the control file and all data files from the most recent backups, and then applies the redo logs up to the "until time".

C. It restores all data files from the specified time, and then applies the redo logs.

D. It restores all data files, redo log files, and control files, and then applies the redo logs up to the specified time.

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 3

RMAN is connected to the target database PROD1 and an auxiliary instance in NOMOUNT state. Examine the command to create a duplicate database:

Which two statements are true about the execution of the DUPLICATE command? (Choose two.)

A. All archive redo log files are automatically copied to the duplicate database.

B. The password file and SPFILE for the duplicate database DUP1 are created in their respective default locations.

C. The duplicate database is created by using the backups created during the execution of the DUPLICATE command.

D. The duplicate database is created without using RMAN backups and PROD1 is allowed to remain open during duplication.

E. The duplicate database has the same directory structure as the source database.

Discussion 0

Correct Answer: D,E Vote an answer

Question 4

Examine these Data Pump commands to export and import objects from and to the same database.
The dba has not yet created users hr1 and oe1.
$expdp system/manager
schemas = hr.oe
directory = EXP_DIR
dumpfile = export.dat
include = table
$ impdpsysten/manager
schemas = hr1,oe1
directory = EXP_DIR
dumpfile = export.dat
remap_schena=hr:hrl, oe:oe1
What will happen when running these commands?

A. expdp will succeed but impdp will fail because the users do not exist.

B. impdp will create two users called hr1 and oe1 and import only the tables owned by hr and oe schemas to ht1 and oe1 schemas, respectively.

C. inpdp will create two users called hr1 and oe1 and import all objects to the new schemas.

D. expdp will fail because no path has been defined for the dumpfile.

Discussion 0

Correct Answer: A Vote an answer

Question 5

Which three statements are true about persistent lightweight jobs? (Choose three.)

A. A user cannot set privileges on them.

B. They generate large amounts of metadata.

C. They are useful when users need to create a large number of jobs quickly.

D. They may be created as fully self-contained jobs.

E. They must reference an existing Scheduler Program.

Discussion 0

Correct Answer: A,C,E Vote an answer

Question 6

You want to create a guaranteed restore point for one of your databases by executing the command:
SQL> CREATE RESTORE POINT dbrsp1 GUARANTEE FLASHBACK DATABASE;
Which two are required for the successful execution? (Choose two.)

A. The database must be mounted.

B. The database must be opened.

C. The database must be in ARCHIVELOG mode.

D. The Fast Recovery Area must be configured.

E. Undo retention guarantee must be enabled.

F. Flashback Database must be enabled.

Discussion 0

Correct Answer: C,D Vote an answer

Question 7

You created a database with DBCA by using one of the Oracle supplied templates.
Which is the default permanent tablespace for all users except DBSNMP and OUTLN?

A. USERS

B. SYSAUX

C. SYSTEM

D. EXAMPLE

Discussion 0

Correct Answer: C Vote an answer

Question 8

Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)

A. The ADR can be used for problem diagnosis even when the database instance is down.

B. The ADR can be used to store statspack snapshots to diagnose database performance issues.

C. The ADR is used to store Automatic Workload Repository (AWR) snapshots.

D. The ADR base is shared across multiple instances.

E. The ADR base keeps all diagnostic information in binary format.

Discussion 0

Correct Answer: A,D Vote an answer

Question 9

Examine the steps/operations performed during the RMAN backup operation by using Oracle Secure Backup (OSB):
1. Start the RMAN client by using the RMAN TARGET / command.
2. Start the RMAN client by using the OSB user.
3. RMAN creates the backup pieces.
4. Run the RMAN BACKUP command with the SBT channels.
5. OSB creates a backup job and assigns a unique identifier.
6. OSB creates a backup job request through the OSB SBT library.
7. OSB stores metadata about RMAN backup pieces in the OSB catalog.
8. OSB starts the backup operation.
9. OSB updates the RMAN catalog.
Identify the required steps/operations performed in correct order.

A. 2, 4, 5, 8, 3, 7, 9

B. 1, 4, 6, 5, 8, 3, 9

C. 1, 6, 4, 5, 8, 3, 9

D. 2, 4, 6, 5, 8, 3, 7

Discussion 0

Correct Answer: D Vote an answer

Question 10

Which two statements are true about encrypted backups performed by using RMAN? (Choose two.)

A. Image copy backups can be created by using password encryption.

B. A database uses the same encryption key for every encrypted backup.

C. Encrypted backups can only be written to disk.

D. Transparent encryption of backups uses an encryption wallet.

E. A password encryption of backups uses the password while creating and restoring backups.

Discussion 0

Correct Answer: D,E Vote an answer

Question 11

Which two are true about incremental backups? (Choose two.)

A. A backup set can be used as the baseline for an incremental backup.

B. An image copy can be used as the baseline for an incremental backup.

C. Differential backups can be taken at level 0.

D. A database incremental level 0 backup always backs up all database blocks.

E. Incremental backups are not permitted when using block change tracking.

F. A tablespace incremental level 1 backup always backs up all blocks in the backed up tablespace.

Discussion 0

Correct Answer: D,F Vote an answer

Question 12

You are administering a multitenant container database (CDB) cdb1.
Examine the command and its output:
SQL>show parameterfile
NAME TYPE VALUE
----------------------------------------------------------------------- db_create_file_dest string db_file_name_convert string db_files integer 200 You verify that sufficient disk space is available and that no file currently exists in the
'/u0l/app/oracle/oradata/cdb1/salesdb' location.
You plan to create a new pluggable database (PDB) by using the command:
SQL>CREATEPLUGGABLEDATABASESALESPDB
ADMINUSER salesadm IDENTIFIED BY password;
ROLES=(dba)
DEFAULTTABLESPACE sales
DATAFILE' /u01/app/oracle/oradata/cdb1/salesdb/sales01.dbf'SIZE 250M AUTOEXTEND ON FILE_NAME_CONVERT=('/u01/app/oracle/oradata/cdb1/pdbseed/',
'/u01/app/oracle/oradata/cdb1/salesdb/')
STORAGE(MAXSIZE2G)
PATK_PREFIX='/u01/app/oracle/oradata/cdb1/SALESPDB';
Which statement is true?

A. SALESPDB is created and is in mount state.

B. PDB creation fails because a default temporary tablespace is not defined for SALESPDB.

C. PDB creation fails because the db_file_name_convert parameter is not set in the CDB.

D. SALESPDB is created and is in read/write mode.

Discussion 0

Correct Answer: A Vote an answer

Question 13

Examine the parameters for your database instance:
NAME TYPE VALUE
------------------------------------------------
optimizer_adaptive_reporting_only boolean FALSE
optimizer_capture_sql_plan_baselines boolean FALSE
optimizer_dynamic_sampling integer 2
optimizer_features_enable string 12.1.0.1
Which three statements are true about the process of automatic optimization by using statistics feedback?
(Choose three.)

A. The optimizer enables monitoring for cardinality feedback after the first execution of a query.

B. After the optimizer identifies a query as a re-optimization candidate, statistics collected by the collectors are submitted to the optimizer.

C. The optimizer can re optimize a query only once using cardinality feedback.

D. 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.

E. The optimizer does not monitor cardinality feedback if dynamic sampling and multicolumn statistics are enabled.

Discussion 0

Correct Answer: A,B,D Vote an answer

Question 14

You are connected to a pluggable database (PDB) as a common user with the SYSDBA privilege. The PDB is open and you issue the SHUTDOWN IMMEDIATE command.
What is the outcome?

A. The command executes only if the common user is granted the SET CONTAINER privilege for the PDB.

B. The PDB is closed and left in the unmount state.

C. The command results in an error because the PDB can be shut down only by a local user.

D. The PDB is closed and left in the mount state.

Discussion 0

Correct Answer: B Vote an answer

Oracle Database 12c: Advanced Administration - 1z0-063 Exam Practice Test

Contact Us

Useful Links

Latest Updated