Oracle 1Z0-067 Free Practice Questions 2021

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
You are administering a multitenant container database (CDB) cdb1 that is running in archivelog mode and contains pluggable databases (PDBs), pdb_1 and pdb_2.
While opening pdb_1, you get an error: SQL> alter pluggable database pdb_1 open;
ORA-01157: cannot identify/lock data file 11-see DBWR trace file
ORA-01110:data file 11:'/u01/app/oracle/oradata/cdb1/pcb_1/example01.dbf'
To repair the failure, you open an RMAN session for the target database CDB$ROOT. You execute the following as the first command:
RMAN>REPAIR FAILURE;
Which statement describes the consequence of the command?

• A. The command performs the recovery and closes the failure.
• B. The command produces an error because RMAN is not connected to the target database pdb_1.
• C. The command produces an error because the advise failure command was not executed before the REPAIR FAILURE command.
• D. The command executes successfully, performs recovery, and opens PDB_1.

Answer: C

Explanation: Usage Notes Repairs are consolidated whenever possible so that a single repair can fix multiple
failures. Be advised that REPAIR FAILURE requires you to explicitly run ADVISE FAILURE in the current session to successfully repair each of the identified failures. You typically iterate through a REPAIR
session with the following commands: -REPAIR FAILURE; -LIST FAILURE; -ADVISE FAILURE; -REPAIR
FAILURE;
http://docs.oracle.com/database/121/RCMRF/rcmsynta2004.htm#RCMRF199

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

• A. SQL Performance Analyzer
• B. SQL Access Advisor
• C. SQL Tuning Advisor
• D. Automatic Workload Repository (AWR) report
• E. Automatic Database Diagnostic Monitor (ADDM)

Answer: B

Explanation: References:
http://docs.oracle.com/cd/B28359_01/server.111/b28275/tdppt_sqltune.htm#TDPPT160

NEW QUESTION 4
Your database is running in noarchivelog mode. One of the data files belonging to the system tablespace is corrupted. You notice that all online redo logs have been overwritten since the last backup.
Which method would you use to recover the data file?

• A. Shut down the instance if not already shut down, restore all data files belonging to the system tablespace from the last backup, and restart the instance.
• B. Shut down the instance if not already shut down, restore the corrupted data file belonging to the system tablespace from the last backup, and restart the instance.
• C. Shut down the instance if not already shut down, restore all data files for the entire database from the last backup, and restart the instance.
• D. Mount the database, restore all data files belonging to the system tablespace from the last backup, and open the database.

Answer: C

Explanation: Reference: https://docs.oracle.com/database/121/BRADV/rcmadvre.htm#BRADV89841

NEW QUESTION 5
In the SPFILE, UNDO TABLESPACE is Set to UNDO TBS.
You rename the undotbs undo tablespace:
ALTER TABLESPACE undotbs RENAME TO undotbs_old; Which statement is true?

• A. The tablespace will be renamed but the data file headers will not be updated.
• B. The statement will fail because you cannot rename an undo tablespace.
• C. The tablespace will be renamed and all the changes will be logged in the alert log.
• D. The tablespace will be renamed and a message written to the alert log indicating that you should change the corresponding initialization parameter.
• E. You must set the undo_tablespace parameter to some other tablespace name before renaming undotbs.

Answer: C

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

• 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

Answer: AEG

Explanation: HCC requires the use of Oracle Storage – Exadata (A), Pillar Axiom (G) or Sun ZFS Storage Appliance (ZFSSA).
Note:
* Hybrid Columnar Compression, initially only available on Exadata, has been extended to support Pillar Axiom and Sun ZFS Storage Appliance (ZFSSA) storage when used with Oracle Database Enterprise Edition 11.2.0.3 and above
* Oracle offers the ability to manage NFS using a feature called Oracle Direct NFS (dNFS). Oracle Direct NFS implements NFS V3 protocol within the Oracle database kernel itself. Oracle Direct NFS client overcomes many of the challenges associated with using NFS with the Oracle Database with simple configuration, better performance than traditional NFS clients, and offers consistent configuration across platforms.

