Oracle 1Z0-067 Exam Dumps 2021

NEW QUESTION 1
For your database, an incremental level 1 backup is taken every week day. On Tuesday, before the backup is performed, you add a new tablespace.
You execute the command:
RMAN> BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG WEEKLY DATABASE;
Which statement is true about the execution of the command?

• A. It returns an error because there is no level 0 backup available for new data files.
• B. It performs an image copy backup of new data files, and a level 1 incremental backup of all other data files.
• C. It performs a level-0 backup of all data files including those that belong to the new tablespace.
• D. It performs an image copy backup of all data files including those that belong to the new tablespace.
• E. It performs a backup as a backup set of all data files including those that belong to the new tablespace.

Answer: B

Explanation: References: https://docs.oracle.com/cd/B19306_01/backup.102/b14192/bkup004.htm

NEW QUESTION 2
Which two statements are true about Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)?
Choose two.

• A. If no PDB plan is enabled for a pluggable database, the PDB uses the CDB plan.
• B. To enable a resource plan for a PDB, a CDB resource plan must be created and enabled.
• C. If no PDB plan is enabled for a pluggable database, all sessions for that PDB are treated to an equal share of resources.
• D. If a PDB plan is enabled for a pluggable database, Resource Manager uses the resource allocation at the PDB level and ignores the limits set at the CDB level.
• E. If a PDB plan is enabled for a pluggable database, resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.

Answer: AE

NEW QUESTION 3
You install "Oracle Grid Infrastructure for a standalone server" on a host on which the orcl1 and orcl2 databases both have their instances running.
Which two statements are true?

• A. Both orcl1 and orcl2 are automatically added to the Oracle Restart configuration.
• B. All database listeners running from the database home are automatically added to the Oracle Restart configuration.
• C. The srvct1 add database command must be used to add orcl1 and orcl2 to the Oracle Restart configuration.
• D. The crsct1 start has command must be used to start software services for Oracle Automatic Storage Management (ASM) after the "Oracle Grid Infrastructure for a standalone server" installation is complete.
• E. All databases subsequently created by using the Database Configuration Assistant (DBCA) are automatically added to the Oracle Restart configuration.

Answer: CE

Explanation: https://docs.oracle.com/cd/E18283_01/server.112/e17120/restart001.htm

NEW QUESTION 4
You notice performance degradation in your production Oracle 12c database. You want to know what caused this performance difference.
Which method or feature should you use?

• A. Database Replay
• B. Automatic Database Diagnostic Monitor (ADDM) Compare Period report
• C. Active Session History (ASH) report
• D. SQL Performance Analyzer

Answer: B

Explanation: References: http://docs.oracle.com/cd/E24628_01/server.121/e17635/tdppt_degrade.htm

NEW QUESTION 5
Examine these Data Pump commands to export and import objects from and to the same database. The dba has not yet created users hr1 and oe1.
$expdp system/manager schemas = hr.oe directory = EXP_DIR dumpfile = export.dat include = table
$ impdpsysten/manager schemas = hr1,oe1 directory = EXP_DIR dumpfile = export.dat
remap_schena=hr:hrl, oe:oe1
What will happen when running these commands?

• A. expdp will fail because no path has been defined for the dumpfile.
• B. expdp will succeed but impdp will fail because the users do not exist.
• C. inpdp will create two users called hr1 and oe1 and import all objects to the new schemas.
• D. impdp will create two users called hr1 and oe1 and import only the tables owned by hr and oe schemas to ht1 and oe1 schemas, respectively.

Answer: B

Explanation: ORA-39165: Schema not found error will be resulted

NEW QUESTION 6
On your Oracle 12c database, you invoke SQL*Loader to load data into the employees table in the hr schema by issuing the command:
S>sqlldrhr/hr@pdb table=employees
Which two statements are true about the command?

