Free 1Z0-063 Exam Dumps Preview

You need to perform a block media recovery on the tools01.dbf data file in your database by using Recovery Manager (RMAN).

Which two are prerequisites for performing this operation? (Choose two.)

Which statement is true about the loss or damage of a temp file that belongs to the temporary tablespace of a pluggable database (PDB)?

You execute the RMAN commands:

RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk;
RMAN> CONFIGURE DEVICE TYPE disk PARALLELISM 2;
RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT `/disk1/%U';
RMAN> CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT `/disk2/%U';
RMAN> BACKUP DATABASE;

Which statement is true about the backup set created by the BACKUP command?

Which two statements are true about Flashback Version Query? (Choose two.)

Examine the probable steps involved in the basic backup process of RMAN and Oracle Secure Backup (OSB):

1. RMAN initiates backup and passes the database backup storage selector to OSB.
2. RMAN creates the backup job.
3. OSB creates the backup job with an OSB user.
4. RMAN updates its repository.
5. RMAN executes the job and transfers data from a client to media.
6. OSB executes the job and transfers data from a client to media.
7. OSB updates its repository.

Identify the required steps in the correct order.

You want to create a database with a block size other than the default 8 KB by using the Database Configuration Assistant (DBCA).

Which option should you use?

You enable Flashback Data Archive for a table for which you want to track and save all transactions for four years. After some time, the requirement changes for keeping transactions from four to two years.
You execute the following command to change the requirement:
SQL> ALTER FLASHBACK ARCHIVE fda1 MODIFY RETENTION 2 YEAR;

What is the outcome?

Automatic Undo Management is enabled for your database. You want a user to retrieve metadata and historical data for a given transaction or for transactions in a given time interval.

Which three are prerequisites to fulfill this requirement? (Choose three.)

Your database instance is abnormally terminated because of a power outage.
At the next startup, from which point in the redo log does the recovery start?

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?

Which three statements are true about using RMAN without a recovery catalog? (Choose three.)

Which two statements are true about recovering logically corrupted tables or table partitions from an RMAN backup? (Choose two.)

Which three types of failures are detected by the Data Recovery Advisor (DRA)? (Choose three.)

One of your database runs in ARCHIVELOG mode.

Examine these initialization parameter settings:

Which statement is true based on these settings?

A user issues a query on the sales table and receives the following error: ERROR at line 1:

ORA-01565: error in identifying file '/u0l/app/oracle/oradata/ORCL/temp01.

dbf' ORA-27037: unable to obtain file status Which two actions would you take to recover the temporary tablespace? (Choose two.)

LDAP_DIRECTORY_SYSAUTH is set to YES.

Users requiring DBAs access have been granted the sysdba enterprise role in Oracle Internet Directory (OID).

SSL has been configured for the database and OID 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?

Examine the RMAN commands:

RMAN> CONNECT TARGET "sbu@prod AS SYSBACKUP";

RMAN> CONNECT AUXILIARY "sbu@dup_db AS SYSBACKUP";

RMAN> DUPLICATE TARGET DATABASE TO dup_db
FROM ACTIVE DATABASE
PASSWORD FILE
SECTION SIZE 400M;

Which statement is true about the DUPLICATE command?

Which two statements are true when row-archival management is enabled? (Choose two.)

A telecom company wishes to generate monthly bills to include details of customer calls, listed in order of time of call.

Which table organization allows for generating the bills with minimum degree of row sorting?

A database instance uses an SPFILE. Examine the parameter:

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.

Which Oracle Database component is audited by default if the Unified Auditing option is enabled?

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

Examine the commands executed to monitor database operations:

$> conn sys/oracle@prod as sysdba
SQL> VAR eid NUMBER
SQL>EXEC :eid := DBMS_SQL_MONITOR.BEGlN_OPERATION('batch_job',FORCED_TRACKING=>'Y');

Which two statements are true? (Choose two.)

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

One of your databases supports a data warehousing workload and is in NOARCHIVELOG mode. You perform RMAN level 0 backup on Sundays and level 1 incremental backups on other days.

One data file is corrupt and the current online redo log is missing due to media failure.

Which four actions must you take for recovery? (Choose four.)

In which three situations must you use a recovery catalog? (Choose three.)

Which three statements are true about automated maintenance tasks? (Choose three.)

Examine the following steps of privilege analysis for checking and revoking excessive, unused privileges granted to users:

1. Create a policy to capture the privileges used by a user for privilege analysis.
2. Generate a report with the data captured for a specified privilege capture.
3. Start analyzing the data captured by the policy.
4. Revoke the unused privileges.
5. Compare the used and unused privileges' lists.
6. Stop analyzing the data.

Identify the correct sequence of steps.

Which three statements are true about the SQL*Loader utility? (Choose three.)

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
-------------------------
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
------------------------
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?

Examine this query:

SELECT cust_name, amt_due
FROM customers
AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '6' MINUTE)
WHERE cust_no = 'AYR2011';

Which two requirements guarantee that the query will execute successfully? (Choose two.)

Identify three benefits of unified auditing. (Choose three.)

Examine this parameter in a database's PFILE:

DB_CREATE_FILE_DEST = '/u01/app/oracle/oradata/'

You execute this command:

Which three are true after successful database creation? (Choose three.)

A complete database backup to media is taken for your database every day.

Which three actions would you take to improve backup performance? (Choose three.)

You want to export the pluggable database (PDB) HR_PDB1 from the multitenant container database
(CDB) CDB1 and import it into the CDB2 CDB as the EMP_PDB1 PDB.

Examine the list of possible steps required to perform the task:

1. Create a PDB named EMP_PDB1.
2. Export the HR_PDB1 PDB by using the FULL clause.
3. Open the EMP_PDB1 PDB.
4. Mount the EMP_PDB1 PDB.
5. Synchronize the EMP_PDB1 PDB in restricted mode.
6. Copy the dump file to the Data Pump directory.
7. Create a Data Pump directory in the EMP_PDB1 PDB.
8. Import data into EMP_PDB1 with the FULL and REMAP clauses.
9. Create the same tablespaces in EMP_PDB1 as in HR_PDB1 for new local user objects.

Identify the required steps in the correct order.

Which two are true about RMAN image copies? (Choose two.)

Examine the following set of RMAN commands:

Which statement is true about the RMAN run block execution?

Which three RMAN persistent settings can be set explicitly? (Choose three.)

You create two Resource Manager plans, one for night time workloads, the other for day time.

How would you make the plans switch automatically?

Which two methods can be used to create a PDB from a non-CDB Oracle 12c Database? (Choose two.)

Identify three reasons for using a recovery catalog with Recovery Manager (RMAN). (Choose three.)

Your multitenant container database (CDB) cdb1 that is running in archivelog mode contains two pluggable databases (PDBs), pdb2_1 and pdb2_2. RMAN is connected to the target database pdb2_1.

Examine the command executed to back up pdb2_1:

RMAN> BACKUP DATABASE PLUS ARCHIVELOG;

Which statement is true about the execution of this command?