Breathing 1Z0-067 Exam Questions and Answers 2021

1Z0-067 Dumps

1Z0-067 Exam Questions - Online Test

1Z0-067 Premium VCE File

Learn More 100% Pass Guarantee - Dumps Verified - Instant Download
150 Lectures, 20 Hours

Exam Code: 1Z0-067 (), Exam Name: Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP, Certification Provider: Oracle Certifitcation, Free Today! Guaranteed Training- Pass 1Z0-067 Exam.

Also have 1Z0-067 free dumps questions for you:

NEW QUESTION 1
Which two statements are true about service creation for pluggable databases (PDBs)?

A. When a PDB is created, a service is automatically started in the instance with the same name as the PDB.
B. The default service that is automatically created by a database at the time of PDB creation can be dropped, provided a new additional service is created.
C. A database managed by Oracle Restart can have additional services created or existing services modified by using the srvctl utility for each PDB.
D. Only a common user can create additional services for a PDB.
E. When a PDB is created, a service with the same name as the PDB is created in the PD

Answer: AC

NEW QUESTION 2
Which four tablespace types can be renamed? Choose four.

A. the default permanent tablespace
B. the SYSTEM tablespace
C. a temporary tablespace
D. a read-only tablespace
E. an offline tablespace
F. an undo tablespace

Answer: ACDF

NEW QUESTION 3
Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information Lifecycle Management (ILM)?

A. tracking the most recent read time for a table segment in a user tablespace
B. tracking the most recent write time for a table segment in a user tablespace
C. tracking insert time by row for table rows
D. tracking the most recent write time for each block in a table segment
E. tracking the most recent read time for a table segment in the sysauxtablespace
F. tracking the most recent write time for a table segment in the sysauxtablespace

Answer: ABD

Explanation: Tracking of segment-level reads and writes At the block level, Heat Map tracks only the most recent modification time stamp.

NEW QUESTION 4
You created a tablespace with this statement: CREATE BIGFILE TABLESPACE adtbs
DATAFILE '/proddb/data/adtbs.dbf' SIZE 10G;
The tablespace is nearly full and you need to avoid any out of space errors for the load of a 5 gig table.
Which two alter statements will achieve this?

A. ALTER TA3LESPACE adtbs RESI2E 20G;
B. ALTER TA3LESPACE adtbs ADD DATAFILE;
C. ALTER TABLESPACE adtbs AUTOEXTEND ON;
D. ALTER TA3LESPACE adtbs ADD DATAFILE '/proddb/data/adtbsl.dbf' SIZE 1QG;
E. ALTER TA3LESPACE adtbs MODIFY DATAFILE '/proddb/data/adtbs.dbf AUTOEXTEND ON;

Answer: AC

Explanation: http://www.techonthenet.com/oracle/tablespaces/alter_tablespace.php

NEW QUESTION 5
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 6
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 7
View the SPFILE parameter settings in the Exhibit.
1Z0-067 dumps exhibit
You issue this command and get errors: SQL> startup
ORA-00824:cannotsetSGAJTARGET or MEMORY_TARGET dueto existing internalsettings,seealertlog for moreinformation
Why did the instance fail to start?

A. because pga_aggregate_target is not set
B. because statistics_level is set to basic
C. because memory_target and memory_max_target cannot be equal
D. because sga_target and memory_target are both set

Answer: B

Explanation:
SQL> startup nomount ORA-01078: failure in processing system parameters ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings ORA-00848: STATISTICS_LEVEL cannot be set to BASIC with SGA_TARGET or MEMORY_TARGET SQL>

NEW QUESTION 8
Which three statements correctly describe the relationship amongst jobs, programs, and schedules within the Oracle Job Scheduler?

A. A job is specified as part of a program definition.
B. A program can be used in the definition of multiple jobs.
C. A program and job can be specified as part of a schedule definition.
D. A program and schedule can be specified as part of a job definition.
E. A program and window can be specified as part of a job definitio

Answer: BDE

Explanation: References: http://docs.oracle.com/database/121/ADMIN/schedover.htm#ADMIN13371

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
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 11
You install Oracle Grid Infrastructure for a standalone server and issue this command:
crsctl start has
Which two components get automatically added to the Oracle Restart configuration the first time this command is issued?
Choose two.

A. A database that already exists prior to the Grid Infrastructure installation
B. Oracle Notification services
C. Oracle Healthcheck services
D. An Oracle Net Listener that already exists prior to the Grid Infrastructure installation
E. Oracle CSSD services

Answer: CE

NEW QUESTION 12
Which four actions are possible during an Online Datafile Move operation?

A. Creating and dropping tables in the datafile being moved
B. Performing file shrink of the data file being moved
C. Querying tables in the datafile being moved
D. Performing Block Media Recovery for a data block in the datafile being moved
E. Flashing back the database
F. Executing DML statements on objects stored in the datafile being moved

Answer: ACEF

