Oracle 1Z0-067 Dumps Questions 2021

NEW QUESTION 1
In which situation can you use Flashback Database?

• A. when undoing a shrink data file operation
• B. when retrieving a dropped tablespace
• C. when returning to a point in time before the restoration or re-creation of a control file
• D. when returning to a point in time before the most recent open resetlogs operation

Answer: D

Explanation: TO BEFORE RESETLOGS Returns the database to its state including all changes up to the SCN of the most recent OPEN RESETLOGS. Note: FLASHBACK DATABASE can only return the database to a point before the most recent OPEN RESETLOGS operation if your database has been upgraded to Oracle Database 10g Release 2 or later. http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta023.htm#RCMRF194

NEW QUESTION 2
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 3
Examine the command to back up the ASM metadata: ASMCMD>md_backup /backup/ASM_backup
In which three situations can you use the backup?

• A. when one or more disks in an ASM disk group are lost
• B. when the data file on an ASM disk group gets corrupted
• C. when one of the disks in a disk group is accidentally unplugged
• D. when one or more file directory paths are accidentally deleted from an ASM disk group
• E. when all the ASM disk groups for the ASM instance are lost

Answer: ADE

Explanation: http://www.hhutzler.de/blog/asm-backup-and-restore-dg-metadata/
The md_backup command creates a backup file containing metadata for one or more disk groups. i By default all the mounted disk groups are included in the backup file which is saved in the current working directory. http://docs.oracle.com/cd/E11882_01/server.112/e18951/asm_util004.htm#OSTMG94578
The md_backup command creates a backup file containing metadata for one or more disk groups.

NEW QUESTION 4
Examine the following steps of privilege analysis for checking and revoking excessive, unused privileges granted to users:
1. Create a policy to capture the privileges used by a user for privilege analysis.
2. Generate a report with the data captured for a specified privilege capture.
3. Start analyzing the data captured by the policy.
4. Revoke the unused privileges.
5. Compare the used and unused privileges' lists.
6. Stop analyzing the data.
Identify the correct sequence of steps.

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

Answer: B

Explanation: 1. Create a policy to capture the privilege used by a user for privilege analysis.
3. Start analyzing the data captured by the policy.
6. Stop analyzing the data.
2. Generate a report with the data captured for a specified privilege capture.
5. Compare the used and unused privileges’ lists.
4. Revoke the unused privileges.

NEW QUESTION 5
What two are the prerequisites for enabling Flashback Database?

• A. The database must be in ARCHIVELOG mode
• B. The database must be in MOUNT EXCLUSIVE mode
• C. The database must be opened in RESTRICTED mode
• D. The database instance must be started in the NOMOUNT state
• E. The database instance must have the keep buffer pool defined

Answer: AB

NEW QUESTION 6
Which two are prerequisites for creating a backup-based duplicate database?

• A. connecting to the target database and a recovery catalog to execute the duplicate command
• B. creating a password file for an auxiliary instance
• C. connecting to an auxiliary instance
• D. matching the database identifier (DBID) of the source database and the duplicate database
• E. creating an SPFILE for the target database

Answer: BC

Explanation: References:
http://docs.oracle.com/cd/E11882_01/backup.112/e10643/rcmsynta020.htm#CHDEDFFH

NEW QUESTION 7
Examine the commands:
SQL> ALTER SESSION SET RECYCLBIN = ON;
Session altered.
SQL> DROP TABLE emp; --(First EMP table) Total dropped.
SQL> CREATE TABLE emp (id NUMBER CONSTRAINT emp_id_idx PRIMARY KEY, name VARCHAR2 (15), salary NUMBER(7,2) );
Table created.
You then execute multiple INSERT statements to insert rows into EMP table and drop the table again: SQL> DROP TABLE emp; -- (Second EMP table)
Table dropped.
SQL> FLASHBACK TABLE emp TO BEFORE DROP;
Which statement is true about the FLASHBACK command?

• A. It recovers the structure, data, and indexes of the first emp table.
• B. It recovers only the structure of the second emp table.
• C. It returns an error because two tables with the same name exist in the recycle bin.
• D. It recovers the structure, data, and indexes of the second emp tabl

Answer: D

NEW QUESTION 8
Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?

• A. By default, EM express is available for a database after database creation.
• B. You can use EM express to manage multiple databases running on the same server.
• C. You can perform basic administrative tasks for pluggable databases by using the EM express interface.
• D. You cannot start up or shut down a database instance by using create and configure pluggable databases by using EM express.
• E. You can create and configure pluggable databases by using EM expres

Answer: A

Explanation: EM Express is built inside the database. Note:
Oracle Enterprise Manager Database Express (EM Express) is a web-based database management tool that is built inside the Oracle Database. It supports key performance management and basic database administration functions. From an architectural perspective, EM Express has no mid-tier or middleware components, ensuring that its overhead on the database server is negligible.

NEW QUESTION 9
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 10
Which two resources might be prioritized between competing pluggable databases (PDBs) when creating a multitenant container database (COB) plan using Oracle Database Resource Manager?

• A. maximum undo per consumer group
• B. maximum idle time for a session in a PDB
• C. parallel server limit
• D. CPU
• E. maximum number of sessions for a PDB

