08 February, 2022

The Secret Of Oracle 1Z0-063 Questions

we provide Printable Oracle 1Z0-063 answers which are the best for clearing 1Z0-063 test, and to get certified by Oracle Oracle Database 12c: Advanced Administration. The 1Z0-063 Questions & Answers covers all the knowledge points of the real 1Z0-063 exam. Crack your Oracle 1Z0-063 Exam with latest dumps, guaranteed!

Oracle 1Z0-063 Free Dumps Questions Online, Read and Test Now.

Page: 1 / 19

Total 235 questions Full Exam Access

Question 1

- (Exam Topic 2)
Which three methods can be used to create a pluggable database (PDB) in an existing multitenant container database (CDB)? (Choose three.)

Use PDB$SEED for creating a PDB.

Use the DBMS_PDB package to plug a non-CDB into an existing CDB.

Clone the existing PDB.

Use Enterprise Manager Database Express to create a PDB in an existing CDB.

Use the DBMS_PDB package to plug a pre-Oracle 12c database into an existing CDB.

Question 2

- (Exam Topic 2)
Which Oracle Database component is audited by default if the Unified Auditing option is enabled?

Oracle Data Pump

Oracle Recovery Manager (RMAN)

Oracle Label Security

Oracle Database Vault

Oracle Real Application Security

Question 3

- (Exam Topic 2)
You execute the command to recover your database:
1Z0-063 dumps exhibit

Which statement is true?

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

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

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.

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

Question 4

- (Exam Topic 2)
For which two requirements would you use the Database Resource Manager? (Choose two.)

limiting the CPU used per database call

specifying the maximum number of concurrent sessions allowed for a user

specifying the amount of private space a session can allocate in the shared pool of the SGA

limiting the degree of parallelism of operations performed by a user or group of users

specifying an idle time limit that applies to sessions that are idle and blocking other sessions

Question 5

- (Exam Topic 2)
Which two statements are true regarding SecureFile lobs? (Choose two.)

The amount of undo retained is user controlled.

They can be used only for nonpartitioned tables.

Fragmentation is minimized by using variable-sized chunks.

They support random reads and writes of encrypted LOB data.

Question 6

- (Exam Topic 1)
A database is running in ARCHIVELOG mode. The database contains locally managed tablespaces. Examine the RMAN command:
RMAN> BACKUP
AS COMPRESSED BACKUPSET SECTION SIZE 1024M DATABASE;
Which statement is true about the execution of the command?

The backup succeeds only if all the tablespaces are locally managed.

The backup succeeds only if the RMAN default device for backup is set to disk.

The backup fails because you cannot specify section size for a compressed backup.

The backup succeeds and only the used blocks are backed up with a maximum backup piece size of 1024 MB.

Question 7

- (Exam Topic 1)
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?

USERS

SYSTEM

SYSAUX

EXAMPLE

Question 8

- (Exam Topic 2)
Which three statements are true about unplugging a pluggable database (PDB)? (Choose three.)

A PDB must be in closed state before it can be unplugged.

A PDB must have been opened at least once after creation.

A PDB must be in MOUNT state before it can be unplugged.

PDB data file are automatically removed from disk.

An unplugged PDB can be plugged into the same or another container database (CDB).

Question 9

- (Exam Topic 2)
Which two statements are true about Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)? (Choose two.)

If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that PDB.

In a PDB plan, subplans may be used with up to eight consumer groups.

If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups across all PDBs in the CDB.

If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated.

If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.

Question 10

- (Exam Topic 2)
You execute the commands to configure settings in RMAN:
1Z0-063 dumps exhibit

Then, you issue the following command to take a backup:
1Z0-063 dumps exhibit

Which statement is true about the execution of these commands?

The backup terminates because the backup destination for disk is not specified in the BACKUP command.

It backs up two copies each of the data files to disk and media, and two copies of archived logs to media.

It backup up the data files and archived logs, making one copy of each data file and archived log on disk and media.

It backs up the data files and archived logs to media, making two copies of each data file and archived logs.

Question 11

- (Exam Topic 1)
Your database is running in ARCHIVELOG mode and regular nightly backups are taken. Due to a media failure, the current online redo log group, which has one member, is lost and the instance is aborted.
Examine the steps to recover the online redo log group and move it to a new location.
1. Restore the corrupted redo log group.
2. Restore the database from the most recent database backup.
3. Perform an incomplete recovery.
4. Relocate the member of the damaged online redo log group to a new location.
5. Open the database with the RESETLOGS option.
6. Issue a checkpoint and clear the log. Identify the required steps in the correct order.

