Online Access Free 1z1-067 Exam Questions

Examine the command:
SQL> RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;
In which two scenarios is this command required?

• A.All the control files are missing.
• B.The current online redo log file is missing.
• C.A data file belonging to a noncritical tablespace is missing.
• D.All the data files are missing.
• E.The database backup is older than the control file backup.

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 sql_trace parameter is set to false.
• B.The statistics_level parameter is set to basic.
• C.Enterprise Manager was not used.
• D.The t:kid_statistics parameter is set to false.
• E.The event parameter was not set.

You are administering a multitenant container database (CDB) that contains multiple pluggable databases (PDBs). You are connected to cdb$root as the sys user. You execute the commands:
SQL> CREATE USER C##ADMIN IDENTIFIED BY orcll23;
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 statement is true about the c##connect role?

• A.It is granted to the c##admin user in all PDBs and can be granted only to a local user in a PDB.
• B.It is granted to the c##admin user in all PDBs and can be granted object and system privileges for a PDB.
• C.It is granted to the c##admin user only in the CDB.
• D.It is created only in cdb$root and cannot be granted to the c##admin user with the container=all clause.

A user issues a query on the sales table and receives the following error:
ERROR at line 1:
ORA-01565: error in identifying file '/u0l/app/oracle/oradata/ORCL/temp01.dbf' ORA-27037: unable to obtain file status Which two actions would you take to recover the temporary tablespace?

• A.Create a new temporary tablespace and assign it as the default to the user.
• B.Add a new temp file to the temporary tablespace and drop the temp01.dbf file.
• C.Shut down the database instance, start up the database instance in mount state, create a new temporary tablespace, and then open the database.
• D.Drop the temp01.dbf file, and then re-create the temp file.
• E.Take the temporary tablespace offline, recover the missing temp file, and then bring the temporary tablespace online.

Your database is running in archivelog mode. Examine the initialization parameters you plan to set for your database instance.
LOG_ARCHIVE_DEST_1 = 'LOCATION=/disk1/arch'
LOG_ARCHIVE_DEST_2 = 'L0CATI0N=/disk2/arch'
LOG_ARCHIVE_DEST_3 = 'LOCATION=/disk3/arch'
L0G_ARCHIVE_DEST_4 = 'L0CATI0N=/disk4/arch MANDATORY'
Identify the statement that correctly describes these settings.

• A.An online redo log file is not allowed to be overwritten if the archived log file cannot be created in the location specified for log_archive_dest_4.
• B.Optional destinations cannot use the fast recovery area.
• C.An online redo log file is not allowed to be overwritten if the archived log file cannot be created in any of the log_archive_dest_.n destinations.
• D.These settings work only if log__archive_min_succeed_dest is set to a value of 4.