Answer: CD

NEW QUESTION 11
You wish to create jobs to satisfy these requirements:
1. Automatically bulk load data from a flat file.
2. Rebuild indexes on the SALES table after completion of the bulk load. How would you create these jobs?

• A. Create both jobs by using Scheduler raised events.
• B. Create both jobs using application raised events.
• C. Create one job to rebuild indexes using application raised events and another job to perform bulk load using Scheduler raised events.
• D. Create one job to rebuild indexes using Scheduler raised events and another job to perform bulk load by using events raised by the application.

Answer: C

Explanation: The bulk loader would be started in response to a file watcher scheduler event and the indexes would be rebuilt in response to an application event raised by the bulk loader. https://docs.oracle.com/cd/E18283_01/server.112/e17120/scheduse005.htm#CIABIEJA Your application can raise an event to notify the Scheduler to start a job. A job started in this way is referred to as an event-based job. The job can optionally retrieve the message content of the event. https://docs.oracle.com/cd/B28359_01/server.111/b28310/scheduse008.htm#CHDIAJEB

NEW QUESTION 12
Which two statements are true regarding an Automatic Storage Management (ASM) instance? (Choose two.)

• A. An ASM instance mounts an ASM control file
• B. An ASM instance uses the ASMB process for rebalancing of disks within a disk group
• C. Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameters not set explicitly
• D. An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started

Answer: CD

NEW QUESTION 13
Your database is running in ARCHIVELOG mode and flashback is enabled.
In which scenario must you use RMAN backups for recovering tables and table partitions? Choose the best answer.

• A. when recovering data that was lost after a DDL operation modified the structure of a table
• B. when recovering dropped tables that are present in the recyclebin
• C. when recovering a table that has been logically corrupted
• D. when recovering a table to a point in time
• E. when recovering the data of a table to the desired point in time, which is more recent than the oldest available undo.

Answer: A

NEW QUESTION 14
Your database is running in archivelog mode. Examine the parameters for your database instance: LOG_ARCHIVE_DEST_l ='LOCATION=/disk1/arch MANDATORY'
LOG_ARCHIVE_DEST_2 ='LOCATION=/disk2/arch' LOG_ARCHIVE_DEST_3 ='LOCATIO=/disk3/arch' LOG_ARCHIVE_DEST _4 ='LOCATIONs/disk4/arch' LOG_ARCHIVE _MIN_SUCCEED_DEST = 2
While the database is open, you notice that the destination set by the log_archive_dest_1 parameter is not available. All redo log groups have been used.
What happens at the next log switch?

• A. The database instance hangs and the redo log files are not overwritten.
• B. The archived redo log files are written to the fast recovery area until the mandatory destination is made available.
• C. The database instance is shutdown immediately.
• D. The destination set by the log_archive_dest parameter is ignored and the archived redo log files are created in the next two available locations to guarantee archive log success.

Answer: A

Explanation: Made more logfile switch until all redos groups are full. first log switch succeds, second also succeds then next will hang database.

NEW QUESTION 15
Examine the command to create a pluggable database (PDB): SQL> CREATE PLUGGABLE DATABASE pdb2 FROM pdb1
FILE_NAME-_CONVERT = ('/disk1/oracle/pdb1/', '/disk2/oracle/pdb2/’) PATH_PREFIX = '/disk2/oracle/pdb2';
Which two statements are true?

• A. The pluggable database pdb2 is created by cloning pdb1 and is in mount state.
• B. Details about the metadata describing pdb2 are stored in an XML file in the '/disk2/oracle/pdb2/' directory.
• C. The tablespace specifications of pdb2 are the same as pdb1.
• D. All database objects belonging to common users in PD3I are cloned in PD32.
• E. pdb2 is created with its own private undo and temp tablespace

Answer: AC

Explanation: References: https://docs.oracle.com/database/121/ADMIN/cdb_plug.htm#ADMIN13586

NEW QUESTION 16
View the Exhibit showing steps to create a database resource manager plan. SQL>executedbms_resource_manager.create_pendingarea(); PL/SQLproceduresuccessfully completed. 3QL>execdbms_resource_manager,create_consumergroup (consumer_group=>’OLTP,,comment=>,onlineuser’) PL/SQLproceduresuccessfullycompleted. SQL>execdbras_resource_raanager.create_plan(plan=>’PRIU3ER3',comment=>'dssprio’); SQL>exec
Dbms_resource_manager.create_plan_directive(plan=>’PRIU3ER3’,group_or_subplan=>'OLTP’,comra ent=>'onlinegrp'CPU_Pl=>60);
PL/3QLproceduresuccessfullycompleted.
After execting the steps in the exhibit you execute this procedure, which results in an error: SQL> EXECUTEdbms_resource_manager. validate_pending_area ();
What is the reason for the error?

• A. The pending area is automatically submitted when creating plan directives.
• B. The procedure must be executed before creating any plan directive.
• C. The sys_group group is not included in the resource plan.
• D. The other_groups group is not included in the resource plan.
• E. Pending areas can not be validated until submitted.

Answer: D

Explanation: Reference: http://apunhiran.blogspot.com/2011/01/how-to-setup-resource-manager-to_14.html