1, 3, 4, 5

6, 3, 4, 5

2, 3, 4, 5

6, 4, 3, 5

Question 12

- (Exam Topic 2)
Which two statements are true about tablespaces in multitenant container databases (CDBs)? (Choose two.)

Default permanent tablespaces can be shared across pluggable databases (PDBs).

The current container must be set to root to create or modify the default temporary tablespace or tablespace group for a CDB.

Each PDB can have its own default temporary tablespace.

The default permanent tablespace for a PDB can be changed only by a local user with the required permissions.

The amount of space that each PDB can use in a shared temporary tablespace must be set at the CDB level.

Question 13

- (Exam Topic 1)
You wish to create jobs to satisfy these requirements:
1. Automatically bulk load data from a flat file.
2. Rebuild indexes on the SALES table after completion of the bulk load. How would you create these jobs?

Create both jobs by using Scheduler raised events.

Create both jobs using application raised events.

Create one job to rebuild indexes using application raised events and another job to perform bulk load using Scheduler raised events.

Create one job to rebuild indexes using Scheduler raised events and another job to perform bulk load by using events raised by the application.

Question 14

- (Exam Topic 1)
You issue commands in SQL*Plus as the Oracle owner, to enable multithreading for your UNIX-based Oracle 12c database:
CONNECT /AS SYSDBA
ALTER SYSTEM SET THREADED_EXECUTION=TRUE SCOPE=SPFILE; SHUTDOWN IMMEDIATE
You then restart the instance and get an error: STARTUP
ORA-01031: insufficient privileges
Why does the startup command return the error shown?

because the threaded architecture requires exiting from sql*plus and reconnecting with sql*Plus / as sysdba before issuing a startup command

because the threaded architecture requires issuing a new connect / as sysdba from within sql*plus before issuing a startup command

because the threaded architecture requires authentication using a password file before issuing a startup command

because the threaded architecture requires connecting to the instance via a listener before issuing a startup command

because the threaded architecture requires restarting the listener before issuing a startup command

Question 15

- (Exam Topic 2)
You set the following parameters in the parameter file and restart the database instance: NEMORY_MAX_TARGET=0
MEMORY TARGET=500M PGA_AGGREGATE_TARGET=90M SGA_TARGET=270M
Which two statements are true? (Choose two.)

The memory_max_target parameter is automatically set to 500 MB.

The pga_aggregate_target and sga_target parameters are automatically set to zero.

The value of the memory_max_target parameter remains zero for the database instance.

The lower limits of the pga_aggregate_target and sga_target parameters are set to 90 MB and 270 MBrespectively.

The instance does not start up because Automatic Memory Management (AMM) is enabled but pga_aggregate_target and sga_target parameters are set to nonzero values.

Question 16

- (Exam Topic 2)
You are performing regular backups of your production database by using a recovery catalog.
You add two new tablespaces to your production database after performing a backup. They must be included in future backups.
Which action should you perform?

Synchronize the recovery catalog with the target database control file.

Create a new database incarnation record.

Add the tablespaces in the recovery catalog by using the CATALOG command.

Synchronize all the physical data files with the logical records in the recovery catalog by using theCROSSCHECK command.

Question 17

- (Exam Topic 2)
You are administering a multitenant container database (CDB) CDB1 that has multiple pluggable databases (PDBs). As the SYS user on CDB$ROOT, you execute the commands:
SQL> CREATE USER C##ADMIN IDENTIFIED BY orc1123;
SQL> GRANT CREATE SESSION to C##ADMIN CONTAINER=ALL; SQL> GRANT CREATE USER TO C##ADMIN CONTAINER=ALL;
Which two statements are true about the c##ADMIN user that is created in all PDBs? (Choose two.)

It can create only local users in all the PDBs.

It has a common schema for all the PDBs.

It can create common users only when it is logged in to the CDB.

It can create only local users in the CDB.

It can be granted only common roles in the PDBs.

Question 18

- (Exam Topic 2)
RMAN is connected to a target database instance and an auxiliary instance. You execute the command:
1Z0-063 dumps exhibit

What is the outcome?

RMAN uses the push method to transfer image copies.

RMAN uses the push method to transfer backup sets.

