Oracle 1Z0-067 Free Practice Questions 2021

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

• A. The backup as copy can only be taken to disk
• B. The backup as copy can only be taken to tape
• C. Backup can be performed only when the instance is shutdown
• D. Backup will constitute all used and unused blocks in the database

Answer: AD

NEW QUESTION 2
You are administering a database that supports a data warehousing workload and is running in noarchivelog mode. You use RMAN to perform a level 0 backup on Sundays and level 1 incremental backups on all the other days of the week.
One of the data files is corrupted and the current online redo log file is lost because of a media failure.
Which action must you take for recovery?

• A. Restore the data file, recover it by using the recover datafilenoredo command, and use the resetlogs option to open the database.
• B. Restore the control file and all the data files, recover them by using the recover database noredo command, and use the resetlogs option to open the database.
• C. Restore all the data files, recover them by using the recover database command, and open the database.
• D. Restore all the data files, recover them by using the recover database noredo command, and use the resetlogs option to open the database.

Answer: B

Explanation: https://docs.oracle.com/database/121/RCMRF/rcmsynta2001.htm#RCMRF140 See Example 3-6
Recovering a NOARCHIVELOG Database STARTUP FORCE NOMOUNT; RESTORE CONTROLFILE; #
restore control file from consistent backup ALTER DATAB ASE MOUNT; RESTORE DATABASE; # restore data files from consistent backup RECOVER DATABASE NOREDO; # specify NOREDO because online redo logs are lost ALTER DATABASE OPEN RESETLOGS;

NEW QUESTION 3
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 4
You issue the RMAN command:
RMAN> BACKUP SECTION SIZE 300M TABLESPACE users;
Which statement is true about the execution of the command? Choose the best answer.

• A. The backup succeeds only if the USERS tablespace is locally managed.
• B. RMAN uses multiplexing to perform the backup.
• C. The resulting backupset has backup pieces that cannot exceed 300 MB.
• D. RMAN always performs this type of backup in parallel.
• E. The backup set size is limited to 300 M

Answer: C

NEW QUESTION 5
A user issues a query on the sales table and receives the following error: ERROR at line 1:
ORA-01565: error in identifying file '/u0l/app/oracle/oradata/ORCL/temp01.dbf' ORA-27037: unable to obtain file status
Which two actions would you take to recover the temporary tablespace?

• A. Drop the tenp01.dbf file, and then re-create the temp file.
• B. Add a new temp file to the temporary tablespace and drop the temp01.dbf file.
• C. Shut down the database instance, start up the database instance in mount state, create a new temporary tablespace, and then open the database.
• D. Take the temporary tablespace offline, recover the missing temp file, and then bring the temporary tablespace online.
• E. Create a new temporary tablespace and assign it as the default to the use

Answer: BE

NEW QUESTION 6
You want the execution of large database operations to suspend, and then resume, in the event of space allocation failures.
You set the value of the initialization parameter resumable_timeout to 3600. Which two statements are true?

• A. A resumable statement can be suspended and resumed only once during execution.
• B. Data Manipulation Language (DML) operations are resumable, provided that they are not embedded in a PL/SQL block.
• C. A suspended statement will report an error if no corrective action has taken place during a timeout period.
• D. Before a statement executes in resumable mode, the alter session enable resumable statement must be issued in its session.
• E. Suspending a statement automatically results in suspending a transaction and releasing all the resources held by the transaction.

Answer: CD

NEW QUESTION 7
Your database is running in archivelog mode and regular nightly backups are taken. Due to a media failure, the current online redo log group, which has one member, is lost and the instance is aborted. Examine the steps to recover the online redo log group and move it to a new location.
1. Restore the corrupted redo log group.
2. Restore the database from the most recent database backup. 3.Perform an incomplete recovery.
4.Relocate the member of the damaged online redo log group to a new location. 5.Open the database with the resetlogs option.
6. Issue a checkpoint and clear the log. Identify the required steps in the correct order.

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

Answer: C

Explanation: If the group is Current Then it is the log that the database is currently writing to And you should Attempt to clear the log; if impossible, then you must restore a backup and perform incomplete recovery up to the most recent available redo log.
Reference: http://docs.oracle.com/cd/B19306_01/backup.102/b14191/recoscen.htm#i1006437

NEW QUESTION 8
Examine the backup requirement for your company:
1) Every Sunday, a backup of all used data file blocks is performed.
2) Every Wednesday and Friday, a backup of all the changed blocks since last Sunday's backup is performed.
3) On all the other days, a backup of only the changed blocks since the last day's backup is performed.
Which backup strategy satisfies the requirements?

• A. level 0 backup on Sunday, cumulative incremental backup on Wednesday and Friday, and differential incremental level 1 backup on all the other days
• B. level 0 backup on Sunday, differential incremental backup on Wednesday and Friday, and cumulative incremental level 1 backup on all the other days
• C. full database backup on Sunday, level 0 backup on Wednesday and Friday, and cumulative incremental level 1 backup on all the other days
• D. full database backup on Sunday, level 0 backup on Wednesday and Friday, and differential incremental level 1 backup on all the other days

Answer: A

Explanation: Multilevel Incremental Backups RMAN can create multilevel incremental backups. Each incremental level is denoted by a value of 0 or 1. A level 0 incremental backup, which is the base for subsequent incremental backups, copies all blocks containing dat
A. You can create a level 0 database backup as
backup sets or image copies. The only difference between a level 0 incremental backup and a full backup is that a full backup is never included in an incremental strategy. Thus, an incremental level 0 backup is a full backup that happens to be the parent of incremental backups whose level is greater than 0. A level 1 incremental backup can be either of the following types: A differential incremental backup, which backs up all blocks changed after the most recent incremental backup at level 1 or 0. A cumulative incremental backup, which backs up all blocks changed after the most recent incremental backup at level 0. Incremental backups are differential by default.

