Oracle 1Z0-067 Dumps Questions 2021

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

Answer: D

Explanation: To enable the dbms_server_alert package functionality, set the statistical_level initialization parameter to TYPICAL or ALL.
http://www.dba-oracle.com/t_dbms_server_alert.htm

NEW QUESTION 2
In a database supporting an OLTP workload, tables are frequently updated on both key and nonkeycolumns. Reports are also generated by joining multiple tables.
Which table organization or type would provide the best performance for this hybrid workload?

• A. heap table with a primary key index
• B. external table
• C. hash clustered table
• D. global temporary table
• E. index clustered table

Answer: E

Explanation: Do not cluster tables if the application joins them only occasionally or modifies their common column values frequently. Modifying a row’s cluster key value takes longer than modifying the value in an unclustered table, because Oracle might need to migrate the modified row to another block to maintain the cluster.
http://docs.oracle.com/cd/B28359_01/server.111/b28274/data_acc.htm#i7690

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

• A. SALESPDB is created and is in mount state.
• B. PDB creation fails because the D3_file_name_convert parameter is not set in the CDB.
• C. SALESPDB is created and is in read/write mode.
• D. PDB creation fails because a default temporary tablespace is not defined for SALESPD

Answer: A

Explanation: We need seed tablespace to create new plugable db.
/u01/app/oracle/oradata/orcl/pdbseed/sysaux01.dbf
/u01/app/oracle/oradata/orcl/pdbseed/system01.dbf By default. Seed has two tbs.

NEW QUESTION 4
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 5
Before a Flashback Table operation, you execute the following command: ALTER TABLE employees ENABLE ROW MOVEMENT;
Why would you need this to be executed?

• A. Because row IDs may change during the flashback operation
• B. Because the object number changes after the flashback operation
• C. Because the rows are retrieved from the recycle bin during the flashback operation
• D. Because the table is moved forward and back to a temporary during the flashback operation

Answer: A

NEW QUESTION 6
Your multitenant container database (CDB) cdb1, which has no startup triggers and contains multiple pluggable databases (PDBs), is started up by using the command:
SQL>STARTUP
Which two statements are true about the successful execution of the command?

• A. All redo log files are opened.
• B. The root, the seed, and all the PDBs are opened in read-write mode.
• C. All the PDBs are opened in read-write mode.
• D. All the PDBs are in closed state.
• E. Only the root database is opened in read-write mod

Answer: AE

Explanation: The 12.1.0.2 patchset has introduced the ability to preserve the startup state of PDBs, so you probably shouldn’t be implementing a trigger in the manner discussed in this section. Prior to 12.1.0.2, when the CDB is started, all PDBs remain in mounted mode. There is no default mechanism to automatically start them when the CDB is started. The way to achieve this is to use a system trigger on the CDB to start some or all of the PDBs.

NEW QUESTION 7
Which statements describe the capabilities of the DBMS_NETWORK_ACL_ADMIN package? (Choose all that apply.)

• A. It can be used to allow the access privilege settings for users but not roles.
• B. It can be used to allow the access privilege settings for users as well as roles.
• C. It can be used to control the time interval for which the access privilege is available to a user.
• D. It can be used to selectively restrict the access for each user in a database to different hostcomputers.
• E. It can be used to selectively restrict a user's access to different applications in a specific host computer.

Answer: BCD

NEW QUESTION 8
The following parameters are set for your Oracle 12c database instance: OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSE OPTIMIZER_USE_SQL_PLAN_BASELINES=TRUE
You want to manage the SQL plan evolution task manually. Examine the following steps:
1. Set the evolve task parameters.
2. Create the evolve task by using the DBMS_SPM.CREATE_EVOVLE_TASK function.
3. Implement the recommendations in the task by using the DBMS_SPM.IMPLEMENT_EVOLVE_TASK function.
4. Execute the evolve task by using the DBMS_SPM.EXECUTE_EVOLVE_TASK function.
5. Report the task outcome by using the DBMS_SPM.REPORT_EVOLVE_TASK function. Identify the correct sequence of steps.

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

Answer: B

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
Your database is running in archive log mode and Automatic Undo Management is enabled. Which two tasks should you perform before enabling Flashback Database?