RMAN uses the pull method to restore files using backup sets.

RMAN uses the pull method to restore files using image copies.

Question 19

- (Exam Topic 2)
A database instance uses an SPFILE. Examine the parameter:
1Z0-063 dumps exhibit

You plan to multiplex the control file to a new location, parallelization for the backup set./u01/app/oracle/oradata/cdb1/disk3/control03.ctl/.
Examine the possible steps that are in random order:
1. Shut down the database instance.
2. Issue ALTER SYSTEM SET CONTROL_FILES= ‘/u01/app/oracle/oradata/cdb1/disk1/control01.ctl,
/u01/app/oracle/oradata/cdb1/disk2/control02, ctl,
/u01/app/oracle/oradata/cdb1/disk3/control03.ctl’ SCOPE=SPFILE;.
3. Issue ALTER SYSTEM SET CONTROL_FILES=
‘/u01/app/oracle/oradata/cdb1/disk1/control01.ctl, /u01/app/oracle/oradata/cdb1/disk2/control02.ctl,
/u01/app/oracle/oradata/cdb1/disk3/control03.ctl’;.
4. Copy the control file from the existing location to ‘/u01/app/oracle/oradata/cdb1/disk3/control03.ctl’.
5. Mount the database.
6. Open the database.
Identify the required steps in the correct order to accomplish the task.

3, 4

2, 1, 4, 6

3, 1, 4, 6

1, 5, 2, 4, 6

2, 6

Question 20

- (Exam Topic 1)
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?

Enable Memory Access Mode, which reads performance data from SGA.

Use emergency monitoring to fetch data directly from SGA for analysis.

Run Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest Automatic Workload Repository (AWR) snapshots.

Use Active Session History (ASH) data and hang analysis in regular performance monitoring.

Run ADDM in diagnostic mode.

Question 21

- (Exam Topic 2)
The HR user updates the salary of one of the employees in the EMPLOYEES table, but does not commit the transaction.
Which type of lock would this scenario lead to?

Exclusive table-level lock on the EMPLOYEES table

Row-exclusive lock on the row being updated

Null lock on the EMPLOYEES table

Null lock on the row being updated

Question 22

- (Exam Topic 2)
In which three situations must you use a recovery catalog? (Choose three.)

when you want to store RMAN global scripts that can be used across multiple databases

when you want to restrict the amount of space used by backups

when you want to perform incremental backups by using a block change tracking file

when you want to list data files that were in a target database at a given time by using the AT clause with the REPORT SCHEMA command

when you want to maintain backup metadata longer than the period specified by the CONTROL_FILE_RECORD_KEEP_TIME parameter

My answer: -

Reference answer: ADE

Reference analysis:

A: Some RMAN features function only when you use a recovery catalog. For example, you can store RMAN scripts in a recovery catalog. The chief advantage of a stored script is that it is available to any RMAN client that can connect to the target database and recovery catalog. Command files are only available if the RMAN client has access to the file system on which they are stored.
A local stored script is associated with the target database to which RMAN is connected when the script is
created, and can only be executed when you are connected to this target database. A global stored script can be run against any database registered in the recovery catalog.
D: If you use a recovery catalog, then you can use the atClause to specify a past time, SCN, or log sequence number, as shown in these examples of the command:
RMAN> REPORT SCHEMA AT TIME 'SYSDATE-14'; # schema 14 days ago RMAN> REPORT SCHEMA AT SCN 1000; # schema at scn 1000
RMAN> REPORT SCHEMA AT SEQUENCE 100 THREAD 1; # schema at sequence 100 RMAN> REPORT SCHEMA FOR DB_UNIQUE_NAME standby1;
E: The CONTROL_FILE_RECORD_KEEP_TIME initialization parameter determines the minimum number of days that records are retained in the control file before they are candidates for being overwritten. Thus, you must ensure that you resynchronize the recovery catalog with the control file records before these records are erased.
References: https://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmcatdb.htm https://docs.oracle.com/database/121/BRADV/rcmreprt.htm#BRADV90911

Question 23

- (Exam Topic 1)
You want to consolidate backup information and centrally manage backup and recovery scripts for multiple databases running in your organization.
Which two backup solutions can be used? (Choose two.)

RMAN recovery catalog

RMAN Media Management Library

Enterprise Manager Cloud Control

Enterprise Manager Database Express

Oracle Secure Backup

Page: 1 / 19

Total 235 questions Full Exam Access