NEW QUESTION 9
In your database, there are tablespaces that were read-only when the last backup was taken. These tablespaces have not been made read/write since then. You want to perform an incomplete recovery on the database by using a backup control file.
What precaution must you take for the read-only tablespaces before performing an incomplete recovery?

• A. All the read-only tablespaces should be taken offline.
• B. All the read-only tablespaces should be restored separately.
• C. All the read-only tablespaces should be renamed to have the MISSINGnnnn format.
• D. All the read-only tablespaces should be made online with logging disable

Answer: A

Explanation: Take data files from read-only tablespaces offline before doing recovery with a backup control file, and then bring the files online at the end of media recovery. http://docs.oracle.com/cd/E11882_01/backup.112/e10642/osadvsce.htm#BRADV227

NEW QUESTION 10
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 11
Which three statements are true about compression of backup sets?

• A. Compressed backups can only be written to media.
• B. Binary compression creates performance overhead during a backup operation.
• C. Unused blocks below the high-water mark are not backed up.
• D. Compressed backups cannot have section size defined during a backup operation
• E. It works only for locally managed tablespace

Answer: BCE

Explanation:
https://docs.oracle.com/cd/B19306_01/backup.102/b14194/rcmsynta009.htm#i1015382 “RMAN also skips other datafile blocks that do not currently contain data, if all of the following
conditions apply: The COMPATIBLE initialization parameter is set to 10.2 There are currently no guaranteed restore points defined for the database The datafile is locally managed The datafile is being backed up to a backup set as part of a full backup or a level 0 incremental backup The backup set is being created on disk.

NEW QUESTION 12
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 13
Evaluate these statements: CREATE TABLE purchase_orders (po_idNUMBER(4), po_dateTIMESTAMP, supplier_idNUM8ER(6),
po_totalNUMBER(8,2), CONSTRAINT order_pk PRIMARY KEY(po_id)) PARTITIONBYRANGE(po_date)
(PARTITIONQ1 VALUESLESSTHAN (TO_DATE('01-apr-2007','dd-mon-yyyy')), PARTITIONQ2VALUESLESSTHAN(TO_DATE('01-jul-2007','dd-mon-yyyy')), PARTITIONQ3VALUESLESSTHAN (TO~DATE('01-oct-2007','dd-non-yyyy')), PARTITIONQ4VALUESLESSTHAN (TO_DATE('Ol-jan-2008','dd-non-yyyy' )));
CREATETABLEpurchase_order_items (po_idNUM3ER(4)NOTNULL,
product_idNUMBER(6)NOTNULL, unit_prlceNUMBER(8,2),
quantity NUMBER(8), CONSTRAINTpo_items_f k
FOREIGNKEY(po_id)REFERENCESpurchase_orders(po_id)) PARTITIONBYREFERENCE(po_items_fk);
Which two statements are true?

• A. Partitions of purchase_order_items are assigned unique names based on a sequence.
• B. The purchase_orders and purchase_order_items tables are created with four partitioneach.
• C. purchase_order_items table partitions exist in the same tablespaces as the purchase_orders table partitions.
• D. The purckase_order_:teks table inherits the partitioning key by duplicating the key columns from the parent table.
• E. Partition maintenance operations on the purchase_order_items table require disabling the foreign key constraint.

Answer: BC

Explanation: The following example creates a parent table orders which is range-partitioned on order_date. The reference-partitioned child table order_items is created with four partitions, Q1_2005, Q2_2005, Q3_2005, and Q4_2005, where each partition contains the order_items rows corresponding to orders in the respective parent partition. Partitions of a reference-partitioned table will collocate with the corresponding partition of the parent table, if no explicit tablespace is specified for the reference-partitioned table’s partition. The partitions of a reference-partitioned table can be named. If a partition is not explicitly named, then it will inherit its name from the corresponding partition in
the parent table. http://docs.oracle.com/cd/B28359_01/server.111/b32024/part_admin.htm#BAJDDEEC

NEW QUESTION 14
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 15
What can be automatically implemented after the SQL Tuning Advisor is run as part of the Automated Maintenance Task?

• A. statistics recommendations
• B. SQL profile recommendations
• C. SQL statement restructure recommendations
• D. creation of materialized views to improve query performance

Answer: B

Explanation: Once automatic SQL tuning begins, which by default runs for at most one hour during a maintenance window, the following steps are performed: ... During the tuning process, all recommendation types are considered and reported, but only SQL profiles can be implemented automatically.
References: https://docs.oracle.com/cd/B28359_01/server.111/b28274/sql_tune.htm#CHDJDFGE

NEW QUESTION 16
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 17
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 18
You perform an RMAN block media recovery on the tools 01.dbf data file in the SALES database. Which two statements are true? (Choose two.)

• A. You must ensure that the SALES database is mounted or open.
• B. You must restore a backup control file to perform a block media recovery.
• C. You must take the tools01.dbf data file offline before you start a block media recovery.
• D. You must put the database in NOARCHIVELOG mode to perform a block media recovery.
• E. You can perform only a complete media recovery of individual blocks, point-in-time recovery of individual data blocks is not supported.

Answer: AE