Oracle 1z1-067 Actual Free Exam Questions & Community Discussion

Identify two scenarios in which the RMAN crosscheck command can be used.

You created a tablespace with this statement:
CREATE BIGFILE TABLESPACE adtbs
DATAFILE '/proddb/data/adtbs.dbf' SIZE 10G;
The tablespace is nearly full and you need to avoid any out of space errors for the load of a 5 gig table.
Which two alter statements will achieve this?

Examine the resources consumed by a database instance whose current Resource Manager plan is displayed.
SQL> SELECT name, active_sessions, queue_length,
consumed_cpu_time, cpu_waits, cpu_wait_time
FROM v$rsrc_consumer_group;

Which two statements are true?

You are administering a multitenant container database (CDB) cdb1.
Examine the command and its output:
SQL>show parameterfile
NAMETYPEVALUE
----------------------------------------------------------------------- db_create_file_deststring db_file_name_convertstring db_filesinteger200 You verify that sufficient disk space is available and that no file currently exists in the
'/u0l/app/oracle/oradata/cdb1/salesdb' location.
You plan to create a new pluggable database (PDB) by using the command:
SQL>CREATEPLUGGABLEDATABASESALESPDB
ADMINUSERsalesadmIDENTIFIED 3Y password
ROLES=(dba)
DEFAULTTABLESPACEsales
DATAFILE' /u01/app/oracle/oradata/cdb1/salesdb/sales01 .dbf'SIZE 250M AUTOEXTEND ON FILE_NAME_CONVERT=('/u01/app/oracle/oradata/cdb1/pdbseed/',
'/u01/app/oracle/oradata/cdb1/salesdb/')
STORAGE(MAXSIZE2G)
PATK_PREFIX='/u01/app/oracle/oradata/cdb1/SALESPDB';
Which statement is true?

Examine the following impdp command to import a database over the network from a pre-12c Oracle database (source):
$> impdp <user_name> full=Y network_link=hrdb_test transportable=always transport_datafiles=
'/u01/app/oracle/oradata/hrdb/sales01.dbf',
'/u01/app/oracle/oradata/hrdb/cust01.dbf',
'/u01/app/oracle/oradata/hrdb/emp01.dbf',
version=12 logfile=import.log
Which three are prerequisites for successful execution of the command?

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. Transfer the 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. (Choose the best answer.)

You regularly take backups of your database using RMAN with a recovery catalog. Your database is currently open and the temp01.dbf temp file belonging to the TEMP tablespace is corrupted. Identify two methods to recover the temp file with the least disruption to database availability. (Choose two.)

Which two statements are true regarding SecureFile lobs?

You are administering a database that supports data warehousing workload and Is running in noarchivelog mode. You use RMAN to perform a level 0 backup on Sundays and level 1 Incremental backups on all the other days of the week.
One of the data files is corrupted and the current online redo log file is lost because of a media failure.
You want to recover the data file.
Examine the steps involved in the recovery process:
1.Shut down the database instance.
2.Start up the database instance in nomount state.
3.Mount the database.
4.Take the data file offline.
5.Put the data file online.
6.Restore the control file.
7.Restore the database.
8.Restore the data file.
9.Open the database with the resetlog option.
10.Recover the database with the noredo option.
11.Recover the data file with the noredo option.
Identify the required steps in the correct order.

Consider the following scenario for your database:
-Backup optimization is enabled in RMAN.
-The recovery window is set to seven days in RMAN.
-The most recent backup to disk for the tools tablespace was taken on March 1, 2015.
-The tools tablespace is read-only since March 2, 2015.
On March 15, 2015, you issue the RMAN command to back up the database via the Media Manager Interface.
Which statement is true about the backup of the tools tablespace?

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 have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter to YYYY-MM-DD. The default format of which two data types would be affected by this setting?

Identify three benefits of unified auditing.

Examine the backup requirement for your company:
1) Every Sunday, a backup of all used data file blocks is performed.
2) Every Wednesday and Friday, a backup of all the changed blocks since last Sunday's backup is performed.
3) On all the other days, a backup of only the changed blocks since the last day's backup is performed.
Which backup strategy satisfies the requirements?