Oracle 1z0-067 Faq 2021

Proper study guides for Most recent Oracle Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP certified begins with Oracle 1z0-067 preparation products which designed to deliver the Guaranteed 1z0-067 questions by making you pass the 1z0-067 test at your first time. Try the free 1z0-067 demo right now.

NEW QUESTION 1
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 2
The CATDB12C database contains an Oracle Database 12c catalog schema owned by the rci2c user. The CATD3H database contains an Oracle Database Ug catalog schema owned by the rch user.
A database with dbid=H2324I is registered in the catdbII catalog. Both the recovery catalog databases are open.
In the CATD3i2c database, you execute the commands:
: r-ar.
RKAN> CONNECT CATALOG rci2c/passI2c@catdbi2c
RKAN> IMPORT CATALOG rcii/pwdcatUQcatdfoil DBI2=142324i; What is the outcome of the import?

A. It fails because the target database and recovery catalog database are of different versions.
B. It succeeds and all global scripts in the RC11 catalog that have the same name as existing global scripts in the RCI2C catalog are automatically renamed.
C. It succeeds but the database is not automatically registered in the rc:2c catalog.
D. It fails because RMAN is not connected to the target database with r3:T=:42324:.

Answer: B

NEW QUESTION 3
In which three scenarios is media recovery required?

A. when a tablespace is accidentally dropped from a database
B. when archived redo log files are lost
C. when data files are lost
D. when one of the online redo log members is corrupted
E. when all control files are lost

Answer: ADE

Explanation:
References: 2021-04-01T22:02:00.75
2021-04-01T22:02:00.76
2021-04-01T22:02:00.79
2021-04-01T22:02:00.79
2021-04-01T22:02:00.79
http://docs.oracle.com/cd/A87860_01/doc/server.817/a76993/recoscen.htm

NEW QUESTION 4
Which three statements are true about persistent lightweight jobs?

A. A user cannot set privileges on them.
B. They generate large amounts of metadata.
C. They may be created as fully self-contained jobs.
D. They must reference an existing Scheduler Program.
E. The are useful when users need to create a large number of jobs quickl

Answer: ADE

Explanation:
Unlike regular jobs, they are not schema objects. Because lightweight jobs are not schema objects, you cannot grant privileges on them. A lightweight job inherits privileges from its specified program. Thus, any user who has a certain set of privileges on the program has corresponding privileges on the lightweight job. Use lightweight jobs when you have many short-duration jobs that run frequently. Under certain circumstances, using lightweight jobs can deliver a small performance gain. A lightweight job must reference a program object (program) to specify a job action. The program must be already enabled when the lightweight job is created, and the program type must be either ‘PLSQL_BLOCK’ or ‘STORED_PROCEDURE’.
http://docs.oracle.com/database/121/ADMIN/schedover.htm#ADMIN12668

NEW QUESTION 5
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 6
You set the following parameters in the parameter file and restart the database instance: MEMORY_MAX_TARGET=0
MEMORY TARGET=500M PGA_AGGREGATE_TARGET=90M SGA_TARGET=270M
Which two statements are true?

A. The memory_max_target parameter is automatically set to 500 MB.
B. The pga_aggregate_target and sga_target parameters are automatically set to zero.
C. The value of the memory_max_target parameter remains zero for the database instance.
D. The lower limits of the pga_aggregate_target and sga_target parameters are set to 90 MB and 270 MB respectively.
E. The instance does not start up because Automatic Memory Management (AMM) is enabled but pga_aggregate_target and sga_target parameters are set to nonzero values.

Answer: AD

NEW QUESTION 7
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 8
Which two statements are true about a multitenant architecture?

A. Each pluggable database (PDB) has its own initialization parameter file.
B. A PDB can have a private undo tablespace.
C. Log switches occur only at the container database level.
D. A PDB can have a private temporary tablespace.
E. Each PDB has a private control fil

Answer: CD

Explanation:
You are only able to switch the archived logs when you connect to the root of a CDB, but you cannot switch archived redo logs when connected to a PDB. You can able to create a PDB without temporary tablespace but not able to make it use the temporary tablespace of CDB.

NEW QUESTION 9
You restore and recover your database to a new host by using an existing RMAN open database backup.
Which step must you perform next?

A. Execute catproc.sqi to recompile invalid PL/SQL modules.
B. Open the database with the resetlogs option.
C. Set a new database identifier (DBID) for the newly restored database.
D. Use the RMAN set newname and switch commands to switch to new file

