1z0-063 sample questions

Question 1

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? (Choose two.)

Accepted Answer

A suspended statement will report an error if no corrective action has taken place during a timeout period.

Accepted Answer

Before a statement executes in resumable mode, the alter session enable resumable statement must be issued in its session.

Answer

A resumable statement can be suspended and resumed only once during execution.

Answer

Data Manipulation Language (DML) operations are resumable, provided that they are not embedded in a PL/SQL block.

Answer

Suspending a statement automatically results in suspending a transaction and releasing all the resources held by the transaction.

Question 2

The environmental variable oracle_Base is set to /u01/app/oracle and oracle_home is set to /u01/app/oracle/product/12.1.0/db 1.

You want to check the diagnostic files created as part of the Automatic Diagnostic Repository (ADR). Examine the initialization parameters set in your database.

NAME TYPE VALUE
audit_file_dest string /u01/app/oracle/admin/eml2rep/adump
background_dump_dest string
core_dump_dest stringdb_create_file_dest string
db_recovery_file_dest string
/u01/app/oracle/fast_recovery_area diagnostic_dest string

What is the location of the ADR base?

Accepted Answer

It is set to /u01/app/oracle.

Answer

It is set to /u01/app/oracle/product:/12.1.0/db_1/log.

Answer

It is set to /u01/app/oracle/admin/enl2rp/adump.

Answer

It is set to /u01/app/oracle/flash_recovery_area.

Question 3

Which two statements are true about unified auditing? (Choose two.)

Accepted Answer

A unified audit trail captures audit information from unified audit policies and audit settings.

Accepted Answer

Unified auditing is enabled by executing make -f ins_rdbms.mk uniaud_on ioracle ORACLE_HOME=$ORACLE_HOM

Answer

Audit records are created for all users except sys.

Answer

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.

Answer

A unified audit trail resides in a read-only table in the audsys schema in the system tablespace.

Question 4

You want to reduce fragmentation and reclaim unused space for the sales table but not its dependent objects. During this operation, you want to ensure the following:.
i. Long-running queries are not affected.
ii. No extra space is used.
iii. Data manipulation language (DML) operations on the table succeed at all times throughout the process.
iv. Unused space is reclaimed both above and below the high water mark.

Which alter TABLE option would you recommend?

Accepted Answer

SHRINK SPACE COMPACT

Answer

DEALLOCATE UNUSED

Answer

SHRINK SPACE CASCADE

Answer

ROW STORE COMPRESS BASIC

Question 5

Examine the
RMAN commands executed in your database:
RMAN) CONFIGURE DEFAULT DEVICE TYPE TO disk;
RMAN) CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO BACKUPSET;
RKAN) CONFIGURE CONTROLFILE AUTOBACKUP ON;

You issue the command:RMAN) BACKUP DATABASE;Which two statements are true about the command? (Choose two.)

Accepted Answer

It backs up only the used blocks in data files.

Accepted Answer

It backs up data files, the control file, and the server parameter file.

Answer

It performs a log switch.

Answer

It creates compressed backup sets by using binary compression by default.

Answer

It creates a backup of only the control file whenever the database undergoes a structural change.

Question 6

Which three statements are true about the database instance startup after an instance failure? (Choose three.)

Accepted Answer

The RECO process recovers the uncommitted transactions at the next instance startup.

Accepted Answer

Uncommitted changes are rolled back to ensure transactional consistency.

Accepted Answer

The SMON process coordinates the database recovery.

Answer

Online redo log files and archived redo log files are required to complete the rollback stage of instance recovery.

Answer

Media recovery is required to complete the database recovery.

Answer

Changes committed before the failure, which were not written to the data files, are re-applied.

Question 7

In which three scenarios is media recovery required? (Choose three.)

Accepted Answer

when a tablespace is accidentally dropped from a database

Accepted Answer

when data files are lost

Accepted Answer

when all control files are lost

Answer

when archived redo log files are lost

Answer

when one of the online redo log members is corrupted

Question 8

You take regular backups ofone ofyour production databases by using RMAN with a recovery catalog.
You have added two new tablespaces to this database which must be included in future backups.
Which process occurs which allows the new backups to contain the new datafiles?

Accepted Answer

The target database control file is synchronized from the recovery catalog with a full resync at the next backup.

Answer

The target database control file is synchronized from the recovery catalog with a partial resync at the next backup.

Answer

The recovery catalog is synchronized from the target database control file with a full resync at the next backup.

Answer

The recovery catalog is synchronized from the target database control file with a partial resync at the next backup.

Question 9

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

Accepted Answer

The ORA_ARCHIVE_STATE column is updated manually or by a program that can reference activity tracking columns, to indicate that a row is no longer considered active.

Accepted Answer

The ORA_ARCHIVE_STATE column is visible if it is referenced in the select list of a query.

Answer

Visibility of the ORA_ARCHIVE_STATE column is controlled by the row archival visibility session parameter.

Answer

The row archival visibility session parameter defaults to all rows.

Answer

The ORA_ARCHIVE_STATE column is updated automatically by the database based on activity tracking columns, to indicate that a row is no longer considered active.

Question 10

One ofyour multitenant container databases (CDB) contains multiple pluggable databases (PDBs). You connect to CDB$ROOT as SYS and execute these commands successfully:
SQL) CREATE USER C##ADMIN IDENTIFIED BY orcl123;
SQL) CREATE ROLE C##CONNECT;
SQL) GRANT CREATE SESSION, CREATE TABLE, SELECT ANY TABLE TO C##CONNECT;
SQL) GRANT C##CONNECT to C##ADMIN CONTAINER=ALL;Which three are true? (Choose three.)

Accepted Answer

The C##CONNECT role can be granted different roles and privileges in each PD

Accepted Answer

The C##CONNECT role is granted to the C##ADMIN user in all PDBs.

Accepted Answer

The C##CONNECT role is a local role defined only in CDB$ROOT.

Answer

B. C##ADMIN has the orcl123 password in all PDBs.

Answer

CREATE SESSION is granted to the C##ADMIN user in all PDBs.

1z0-063 Sample Questions & Answers

Ready for the real thing?

1z0-063 Sample Questions & Answers

Related practice tests

Ready for the real thing?