NEW QUESTION 7
Which three statements are true about unplugging a pluggable database (PDB)?

• A. The PDB must be open in read only mode.
• B. The PDB must be dosed.
• C. The unplugged PDB becomes a non-CDB.
• D. The unplugged PDB can be plugged into the same multitenant container database (CDB)
• E. The unplugged PDB can be plugged into another CDB.
• F. The PDB data files are automatically removed from dis

Answer: BDE

Explanation: B, not A: The PDB must be closed before unplugging it.
D: An unplugged PDB contains data dictionary tables, and some of the columns in these encode information in an endianness-sensitive way. There is no supported way to handle the conversion of such columns automatically. This means, quite simply, that an unplugged PDB cannot be moved across an endianness difference.
E (not F): To explogt the new unplug/plug paradigm for patching the Oracle version most effectively, the source and destination CDBs should share a filesystem so that the PDB’s datafiles can remain in place.

NEW QUESTION 8
You want to migrate your Oracle 11g database as a pluggable database (PDB) in a multitenant container database (CDB).
Examine the steps required to perform the migration:
1. Use Data Pump export to perform a full transportable export on the source database with the export parameter VERSION=12.
2. Place all tablespaces in read-only mode on the source database.
3. Upgrade the source database to Oracle Database 12c.
4. Copy the dump file and data files to the desired location in the target database.
5. Create a new PDB in the target CDB.
6. Synchronize the PDB on the target CDB.
7. Use Data Pump import on the new PDB by using the full transportable import options. Identify the required steps in the correct order.
Choose the best answer.

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

Answer: C

NEW QUESTION 9
ENCRYPT_TS an encrypted tablespace that contains tables with data.
Which statement is true about queries and data manipulation language statements on these tables?

• A. Queries may be performed on columns that have the NO SALT option.
• B. Data remains encrypted when read into the buffer cache.
• C. Redo generated by DML remains encrypted.
• D. UNDO generated by DML remains encrypted if the UNDO tablespace is encrypted.
• E. Data remains encrypted when read into the PGA for direct path read

Answer: C

NEW QUESTION 10
You wish to enable an audit policy for all database users, except sys, system, and scott. You issue the following statements:
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYS; SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYSTEM; SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SCOTT;
For which database users is the audit policy now active?

• A. all users except sys
• B. all users except scott
• C. all users except sys and scott
• D. all users except sys, system, and scott

Answer: B

NEW QUESTION 11
As part of a manual upgrade process, after installing the software for Oracle Database 12c and preparing the new Oracle home, you shut down the existing single-instance database.
Which step should you perform next to start the upgrade of the database?

• A. Start up the database instance by using the new location of the server parameter file and run the catuppst.sqi script to generate informational messages and log files during the upgrade.
• B. Start up the database instance by using the new location of the server parameter file and run the cact1.pl script from the new Oracle home to use parallel upgrade options that reduce down time.
• C. Start up the database instance by using the STARTUP UPGRADE command and gather fixed object statistics to minimize the time needed for recompilation.
• D. Start up the database instance by using the STARTUP UPGRADE command, which opens the existing database, and then performs additional upgrade operations.

Answer: D

NEW QUESTION 12
You created a database with DBCA by using one of the Oracle supplied templates. Which is the default permanent tablespace for all users except DBSNMP and OUTLN?

• A. USERS
• B. SYSTEM
• C. SYSAUX
• D. EXAMPLE

Answer: A

Explanation: This table space is used to store permanent user objects and dat
A. Like the TEMP table space, every
database should have a table space for permanent user data that is assigned to users. Otherwise, user objects will be created in the SYSTEM table space, which is not good practice. In the
preconfigured database, USERS is assigned the default table space, and space for all objects created by non-system users comes from this table space. For system users, the default permanent table space remains SYSTEM.