Answer: B

NEW QUESTION 10
Which three methods can be used to create a pluggable database (PDB) in an existing multitenant container database (CDB)? (Choose three.)

A. Use Enterprise Manager Database Express to create a PDB in an existing CDB.
B. Use the DBMS_PDB package to plug a non-CDB into an existing CDB.
C. Use PDB$SEED for creating a PDB.
D. To clone an existing PDB.
E. Use the DBMS_PDB package to plug a pre-Oracle 12c database into an existing CD

Answer: BCD

NEW QUESTION 11
Examine the initialization parameter that is set in the PFILE: DB_CREATE_FILE_DEST ='/u01/app/oracle/oradata/'
You execute the following command to create theCDB1. container database (CDB): SQL>CREATE DATABASE CDB1
DEFAULT TABLESPACE users
DEFAULT TEMPORARY TABLESPACE temp
UNDO TABLESPACE undotbsl
ENABLE PLUGGABLE DATABASE SEED
SYSTEM DATAFILES SIZE125M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED SYS AUX DATAFILES SIZE 100M;
Which three statements are true?

A. It creates a multitenant container database with a root and a seed pluggable database (PDB) that are opened in read-write and read-only modes, respectively.
B. The files created for both the root and seed databases use Oracle Managed Files (OMF).
C. It creates a multitenant container database with the root and seed databases opened and one PDB mounted.
D. It sets the users tablespace as the default for both the root and seed databases.
E. undotbs1 is used as the undo tablespace for both the root and seed databases.
F. It creates a multitenant container database with the root database opened and the seed database mounted.

Answer: ABE

Explanation:
The seed actually doesn’t use anything since it’s read-only, but any PDB created from the seed will use the undotbs1 undo tablespace. Each PDB can have its own default tablespace, but cannot change the undo tablespace.

NEW QUESTION 12
Which three statements are true about Oracle Secure Backup (OSB)?

A. It can encrypt client data written to tape.
B. It can be used to take image copy backups to tape.
C. It can be used to manage tape backup and restore operations for multiple databases.
D. It can be used along with an RMAN recovery catalog for maintaining records of backups in a tape library.
E. It can be used to perform file system backups at the file, directory, file system, or raw partition level.

Answer: ACE

Explanation:
File system backups may be performed at the file, directory, file system or raw partition level with full, incremental and offsite backup scheduling. As backup needs grow requiring more tape drives and centralized backup management of multiple servers, Oracle Secure Backup XE can be easily upgraded to the Oracle Secure Backup edition. http://www.oracle.com/technetwork/products/secure-backup/learnmore/osb-xe-10-130649.pdf

NEW QUESTION 13
Examine the RMAN command:
RMAN> BACKUP VALIDATE DATABASE;
Which statement is true about the execution of the command?

A. Block change tracking must be enabled before executing this command.
B. The database must be running in archivelog mode for the successful execution of this command.
C. A complete database backup must exist before executing this command.
D. The command checks for blocks containing all zeros, an invalid checksum, or a corrupt block header.
E. The command checks for blocks that contain a valid checksum and matching headers and footers, but that has logically inconsistent contents.

Answer: D

NEW QUESTION 14
Examine these parameter settings: SGA_TARGET = 700M SGA_MAX_SIZE = 1024M DB_8K_CACHE_SIZE = 124M LOG_BUFFER = 200M
You attempt this:
SQL> ALTER SYSTEM SER DB_8K_CACHE_SIZE=140M
Which statement is true based on the information available?

A. It will fail because DB_8K_CACHE_SIZE cannot be changed dynamically.
B. It succeeds only if memory is available from the autotuned components of the SGA.
C. It will fail because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGET.
D. It will fail because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE.

Answer: B

NEW QUESTION 15
You execute the commands to configure settings in RMAN: RMAN> CONFIGURE DEVICE TYPE sbt PARALLELISM 1; RMAN> CONFIGURE DEFAULT DEVICE TYPE TO sbt;
RMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE sbt TO 2; RMAN> CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE sbt TO 2; RMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DRVICE TYPE DISK TO 2;
Then you issue the following command to take a backup: RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Which statement is true about the execution of these commands? Choose the best answer.

A. It backs up the data files and archived logs to media, making two copies of each data file and archived logs.
B. It backs up two copies each of the data files to disk and media, and two copies of archived logs to media.
C. The backup terminates because the backup destination for disk is not specified in the BACKUP command.
D. It backs up the data files and archived logs, making one copy of each data file and archived log on disk and media.