• A. It succeeds with default settings if the employees table exists in the hr schema.
• B. It fails because no SQL*Loader data file location is specified.
• C. It fails if the hr user does not have the create any directory privilege.
• D. It fails because no SQL*Loader control file location is specified.
• E. It succeeds and creates the employees table in the HR schem

Answer: AC

Explanation: sqlldr scott/tiger@pdb1 TABLE=EMP2 DATE_FORMAT=”DD-MON-YYYY HH24:MI:SS” https://oraclebase. com/articles/12c/sql-loader-enhancements-12cr1

NEW QUESTION 7
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 8
You are administering a multitenant container database (CDB) CDB1 with two pluggable databases (PDBs), PDB1 and PDB2. You execute the following commands on CBD$ROOT as the SYS user: SQL> CREATE USER c##scott IDENTIFIED BY scottorcl1;
SQL> GRANT CREATE SESSION TO c##scott;
Which statement is true about the C##SCOTT user? Choose the best answer.

• A. It is created in all the PDBs with CREATE SESSION privilege.
• B. It is created in all the PDBs but has CREATE SESSION privilege only in CDB$ROOT.
• C. It is created and has the CREATE SESSION privilege only in a PDB that is open.
• D. It is created only in CDB$ROOT and has the CREATE SESSION privileg

Answer: D

NEW QUESTION 9
You execute the commands on a multitenant container database CDB1 that has multiple pluggable databases:
$ . oraenv
ORACLE_SID = [oracle] ? cdb1
The oracle base for ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1 is /u01/app/oracle
$ rman target /
Recovery Manager : Release 12.1.0.0.2 - production on Fri Ju1 19 05:18:33: 2013 Coppyright (c) 1982, 2013, oracle and/or its affiliates. All rights reserved. Connected to target database:CDB1 (DBID=782249327)
RMAN>SELECT name FROMv$tablespace;
Which statement is true about the execution of the last command?

• A. It succeeds and displays all the tablespaces that belong to the root database.
• B. It fails and returns an error because a connection is not made by using the sysdba privilege.
• C. It succeeds and displays all the tablespaces that belong to the root and pluggable databases.
• D. It fails and returns an error because SQL commands cannot be executed at the RMAN promp

Answer: C

NEW QUESTION 10
You create a table with the period for clause to enable the use of the Temporal Validity feature of Oracle Database 12c.
Examine the table definition: create table employees
(empno number, salary number, deptid number, name varchar2(100), period for employee_time);
Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table?

• A. The valid time columns employee_time_start and employee_time_end are automatically created.
• B. The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.
• C. The valid time columns are not populated by the Oracle Server automatically.
• D. The valid time columns are visible by default when the table is described.
• E. Setting the session valid time using DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for data manipulation language (DML), data definition language (DDL), and queriesperformed by the sessio

Answer: ABC

NEW QUESTION 11
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 TOcMadmin CONTAINER=ALL;
SQL>CONNsys/oracle@HR_PDB assysdba
SQL> GRANTc##role1TO b_admin CONTAINER=CURRENT;
Which two statements are true?

• A. C##admin can create and select any table, and grant the c##role1 role to users only in the root container.
• B. B_admin can create and select any table in both the root container and kr_pdb.
• C. c##admin can create and select any table in the root container and all the PDBs.
• D. B_admin can create and select any table only in hr_pdb.
• E. The grant c=»role1 to b_admin command returns an error because container should be set to AL

Answer: CD

NEW QUESTION 12
Examine the commands executed in the root container of your multitenant container database (CDB) that has multiple pluggable databases (PDBs):
SQL> CREATE USER c##a_admin IDENTIFIED BY orcl123; SQL> CREATE ROLE c##role1 CONTAINER=ALL;
SQL> GRANT CREATE VIEW TO C##roleI CONTAINER=ALL;
SQL> GRANT c##role1 TO c##a_admin CONTAINER=ALL; SQL> REVOKE c##role1 FROM c##a_admin;
What is the result of the revoke command?

