Latest Oracle 1z0-067 Actual Free Exam Questions & Community Discussion, Page 1

Question #1

Which two statements are true about unified auditing?

A. Audit records are created only for the DML and DDL operations performed on database objects.

B. Unified auditing is enabled by setting the audit_trail parameter to db, extended.

C. Audit records are created for all users except sys.

D. A unified audit trail resides in a read-only table in the audsys schema in the system tablespace.

E. Unified auditing is enabled by executing make-fins_rdbms.mk uniaud_onioracle ORACLE_HOME=SORACLE_HOME.

F. A unified audit trail captures audit information from unified audit policies and audit settings.

Discussion 0

Correct Answer: E,F Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #2

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

A. You cannot start up or shut down a database instance by using create and configure pluggable databases by using EM express.

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 can create and configure pluggable databases by using EM express.

E. By default, EM express is available for a database after database creation.

Discussion 0

Correct Answer: E Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #3

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. An auxiliary instance must have been started with the initialization parameter ENABLE_PLUGGABLE_DATABASE set to TRUE.

E. Only the SALES PDB is duplicated as the non-CDB CDBDUP.

Discussion 0

Correct Answer: C,D Vote an answer

Question #4

Examine the output from v$DIAG_INFO:

Which statement is true about the Automatic Diagnostic Repository (ADR)?

A. The SQL trace file for a session is stored in Diag Trace

B. The text alert log is available in Diag Trace

C. The XML version of the alert log is available in Diag Trace

D. An Automatic Database Diagnostic Management (ADDM) report is generated and stored in the Health Monitor whenever an incident occurs

Discussion 0

Correct Answer: B Vote an answer

Question #5

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. 2, 1, 3, 5, 7, and 6

B. 3, 2, 5, 1, 4, and 7

C. 2, 5, 1, 4, 7, and 6

D. 1, 5, 4, 7, and 6

Discussion 0

Correct Answer: C Vote an answer

Question #6

Your Oracle 12c multitenant container database (CDB) contains multiple pluggable databases (PDBs). In the PDB hr_pdb, the common user c##admin and the local user b_admin have only the connect privilege.
You create a common role c##role1 with the create table and select any table privileges.
You then execute the commands:
SQL> GRANTc##role1 TO##Madmin CONTAINER=ALL;
SQL>CONNsys/oracle@HR_PDB as sysdba
SQL> GRANTc##role1TO b_admin CONTAINER=CURRENT;
Which two statements are true?

A. B_admin can create and select any table in both the root container and Hr_pdb.

B. The grant c##role1 to b_admin command returns an error because container should be set to ALL.

C. c##admin can create and select any table in the root container and all the PDBs.

D. C##admin can create and select any table, and grant the c##role1 role to users only in the root container.

E. B_admin can create and select any table only in hr_pdb.

Discussion 0

Correct Answer: C,E Vote an answer

Question #7

You want to perform an RMAN backup of database as a copy. Which two factors will you consider while performing the backup operation?

A. Backup can be performed only when the instance is shutdown

B. The backup as copy can only be taken to disk

C. Backup will constitute all used and unused blocks in the database

D. The backup as copy can only be taken to tape

Discussion 0

Correct Answer: B,C Vote an answer

Question #8

Which three statements are true about a job chain?

A. It can be executed using event-based or time-based schedules.

B. It cannot have more than one dependency.

C. It can contain a nested chain of jobs.

D. It cannot invoke the same program or nested chain in multiple steps in the chain.

E. It can be used to implement dependency-based scheduling.

Discussion 0

Correct Answer: A,C,E Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #9

Which two are prerequisites for performing Flashback Transaction? (Choose two.)

A. The EXECUTE privilege must be granted to a user on the DBMS_FLASHBACK package

B. Row movement must be enabled

C. Fast Recovery Area must be enabled for the database

D. Undo retention guarantee must be configured for the database

E. A supplemental log must be enabled for the primary key

Discussion 0

Correct Answer: A,E Vote an answer

Question #10

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

A. Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameters not set explicitly

B. An ASM instance mounts an ASM control file

C. An ASM instance uses the ASMB process for rebalancing of disks within a disk group

D. An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started

Discussion 0

Correct Answer: A,D Vote an answer

Question #11

Which three statements are true about Flashback Data Archieve? (Choose three.)

A. A table enabled for Flashback Data Archieve cannot be dropped unless Flashback Data Archieve is disabled or disassociated first

B. To enable Flashback Data Archieve for a table, it is mandatory to have a default Flashback Data Archieve for a database

C. To use Flashback Data Archieve, users must have unlimited quota on the Flashback Data Archieve tablespace

D. Flashback Data Archieve prevents flashback queries from getting a snapshot-too-old error

E. While enabling Flashback Data Archieve for a table, if no name is provided for Flashback Data Archieve, it is enabled using the default Flashback Data Archieve

Discussion 0

Correct Answer: A,C,D Vote an answer

Question #12

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. You must set the undo_tablespace parameter to some other tablespace name before renaming undotbs.

B. The tablespace will be renamed but the data file headers will not be updated.

C. The tablespace will be renamed and a message written to the alert log indicating that you should change the corresponding initialization parameter.

D. The statement will fail because you cannot rename an undo tablespace.

E. The tablespace will be renamed and all the changes will be logged in the alert log.

Discussion 0

Correct Answer: E Vote an answer

Question #13

Which statement is true about unified auditing?

A. Unified auditing is enabled only if the AUDIT_TRAIL parameter is set to NONE

B. The unified audit trail, by default, resides in a read-only table in the AUDSYS schema in the SYSAUX tablespace

C. Only the CREATE, ALTER, and DROP statements are audited for all users, including SYS

D. The unified audit trail contains audit records only from unified audit policies and AUDIT settings

Discussion 0

Correct Answer: B Vote an answer

Question #14

Which three statements are true about Scheduler Windows? (Choose three.)

A. Consumer groups are associated with windows.

B. Windows work with job classes to control resource allocation.

C. A database service name must be provided during window creation.

D. The Resource Manager can automatically start windowed jobs or change resource allocation among windowed jobs.

E. Only one window can be open at one time.

Discussion 0

Correct Answer: B,C,E Vote an answer

Question #15

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 a table that has been logically corrupted

C. when recovering a table to a point in time

D. when recovering dropped tables that are present in the recyclebin

E. when recovering the data of a table to the desired point in time, which is more recent than the oldest available undo.

Discussion 0

Correct Answer: A Vote an answer

Oracle 1z0-067 Actual Free Exam Questions & Community Discussion

Download Free Oracle 1z0-067 Demo