Explanation: “The good news is that Oracle 12cR1 now offers the ability to move entire datafiles between different storage locations without ever having to take the datafiles offline. The datafiles being moved remain completely accessible to applications in almost all situations, including querying against or performing DML and DDL operations against existing objects, creating new objects, and even rebuilding indexes online. Online Move Datafile (OMD) also makes it possible to migrate a datafile between non-ASM and ASM storage (or vice-versa) while maintaining transparent application access to that datafile’s underlying database objects. OMD is completely compatible with online block media recovery, the automatic extension of a datafile, the modification of a tablespace between READ WRITE and READ ONLY mode, and it even permits backup operations to continue against any datafiles that are being moved via this feature.”
http://muhammad-asif-dba.blogspot.com.br/2013/11/oracle-12c-database-online-movedatafile. html

NEW QUESTION 13
Which two statements are true regarding the Oracle Data Pump export and import operations?

A. You cannot export data from a remote database.
B. You can rename tables during import.
C. You can overwrite existing dump files during export.
D. You can compress data but not metadata during expor

Answer: BC

Explanation: However, in Oracle 11g there is a new parameter, reuse_dumpfiles, which overwrites any created dump file in a specified folder. This parameter accepts two values: Y and N. Default is N. If the parameter was set to Y, then Data Pump overwrites the files that already exist.
Reference: http://www.dba-oracle.com/T_rman_167_expdp_reuse_dumpfiles_parameter.htm

NEW QUESTION 14
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 15
You use RMAN to take regular backups for your database. Examine the RMAN commands:
RMAN> CROSSCHECK BACKUP; RMAN> DELETE EXPIRED BACKUP;
Which statement is true?

A. All metadata pertaining to backups and archived redo log files that have exceeded the age set by the RMAN retention policy are deleted from the repository.
B. All backups that have exceeded the age set by the RMAN retention policy are deleted.
C. All metadata, for backups and archived redo log files that are recorded in the repository but do not exist on disk or media, is deleted.
D. All backups and archived redo log files that are not required for the recovery are deleted and the repository is updated.

Answer: C

NEW QUESTION 16
The environmental variable oracle_Base is set to /u01/app/oracle and oracle_home is set to
/u01/app/oracle/product/12.1.0/db 1.
You want to check the diagnostic files created as part of the Automatic Diagnostic Repository (ADR). Examine the initialization parameters set in your database.
NAME TYPE VALUE
-------------------------------------------- ------------------- ------------------------------------------------
audit_file_deststring/u01/app/oracle/admin/eml2rep/adump
background_dump_deststring
core_dump_deststring
db_create_file_deststring
db_recovery_file_deststring/u01/app/oracle/fast_recovery_area
diagnostic_deststring
What is the location of the ADR base?

A. It is set to/u01/app/oracle/product:/12.1.0/db_1/log.
B. It is set to /u01/app/oracle/admin/en12.1.0/adump.
C. It is set to /u01/app/oracle.
D. It is set to /u01/app/oracle/flash_recovery_are

Answer: C

Explanation: http://docs.oracle.com/cd/B28359_01/server.111/b28310/diag001.htm#ADMIN11008
The Automatic Diagnostic Repository (ADR) is a directory structure that is stored outside of the database. It is therefore available for problem diagnosis when the database is down.
The ADR root directory is known as ADR base. Its location is set by the DIAGNOSTIC_DEST initialization parameter. If this parameter is omitted or left null, the database sets DIAGNOSTIC_DEST upon startup as follows:
If environment variable ORACLE_BASE is set, DIAGNOSTIC_DEST is set to the directory designated by ORACLE_BASE.
If environment variable ORACLE_BASE is not set, DIAGNOSTIC_DEST is set to ORACLE_HOME/log.

NEW QUESTION 17
Automatic Undo Management is enabled for your database. You want a user to retrieve metadata and historical data for a given transaction or for transactions in a given time interval.
Which three are prerequisites to fulfill this requirement?

A. Minimal supplemental logging must be enabled.
B. The database must be running in archivelog mode.
C. Flashback Data Archive must be created and the flashback archive administer system privilege must be granted to the user.
D. The flashback any table privilege must be granted to the user.
E. The select any transaction privilege must be granted to the user.
F. The recycle bin parameter must be set to o

Answer: ABE

Explanation: To configure your database for the Flashback Transaction feature, you or your database administrator must: With the database mounted but not open, enable ARCHIVELOG: ALTER DATABASE
ARCHIVELOG; Open at least one archive log: ALTER SYSTEM ARCHIVE LOG CURRENT; If not done, enable minimal and primary key supplemental logging: ALTER DATABASE ADD SUPPLEMENTAL LOG DATA; ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS; Granting
Necessary Privileges For Oracle Flashback Transaction Query Grant the SELECT ANY TRANSACTION privilege. For Oracle Flashback Query and Oracle Flashback Version Query To allow access to specific objects during queries, grant FLASHBACK and SELECT privileges on those objects. To allow queries on all tables, grant the FLASHBACK ANY TABLE privilege. http://docs.oracle.com/cd/E11882_01/appdev.112/e41502/adfns_flashback.htm#ADFNS612

P.S. Surepassexam now are offering 100% pass ensure 1Z0-067 dumps! All 1Z0-067 exam questions have been updated with correct answers: https://www.surepassexam.com/1Z0-067-exam-dumps.html (231 New Questions)