1z0-063 sample questions

Question 1

Which three statements are true about compression of backup sets? (Choose three.)

Accepted Answer

Binary compression creates performance overhead during a backup operation.

Accepted Answer

Unused blocks below the high-water mark are not backed up.

Accepted Answer

It works only for locally managed tablespaces.

Answer

Compressed backups can only be written to media.

Answer

Compressed backups cannot have section size defined during a backup operation.

Question 2

Your multitenant container database (CDB) CDB1, which has no startup triggers and contains multiple pluggable databases (PDBs), is started up by using the command:SQL)STARTUPWhich two statements are true about the successful execution of the command? (Choose two.)

Accepted Answer

All redo log files are opened.

Accepted Answer

Only the root database is opened in read-write mode.

Answer

The root, the seed, and all the PDBs are opened in read-write mode.

Answer

All the PDBs are opened in read-write mode.

Answer

All the PDBs are in closed state.

Question 3

Automatic Shared Memory Management (ASMm) is enabled for your database instance, but parameters for the managed components are not defined.
You execute this command:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M;

Which statement is true?

Accepted Answer

The minimum size for the standard buffer cache is 100 M

Answer

B. The maximum sizeforthe standard buffer cache is 100 MB.

Answer

The minimum space guaranteed in the buffer cache for any server process is 100 MB.

Answer

The maximum space in the buffer cache that can be released for dynamic distribution is 100 MB.

Answer

The minimum size for all buffer caches is 100 MB.

Question 4

Users report this error message when inserting rows into the orders table:ERROR at line1:
ORA-O1654f:unable to extend index USERS.ORDERS_IND by 8 in tablespace INDEXES

You determine that the indexes tablespace is out of space and there is no free space on the filesystem used by the Oracle database.
Which two must you do to fix this problem without affecting currently executing queries? (Choose two.)

Accepted Answer

coalesce the order.ind index

Accepted Answer

rebuild the index online moving it to another tablespace that has enough free space for the index

Answer

drop and re-create the index

Answer

coalesce the indexes tablespace

Answer

perform an on line table rebuild using dbms_redefinition

Question 5

Examine the list of possible steps to transport a tablespace across platforms that have the same compatibility level, character sets, and endian format:
1.Make the tablespace read-only at the source database.
2.Export metadata from the source database.
3.Import metadata into the target database.
4.Transferthe dump file and data files to the target machine.
5.Convert data files by using Recovery Manager (RMAN).
6.Make the tablespace read-write at the target database.

Identify the required steps in the correct order.

Accepted Answer

1,2,4, 3, and6

Answer

2, 4, and 3

Answer

2,4, 3, and5

Answer

1,5,2,4, 3, and6

Question 6

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 7

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 8

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 9

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 10

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.

Top vendors

Top exams

Free 1z0-063 sample questions

Which three statements are true about compression of backup sets? (Choose three.)

Your multitenant container database (CDB) CDB1, which has no startup triggers and contains multiple pluggable databases (PDBs), is started up by using the command:SQL)STARTUPWhich two statements are true about the successful execution of the command? (Choose two.)

Automatic Shared Memory Management (ASMm) is enabled for your database instance, but parameters for the managed components are not defined. You execute this command: SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M; Which statement is true?

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

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

10 more free samples are waiting