1Z0-063 Online Practice Questions and Answers

Your database supports an online transaction processing (OLTP) workload and it needs to be up 24 x 7. You want to perform a complete database backup by using RMAN.

Identify the minimum requirement for accomplishing the task.

A. An RMAN channel must be configured to device-type disk.

B. The database must be configured in ARCHIVELOG mode.

C. Redo log groups must have at least two members each.

D. All tablespaces in the database must be locally managed.

You plan to create a new PDB by copying PDB$SEED.

Which two requirements ensure a successful creation? (Choose two.)

A. The CDB must have PDB_FILE_NAME_CONVERT configured before executing the command.

B. A default service for the new PDB name must already exist.

C. A PDB local administrative user must be granted the DBA role when creating the PDB.

D. A PDB local administrative user must be specified when creating the PDB.

E. The CDB, which will contain the PDB, must be in READ WRITE mode.

F. The CDB must use Oracle Managed Files.

Which two are true about Oracle Secure Backup (OSB)? (Choose two.)

A. It can be used to take proxy copies to tape.

B. It can be used to take image copy backups to tape.

C. It can be used to manage tape backup and restore operations for files.

D. RMAN can backup up databases to OSB without requiring media manager channel parameters.

E. It can be used to manage tape backup and restore operations for files systems.

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. Local Undo is enabled.

B. The files created for both the root and seed databases use Oracle Managed Files (OMF).

C. PDB$SEED is open read-only.

D. PDB$SEED is mounted.

E. USERS will be the default tablespace for PDB$SEED.

F. CDB$ROOT is open read/write.

While performing database backup to tape via the media manager interface, you notice that tape streaming is not happening because RMAN is not sending data blocks fast enough to the tape drive.

Which two actions would you take for tape streaming to happen during the backup? (Choose two.)

A. Configure backup optimization.

B. Configure the channel to increase maxopenfiles.

C. Configure a backup policy by using incremental backups.

D. Configure the channel to increase capacity with the rate parameter.

E. Configure the channel to adjust the tape buffer size by using the 3LKSIZE option.

F. Configure large_pool, if not done already. Alternatively, you can increase the size of large_pool.

Your database supports an online transaction processing (OLTP) workload in which one of the applications creates a temporary table for a session and performs transactions on it. This consumes a lot of undo tablespace and is affecting undo retention.

Which two actions would you take to solve this problem? (Choose two.)

A. Enable temporary undo for the database.

B. Enable undo retention guarantee.

C. Increase the size of the redo log buffer.

D. Enable Automatic Memory Management (AMM).

E. Increase the size of the temporary tablespace.

You plan to use the In-Database Archiving feature of Oracle Database 12c, and store rows that are inactive for over three months, in Hybrid Columnar Compressed (HCC) format.

Which three storage options support the use of HCC? (Choose three.)

A. ASM disk groups with ASM disks consisting of Exadata Grid Disks.

B. ASM disk groups with ASM disks consisting of LUNS on any Storage Area Network array

C. ASM disk groups with ASM disks consisting of any zero padded NFS-mounted files

D. Database files stored in ZFS and accessed using conventional NFS mounts.

E. Database files stored in ZFS and accessed using the Oracle Direct NFS feature

F. Database files stored in any file system and accessed using the Oracle Direct NFS feature

G. ASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays

Examine the output:

SQL > ARCHIVE LOG LIST Database log mode Archive Mode Automatic archival Enabled Archive Destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 376 Next log sequence to archive 378 Current log sequence 378

Which three types of files are automatically placed in the fast recovery area? (Choose three.)

A. Flashback data archives (FDA)

B. Archived redo log files

C. Control file autobackups

D. Server parameter file (SPFILE)

E. Recovery Manager (RMAN) backup pieces

Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information Lifecycle Management (ILM)? (Choose three.)

A. tracking the most recent read time for a table segment in a user tablespace

B. tracking the most recent write time for a table segment in a user tablespace

C. tracking insert time by row for table rows

D. tracking the most recent write time for each block in a table segment

E. tracking the most recent read time for a table segment in the sysaux tablespace

F. tracking the most recent write time for a table segment in the sysaux tablespace

You specified the warning and critical thresholds for a locally managed tablespace to be 60% and 70%, respectively.

From the tablespace space usage metrics, you find that the space usage has reached the specified warning threshold value, but no alerts have been generated.

What could be the reason for this?

A. The event parameter was not set.

B. The sql_trace parameter is set to false.

C. Enterprise Manager was not used.

D. The statistics_level parameter is set to basic.

E. The timed_statistics parameter is set to false.