• A. It executes successfully and the c##role1 role is revoked from the c##a_admin user only in the root container.
• B. It fails and reports an error because the container=all clause is not used.
• C. It executes successfully and the c##rocl1 role is revoked from the c##a_admin user in the root database and all the PDBs.
• D. It fails and reports an error because the comtainer=current clause is not use

Answer: B

Explanation: SQL> REVOKE c##role1 FROM c##a_admin; REVOKE c##role1 FROM c##a_admin * ERROR at line 1: ORA - 01951: ROLE ‘C##ROLE1’ not granted to ‘C##A_ADMIN’ SQL> REVOKE c##role1 FROM
c##a_admin CONTAINER=ALL; Revoke succeeded. SQL> This CREATE USER c##a_admin IDENTIFIED BY orcl123; will create common user event container is not specified.

NEW QUESTION 13
You create a default Flashback Data Archive FLA1and enable it for the EMPLOYEES table in the HR schema.
After a few days, you want to alter the EMPLOYEES table by executing the command: SQL> ALTER TABLE EMPLOYEES ADD PHONE NUMBER(12);
Which statement is true about the execution of the command?

• A. It gives an error because DDL statements cannot be executed on a table that is enabled for Flashback Data Archive.
• B. It executes successfully and all metadata related to the EMPLOYEES table before altering the table definition is purged from Flashback Data Archive.
• C. It executes successfully and continues to store metadata related to the EMPLOYEES table.
• D. It executes successfully but Flashback Data Archive is disabled for the EMPLOYEES tabl

Answer: C

Explanation: Flashback data archives retain historical data across data definition language (DDL) changes to the database as long as the DDL change does not affect the structure of the table. The one exception to this rule is that flashback data archives do retain historical data when a column is added to the table. https://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_5009.htm

NEW QUESTION 14
Which two statements are true about scheduling operations in a pluggable database (PDB)?

• A. Scheduler jobs for a PDB can be defined only at the container database (CDB) level.
• B. A job defined in a PDB runs only if that PDB is open.
• C. Scheduler attribute setting is performed only at the CDB level.
• D. Scheduler objects created by users can be exported or imported using Data Pump.
• E. Scheduler jobs for a PDB can be created only by common user

Answer: BD

Explanation: In general, all scheduler objects created by the user can be exported/imported into the PDB using data pump. Predefined scheduler objects will not get exported and that means that any changes made to these objects by the user will have to be made once again after the database has been imported into the pluggable database. However, this is how import/export works currently. A job defined in a PDB will run only if a PDB is open.

NEW QUESTION 15
Examine the RMAN commands executed in your database: RMAN>CONFIGURE DEFAULT DEVICE TYPE TO disk;
RMAN>CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO BACKUPSET; RKAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;
You issue the command: RMAN> BACKUP DATABASE;
Which two statements are true about the command?

• A. It performs a log switch.
• B. It creates compressed backup sets by using binary compression by default.
• C. It backs up only the used blocks in data files.
• D. It backs up data files, the control file, and the server parameter file.
• E. It creates a backup of only the control file whenever the database undergoes a structural chang

Answer: CD

Explanation: C: RMAN backup sets automatically use unused block compression. http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta007.htm#i1015382
D: If CONFIGURE CONTROLFILE AUTOBACKUP is ON (by default it is OFF), then RMAN automatically backs up the control file and server parameter file after every backup and after database structural
changes. http://docs.oracle.com/cd/B19306_01/backup.102/b14192/bkup003.htm#i1009642 Not E: spfile is also backed up.

NEW QUESTION 16
Which three requirements must be met before a tablespace can be transported across different platforms?

• A. Both the source and target databases must use the same character set.
• B. The platforms of both the source and target databases must have the same endian format.
• C. The compatible parameter value must be the same in the source and target databases.
• D. The minimum compatibility level for both the source and target databases must be 10.0.0.
• E. The tablespace to be transported must be in read-only mod

Answer: ADE