• A. Enable minimal supplemental logging.
• B. Ensure that the db_flashback_retention_target parameter is set to a point in time (in minutes) to which the database can be flashed back.
• C. Enable the recyclebin.
• D. Enable undo retention guarantee.
• E. Enable Fast Recovery Area.

Answer: BE

Explanation: https://docs.oracle.com/database/121/BRADV/flashdb.htm#BRADV582 Section: About Flashback Database
Flashback Database uses its own logging mechanism, creating flashback logs and storing them in the fast recovery are
A. You can only use Flashback Database if flashback logs are available. To take
advantage of this feature, you must set up your database in advance to create flashback logs.

NEW QUESTION 11
Which three conditions must be true for unused block compression to be used automatically while performing backups by using RMAN?

• A. The compatible initialization parameter is set to 10.2 or higher.
• B. There are no guaranteed restore points defined for the database.
• C. The default device for the backup must be set to disk.
• D. The tablespaces are locally managed.
• E. The fast recovery area is less than 50 percent fre

Answer: ABD

Explanation: About Unused Block Compression When employing unused block compression, RMAN skips reading, and backing up, any database blocks that are not currently allocated to some database object. This is regardless of whether those blocks had previously been allocated. So if a database table is dropped,
RMAN will not back up the space that was occupied by that table until new objects are created in that space. Unused block compression is used automatically when the following conditions are true:
-The COMPATIBLE initialization parameter is set to 10.2 or higher. -There are currently no guaranteed restore points defined for the database. -The data file is locally managed. -The data file is being
backed up to a backup set as part of a full backup or a level 0 incremental backup. -The backup set is created on disk, or Oracle Secure Backup is the media manager.
References: http://docs.oracle.com/database/121/BRADV/rcmcncpt.htm#BRADV89481

NEW QUESTION 12
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 13
As part of a manual update process, you install Oracle Database 12c software, prepare a new ORACLE_HOME, you shut down an existing single-instance database that runs from that ORACLE_HOME.
What should you do next to start the upgrade of this database?

• A. Start up the database instance by using the STARTUP UPGRADE command by using the server parameter file.
• B. Start up the database instance by using the new location of the server parameter file and run the catupgrd.sql script from the new ORACLE_HOME to use parallel upgrade options that reduce down time.
• C. Start up the database instance by using the new location of the server parameter file and run the catctl.pl script from the new ORACLE_HOME to use parallel upgrade options that reduce down time.
• D. Start up the database instance by using the new location of the server parameter file and run the catuppst.sql script to generate informational messages and log files during the upgrade.

Answer: C

NEW QUESTION 14
You want RMAN to make duplicate copies of data files when using the backup command. What must you set using the RMAN configure command to achieve this?

• A. MAXSETSIZE TO 2;
• B. DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
• C. CHANNEL DEVICE TYPE DISK FORMAT '/disk1/%U' , '/disk2/%U';
• D. DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;

Answer: D

Explanation: Configuring Backup Duplexing You can use the CONFIGURE ... BACKUP COPIES command to specify how many copies of each backup piece should be created on the specified device type for the
specified type of file. This type of backup is known as a duplexed backup set. The CONFIGURE settings for duplexing only affect backups of datafiles, control files, and archived logs into backup
sets, and do not affect image copies. NOT A The CONFIGURE MAXSETSIZE command limits the size of backup sets created on a channel. This CONFIGURE setting applies to any channel, whether manually allocated or configured, when the BACKUP command is used to create backup sets. The default value
is given in bytes and is rounded down to the lowest kilobyte value. Reference: http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmconfa.htm#BRADV137

NEW QUESTION 15
Your database is running in ARCHIVELOG mode. You backup your database regularly. If certain files are lost, an incomplete recovery is required.
In which two cases is this true?

• A. flashback logs
• B. inactive online redo log
• C. current online redo log member
• D. all control files
• E. archived log files required to perform recovery

Answer: BD

NEW QUESTION 16
Identify three reasons for using a recovery catalog with Recovery Manager (RMAN).

• A. to store backup information of multiple databases in one place
• B. to restrict the amount of space that is used by backups
• C. to maintain a backup for an indefinite period of time by using the KEEP FOREVER clause
• D. to store RMAN scripts that are available to any RMAN client that can connect to target databases registered in the recovery catalog
• E. to automatically delete obsolete backups after a specified period of time

Answer: ACD