Oracle 1Z0-067 Free Practice Questions

NEW QUESTION 1
In CDB$ROOT of your multitenant container database (CDB), you create a common user, C##A_ADMIN, and then execute the command:
SQL> GRANT create tablespace to C##A_ADMIN; Which statement is true? (Choose the best answer.)

• A. The command fails because the CONTAINER clause is not used.
• B. The command executes successfully, enabling the C##A_ADMIN user to create a tablespace only in the root database.
• C. The command executes successfully, enabling the C##A_ADMIN user to create tablespaces in the root database, as well as in the plugging databases (PDBs).
• D. The command fails because system privileges cannot be granted to a common use

Answer: B

NEW QUESTION 2
A database is running in archivelog mode. You want to back up a 10 TB data file belonging to the users tablespace. The backup of the data file is too slow.
What type of backup do you recommend to improve the performance of the backup?

• A. image copy backup by using RMAN
• B. multisection image copy backup by using RMAN
• C. multisection parallel backup by using RMAN
• D. cold backup after taking the tablespace offline
• E. cold backup after placing the tablespace in backup mode

Answer: C

NEW QUESTION 3
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?

• A. An attempt to start a new session by a user belonging to DSS_QUERIES fails with an error.
• B. An attempt to start a new session by a user belonging to OTHE_GROUPS fails with an error.
• C. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to resource management.
• D. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to I/O waits and latch or enqueue contention.
• E. A user belonging to the DSS QUERIES resource consumer group can create a new session but the session will be queued.

Answer: CE

NEW QUESTION 4
user_data is a nonencryptedtablespace containing tables with data. You must encrypt ail data in this tablespace.
Which three methods can do this?

• A. Use Data Pump.
• B. Use ALTERTABL
• C. . .MOVE
• D. Use CREATE TABLE AS SELECT
• E. Use alter tablespace to encrypt the tablespace after enabling row movement on all its
• F. Use altertablespace to encrypt the tablespac

Answer: ABC

Explanation: Finally, note that you can only create encrypted tablespaces; you cannot modify existing tablespaces to encrypt them. So, when you need existing data in encrypted tablespaces, the best solution is to first create encrypted tablespaces and then move the objects from the unencrypted tablespaces to them.

NEW QUESTION 5
The CATDB12C database contains an Oracle Database 12c catalog schema owned by the rci2c user. The CATD3H database contains an Oracle Database Ug catalog schema owned by the rch user.
A database with dbid=H2324I is registered in the catdbII catalog. Both the recovery catalog databases are open.
In the CATD3i2c database, you execute the commands:
: r-ar.
RKAN> CONNECT CATALOG rci2c/passI2c@catdbi2c
RKAN> IMPORT CATALOG rcii/pwdcatUQcatdfoil DBI2=142324i; What is the outcome of the import?

• A. It fails because the target database and recovery catalog database are of different versions.
• B. It succeeds and all global scripts in the RC11 catalog that have the same name as existing global scripts in the RCI2C catalog are automatically renamed.
• C. It succeeds but the database is not automatically registered in the rc:2c catalog.
• D. It fails because RMAN is not connected to the target database with r3:T=:42324:.

Answer: B

NEW QUESTION 6
Which two statements are true about the Automatic Diagnostic Repository (ADR)?

• A. The ADR base is shared across multiple instances.
• B. The ADR base keeps all diagnostic information in binary format.
• C. The ADR can be used to store statspack snapshots to diagnose database performance issues.
• D. The ADR can be used for problem diagnosis even when the database instance is down.
• E. The ADR is used to store Automatic Workload Repository (AWR) snapshot

Answer: AD

NEW QUESTION 7
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?

• A. The impdp operation must be performed by the same user that performed the expdp operation.
• B. The path of data files on the target database must be the same as that on the source database.
• C. The export dump file must be created before starting the import on the target database.
• D. All the user defined tablespaces must be in read-only mode on the source database.
• E. The import operation must be performed by a user on the target database with the DATAPUMP_IMP_FULL_DATABASE role, and the database link must connect to a user on the source database with the DATAPUMP_EXP_FULL_DATABASE role.
• F. The source and target databases must be running on the same platform with the same endiannes

Answer: ACE

NEW QUESTION 8
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.

• A. 1, 3, 6, 4, 7
• B. 2, 1, 6, 4, 7
• C. 1, 3, 6, 7, 4
• D. 1, 3, 5, 7, 4

Answer: C

NEW QUESTION 9
Which two statements are true about roles in multitenant container databases (CDBs)?

• A. Local roles can be granted to local and common users.
• B. A common role can be granted only to a common user.
• C. A common user can create a local role by default in any pluggable database (PDB) that is plugged in to a CDB.
• D. A common role can be granted only system privileges.
• E. The root container can have both local and common roles.
• F. A local role can be assigned to a common role in a PD

Answer: DF

NEW QUESTION 10
You have installed two 64G flash devices to support the Database Smart Flash Cache feature on your database server that is running on Oracle Linux.
You have set the db_smart_flash_file parameter: DB_FLASH_CACHE_FILE= ‘ /dev/f lash_device_1‘,‘ /dev/f lash_device_2‘ How should the D3_flash_cache_size be configured to use both devices?