Answer: B

NEW QUESTION 16
Which parameter must be set to which value to implement automatic PGA memory management?

A. Set memory_target to zero.
B. Set STATISTICS_LEVEL to BASIC.
C. Set pga_aggregate_target to a nonzero value.
D. Set pga_aggregate_target and sga_target to the same value.
E. Set sgajtarget to zer

Answer: C

Explanation:
When automatic memory management is not enabled, the default method for the instance PGA is automatic PGA memory management http://docs.oracle.com/cd/B28359_01/server.111/b28318/memory.htm

NEW QUESTION 17
Which three statements are true about the startup and shutdown of multitenant container databases (CDBs) and pluggable databases (PDBs)?

A. A PDB opened in restricted mode allows only local users to connect.
B. When a CDB is open in restricted mode, PDBs must also be opened in restricted mode.
C. When a CDB is in mount state, PDBs are automatically placed in mount state.
D. All PDBs must be shut down before shutting down a CDB instance.
E. When a CDB instance is started, PDBs can be placed in open state by using database triggers or by executing the alter pluggable database command.

Answer: BCE

Explanation:
Reference: https://oracle-base.com/articles/12c/multitenant-startup-and-shutdown-cdb-and-pdb- 12cr1

NEW QUESTION 18
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 19
In your multitenant container database (CDB) that contains pluggable databases (PDBs), the hr user executes the following commands to create and grant privileges on a procedure:
CREATEORREPLACEPROCEDUREcreate_test_v(v_emp_idNUMBER,v_enameVARCHAR2,v_SALARYNU MBER,v_dept_idNUMBER)
BEGIN
INSERT INTO hr.test VALUES (v_emp_id, v_ename, v salary, v_dept_id); END;
/
GRANT EXECUTE ON CREATE_TEST TO John, jim, smith, king;
How can you prevent users having the execute privilege on the create_test_v procedure from inserting values into tables on which they do not have any privileges?

A. Create the create_test procedure with definer's rights.
B. Grant the execute privilege to users with grant option on the create_test procedure.
C. Create the create_test procedure with invoker's rights.
D. Create the create_test procedure as part of a package and grant users the execute privilege on the package.

Answer: C

Explanation:
You can control access to privileges that are necessary to run user-created procedures by using definer’s rights, which execute with the privileges of the owner, or with invoker’s rights, which execute with the privileges of the user running the procedure.

NEW QUESTION 20
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 21
Which two statements are true about the Automatic Diagnostic Repository (ADR)?

A. The ADR base is shared across multiple instances.
B. The ADR base keeps all diagnostic information in binary format.
C. The ADR can be used to store statspack snapshots to diagnose database performance issues.
D. The ADR can be used for problem diagnosis even when the database instance is down.
E. The ADR is used to store Automatic Workload Repository (AWR) snapshot

Answer: AD

NEW QUESTION 22
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 23
Which two statements are true regarding Oracle Data Pump?

A. EXPDP and IMPDP are the client components of Oracle Data Pump.
B. DBMS_DATAPUMP PL/SQL packages can be used independently of the Data Pump clients.
C. Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege.
D. Oracle Data Pump imports can be done from the export files generated in the Original Export Utility.
E. EXPDP and IMPDP use the procedures provided by DBMS_METADATA to execute export and import commands.

Answer: AB

Explanation:
References: http://docs.oracle.com/cd/B19306_01/server.102/b14215/dp_overview.htm

NEW QUESTION 24
Examine the resources consumed by a database instance whose current Resource Manager plan is displayed. SQL> SELECT name, active_sessions, queue_length,
consumed_cpu_time, cpu_waits, cpu_wait_time FROM v$rsrc_consumer_group;
1Z0-067 dumps exhibit
Which two statements are true?

A. An attempt to start a new session by a user belonging to DSS_QUERIES fails with an error.
B. An attempt to start a new session by a user belonging to OTHE_GROUPS fails with an error.
C. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to resource management.
D. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to I/O waits and latch or enqueue contention.
E. A user belonging to the DSS QUERIES resource consumer group can create a new session but the session will be queued.

Answer: CE

NEW QUESTION 25
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 26
......

Thanks for reading the newest 1z0-067 exam dumps! We recommend you to try the PREMIUM Certshared 1z0-067 dumps in VCE and PDF here: https://www.certshared.com/exam/1z0-067/ (263 Q&As Dumps)