Oracle Database 12c: Installation and Administration - 1z0-062 Exam Practice Test

Which three statements are true about a job chain? (Choose three.)

One of your databases runs in ARCHIVELOG mode.
Examine this command:

Now examine these steps executed from RMAN:
1) SHUTDOWN IMMEDIATE
2) STARTUP MOUNT
3) BACKUP DATABASE;
4) BACKUP ARCHIVELOG ALL;
5) ALTER DATABASE OPEN;
6) STARTUP
Identify the minimum required steps in the correct order needed to perform a whole consistent database backup.

Your multitenant container database (CDB) contains pluggable databases (PDBs), you are connected to the HR_PDB. You execute the following command:
SQL > CREATE UNDO TABLESPACE undotb01
DATAFILE 'u01/oracle/rddb1/undotbs01.dbf' SIZE 60M AUTOEXTEND ON;
What is the result?

Your database supports a Decision Support System (DSS) workload that involves the execution of complex queries. Currently, the database is running with peak workload. You want to analyze some of the most resource-intensive statements cached in the library cache.
What must you run to receive recommendations on the efficient use of indexes and materialized views to improve query performance?

Which two statements are true about SQL*Loader Express Mode in an Oracle 12c database? (Choose two.)

Which two statements are true about the Oracle Direct Network File system (DNFS)? (Choose two.)

What happens if a maintenance window closes before a job that collects optimizer statistics completes?

You have a production Oracle 12c database running on a host.
You want to install and create databases across multiple new machines that do not have any Oracle database software installed. You also want the new databases to have the same directory structure and components as your existing 12c database.
The steps in random order:
1. Create directory structures similar to the production database on all new machines.
2. Create a response file for Oracle Universal Installer (OUI) with the same configurations as the production database.
3. Create a database clone template for the database.
4. Run the Database Configuration Assistant (DBCA) to create the database.
5. Run OUI in graphical mode on each machine.
6. Run OUI in silent mode using the OUI response file.
Identify the required steps in the correct sequence to achieve the requirement with minimal human intervention.

Examine the following command:
SQL> DBMS_STATS. SET_TABLE_PREFS ('SH', 'CUSTOMERS', 'PUBLISH', 'false'); What is the effect of executing this command?

Which component resides in the System Global Area (SGA) of a database instance only in shared server connections?

Examine the following query output:

You issue the following command to import tables into the hr schema:
$ > impdp hr/hr directory = dumpdir dumpfile = hr_new.dmp schemas=hr
TRANSFORM=DISABLE_ARCHIVE_LOGGING: Y
Which statement is true?

Tape streaming is not happening while performing RMAN tape backup. On investigation, you find that it is not because of the incremental backup or the empty file backup and that RMAN is sending data blocks to tape drive fast enough.
What could be a solution to make streaming happen during the backup?