• A. Set DB_FLASH_CACHE_SIZE=64G.
• B. Set D3_FLASH_CACHE_SIZE=64G, 64G.
• C. Set D3_FLASK_CACKE_SI2E=i28G.
• D. db_flash_cache_SI2E is automatically configured by the instance at startu

Answer: B

Explanation: * Smart Flash Cache concept is not new in Oracle 12C - DB Smart Flash Cache in Oracle 11g.
In this release Oracle has made changes related to both initialization parameters used by DB Smart Flash cache. Now you can define many files|devices and its sizes for “Database Smart Flash Cache” are
A. In previous releases only one file|device could be defined. DB_FLASH_CACHE_FILE = /dev/sda, /dev/sdb, /dev/sdc DB_FLASH_CACHE_SIZE = 32G, 32G, 64G
So above settings defines 3 devices which will be in use by “DB Smart Flash Cache”
/dev/sda – size 32G
/dev/sdb – size 32G
/dev/sdc – size 64G
New view V$FLASHFILESTAT – it’s used to determine the cumulative latency and read counts of each file|device and compute the average latency
Reference: https://oracle-base.com/articles/12c/database-smart-flash-cache-12cr1

NEW QUESTION 11
Examine the RMAN command:
RMAN> BACKUP VALIDATE DATABASE;
Which statement is true about the execution of the command?

• A. Block change tracking must be enabled before executing this command.
• B. The database must be running in archivelog mode for the successful execution of this command.
• C. A complete database backup must exist before executing this command.
• D. The command checks for blocks containing all zeros, an invalid checksum, or a corrupt block header.
• E. The command checks for blocks that contain a valid checksum and matching headers and footers, but that has logically inconsistent contents.

Answer: D

NEW QUESTION 12
You plan to duplicate the multitenant container database (CDB) cdb1 that contains the pluggable database (PDB) SALES:
RMAN> DUPLICATE TARGET DATABASE TO cdbdup PLUGGABLE DATABASE sales
FROM ACTIVE DATABASE PASSWORD FILE
SPFILE NOFILENAMECHECK;
Which two statements are true? (Choose two.)

• A. RMAN must be connected to a recovery catalog for the execution of the command.
• B. A backup of the SALES PDB must exist before the execution of the command.
• C. The root and seed databases are included in the duplication.
• D. Only the SALES PDB is duplicated as the non-CDB CDBDUP.
• E. An auxiliary instance must have been started with the initialization parameter ENABLE_PLUGGABLE_DATABASE set to TRUE.

Answer: CE

NEW QUESTION 13
Examine the RMAN command: RMAN> RUN {
ALLOCATE CHANNEL c1 DEVICE TYPE sbt; ALLOCATE CHANNEL c2 DEVICE TYPE sbt; ALLOCATE CHANNEL c3 DEVICE TYPE sbt; BACKUP
INCREMENTAL LEVEL = 0 (DATAFILE 1, 4, 5 CHANNEL c1)
(DATAFILE 2, 3, 9 CHANNEL c2)
(DATAFILE 6, 7, 8 CHANNEL c3)
SQL ‘ALTER SYSTEM ARCHIVE LOG CURRENT’;
}
Which statement is true about the command? Choose the best answer.

• A. It uses multisection backup.
• B. It uses parallelization for the backup set.
• C. It uses asynchronous I/O for the backup.
• D. It creates compressed backup set

Answer: B

NEW QUESTION 14
Which two statements are true about a common user?

• A. A common user connected to a pluggable database (PDB) can exercise privileges across other PDBs.
• B. A common user with the create user privilege can create other common users, as well as local users.
• C. A common user can be granted only a common role.
• D. A common user can have a local schema in a PDB.
• E. A common user always uses the global temporary tablespace that is defined at the CDB level as the default temporary tablespace.

Answer: BD

NEW QUESTION 15
Which two statements are true regarding Oracle Data Pump?

• A. EXPDP and IMPDP are the client components of Oracle Data Pump.
• B. DBMS_DATAPUMP PL/SQL packages can be used independently of the Data Pump clients.
• C. Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege.
• D. Oracle Data Pump imports can be done from the export files generated in the Original Export Utility.
• E. EXPDP and IMPDP use the procedures provided by DBMS_METADATA to execute export and import commands.

Answer: AB

Explanation: References: http://docs.oracle.com/cd/B19306_01/server.102/b14215/dp_overview.htm

NEW QUESTION 16
Which three statements are true about the startup and shutdown of multitenant container databases (CDBs) and pluggable databases (PDBs)?

• A. A PDB opened in restricted mode allows only local users to connect.
• B. When a CDB is open in restricted mode, PDBs must also be opened in restricted mode.
• C. When a CDB is in mount state, PDBs are automatically placed in mount state.
• D. All PDBs must be shut down before shutting down a CDB instance.
• E. When a CDB instance is started, PDBs can be placed in open state by using database triggers or by executing the alter pluggable database command.

Answer: BCE

Explanation: Reference: https://oracle-base.com/articles/12c/multitenant-startup-and-shutdown-cdb-and-pdb- 12cr1

NEW QUESTION 17
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?

• 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 tablespac

Answer: AE

Explanation: Reference: http://docs.oracle.com/database/121/ADMIN/undo.htm#CEGJGIAE