NEW QUESTION 13
Which three types of failures are detected by the Data Recovery Advisor (DRA)?

• A. loss of a non-critical data file
• B. loss of a control file
• C. physical data block corruption
• D. logical data block corruption
• E. loss of an archived redo log file

Answer: BDE

Explanation: Data Recovery Advisor can diagnose failures such as the following: Components such as datafiles and control files that are not accessible because they do not exist, do not have the correct access permissions, have been taken offline, and so on Physical corruptions such as block checksum failures and invalid block header field values

NEW QUESTION 14
Which two statements are true about setting the FAST_START_MTTR_TARGET parameter to a nonzero value? (Choose two.)

• A. The value of the LOG_CHECKPOINT_INTERVAL parameter overrides the value of the FAST_START_MTTR_TARGET parameter.
• B. The MTTR advisor is enabled only if the value is greater than the default value.
• C. Automatic checkpoint tuning is enabled.
• D. The time taken to recover an instance after a crash is always exactly the same as the value set for the FAST_START_MTTR_TARGET parameter.

Answer: AB

NEW QUESTION 15
You must unload data from the orders, order_items, and products database tables to four files using the External Tables.
CREATE TABLE orders_ext
(order_id, order_date, product_id, product_name,quantity) ORGANIZATION EXTERNAL
(
TYPE ORACLE_DATAPUMP DEFAULT DIRECTORY ext.dir
LOCATION (‘ordersl.dmp','orders2.dmp’,’orders3.dmp’,’lorders4.dmp')
) PARALLEL AS
SELECT o.order_id,o.order_date,p.product_id,p.product_name,i.quantity FROM orders o,productsp,order_itemsi
WHERE o.orderjd = i.order_id and i.product_id = p.product_id;
You execute the command shown in the Exhibit, but only two files are created. Which parameter must be changed so that four files are created?

• A. TYPE
• B. LOCATION
• C. PARALLEL
• D. DEFAULT DIRECTORY
• E. ORGANIZATION EXTERNAL

Answer: C

Explanation: Reference: https://docs.oracle.com/cd/B19306_01/server.102/b14215/et_concepts.htm#i1007483

NEW QUESTION 16
Which two statements are true about making RMAN image copies of a database? Choose two.

• A. They can be made only when the database is running in ARCHIVELOG mode.
• B. They consist of all used and unused blocks in the data files.
• C. They can be made only when the database is in MOUNT state.
• D. They can only be written to disk.
• E. They can be made only when the database is running in NOARCHIVELOG mod

Answer: BD

NEW QUESTION 17
View the SPFILE parameter settings in the Exhibit.

You issue this command and get errors: SQL> startup
ORA-00824:cannotsetSGAJTARGET or MEMORY_TARGET dueto existing internalsettings,seealertlog for moreinformation
Why did the instance fail to start?

• A. because pga_aggregate_target is not set
• B. because statistics_level is set to basic
• C. because memory_target and memory_max_target cannot be equal
• D. because sga_target and memory_target are both set

Answer: B

Explanation:
SQL> startup nomount ORA-01078: failure in processing system parameters ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings ORA-00848: STATISTICS_LEVEL cannot be set to BASIC with SGA_TARGET or MEMORY_TARGET SQL>

NEW QUESTION 18
You want to move your existing recovery catalog to another database. Examine the steps:
1) Export the catalog data by using the Data Pump Export utility in the source database.
2) Create a recovery catalog user and grant the necessary privileges in the target database.
3) Create a recovery catalog by using the create catalog command.
4) Import the catalog data into the new recovery catalog by using the Data Pump Import utility in the target database.
5) Import the source recovery catalog schema by using the import catalog command.
6) Connect to the destination database.
7) Connect as catalog to the destination recovery catalog schema.
Identify the option with the correct sequence for moving the recovery catalog.

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

Answer: B