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

Question #1

Your database is using a default temporary tablespace that contains the temp01.tmp temporary file. All the users on the database use the default temporary tablespace.
A user issues a query on the orders table and receives the following error:
ERROR at line 1:
ORA-01565: error in identifying file
'/u01/app/oracle/oradata/TEST/temp01.tmp'
ORA-27037: unable to obtain file status
What would be the most efficient way to rectify this error?

A. Allow the database to continue running, drop the temp01.tmp temporary file, and then re-create it with new tempfiles.

B. Add a new tempfile to the user's temporary tablespace and drop the tempfile that produced the error.

C. Take the temporary tablespace offline, recover the missing tempfile by applying redo logs, and then bring the temporary tablespace online.

D. Shut down the database instance, restore the temp01.tmp file from the backup, and then restart the database.

Discussion 0

Correct Answer: B Vote an answer

Question #2

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 temp01.dbf file, and then re-create the temp file.

B. Create a new temporary tablespace and assign it as the default to the user.

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. Add a new temp file to the temporary tablespace and drop the temp01.dbf file.

Discussion 0

Correct Answer: B,E Vote an answer

Question #3

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 and archived redo log files that are not required for the recovery are deleted and the repository is updated.

C. All backups that have exceeded the age set by the RMAN retention policy are deleted.

D. 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.

Discussion 0

Correct Answer: D Vote an answer

Question #4

Which three statements are true about compression of backup sets?

A. Unused blocks below the high-water mark are not backed up.

B. Compressed backups cannot have section size defined during a backup operation

C. Binary compression creates performance overhead during a backup operation.

D. Compressed backups can only be written to media.

E. It works only for locally managed tablespaces.

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 #5

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. The select any transaction privilege must be granted to the user.

B. Flashback Data Archive must be created and the flashback archive administer system privilege must be granted to the user.

C. The recycle bin parameter must be set to on.

D. The flashback any table privilege must be granted to the user.

E. Minimal supplemental logging must be enabled.

F. The database must be running in archivelog mode.

Discussion 0

Correct Answer: A,E,F Vote an answer

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

Question #6

You want to migrate your Oracle 11g database as a pluggable database (PDB) in a multitenant container database (CDB).
The following are the possible steps to accomplish this task:
1. Place all the user-defined tablespace in read-only mode on the source database.
2. Upgrade the source database to a 12c version.
3. Create a new PDB in the target container database.
4. Perform a full transportable export on the source database with the VERSION parameter set to 12 using the expdp utility.
5. Copy the associated data files and export the dump file to the desired location in the target database.
6. Invoke the Data Pump import utility on the new PDB database as a user with the DATAPUMP_IMP_FULL_DATABASE role and specify the full transportable import options.
7. Synchronize the PDB on the target container database by using the DBMS_PDS.SYNC_ODB function.
Identify the correct order of the required steps.

A. 2, 1, 3, 4, 5, 6

B. 1, 4, 3, 5, 6, 7

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

D. 1, 5, 6, 4, 3, 2

E. 1, 3, 4, 5, 6, 7

Discussion 0

Correct Answer: B Vote an answer

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

Question #7

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. 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.

C. inpdp will create two users called hr1 and oe1 and import all objects to the new schemas.

D. expdp will succeed but impdp will fail because the users do not exist.

Discussion 0

Correct Answer: D Vote an answer

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

Question #8

You are connected to a pluggable database (PDB) as a common user with the sysdba privilege. The PDB is open and you issue the shutdown immediate command.
What is the outcome?

A. The command results in an error because the PDB can be shut down only by a local user.

B. The command executes only if the common user is granted the set container privilege for the PDB.

C. The PDB is closed and left in the mount state.

D. The PDB is closed and left in the unmount state.

Discussion 0

Correct Answer: C Vote an answer

Question #9

Which Oracle Database component is audited by default if the Unified Auditing option is enabled?

A. Oracle Database Vault

B. Oracle Recovery Manager (RMAN)

C. Oracle Label Security

D. Oracle Data Pump

E. Oracle Real Application Security

Discussion 0

Correct Answer: B Vote an answer

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

Question #10

ENCRYPT_TS an encrypted tablespace that contains tables with data.
Which statement is true about queries and data manipulation language statements on these tables?

A. Redo generated by DML remains encrypted.

B. Queries may be performed on columns that have the NO SALT option.

C. Data remains encrypted when read into the buffer cache.

D. Data remains encrypted when read into the PGA for direct path reads.

E. UNDO generated by DML remains encrypted if the UNDO tablespace is encrypted.

Discussion 0

Correct Answer: A Vote an answer

Question #11

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

A. If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated.

B. If a PDB plan is enabled for a pluggable database, then 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.

C. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups across all PDBs in the CDB.

D. In a PDB plan, subplans may be used with up to eight consumer groups.

E. If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that PDB.

Discussion 0

Correct Answer: B,E Vote an answer

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

Question #12

You have installed two 64G flash devices to support the Database Smart Flash Cache feature on your database server that is running on Oracle Linux.
You have set the db_smart_flash_file parameter:
DB_FLASH_CACHE_FILE= ' /dev/f lash_device_1',' /dev/f lash_device_2'
How should the D3_flash_cache_size be configured to use both devices?

A. Set D3_FLASK_CACKE_SI2E=i28G.

B. Set DB_FLASH_CACHE_SIZE=64G.

C. db_flash_cache_SI2E is automatically configured by the instance at startup.

D. Set D3_FLASH_CACHE_SIZE=64G, 64G.

Discussion 0

Correct Answer: D Vote an answer

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

Question #13

Your database is running in archivelog mode and a nightly backup of the database, along with an autobackup of the control file, is taken by using RMAN. Because of a media failure, the SPFILE and the control files are lost.
Examine the steps to restore the SPFILE and the control file to mount the database:
1. Set DBID of the target database in RMAN.
2. Start the database instance by using the STARTUP FORCE NOMOUNT command in RMAN.
3. Restore the control files from the backup.
4. Mount the database.
5. Restore the SPFILE from the autobackup.
6. Create a PFILE from the recovered SPFILE.
7. Restart the instance in NOMOUNT state.
Identify the required steps in the correct order.

A. 1, 2, 5, 3, 6, 4

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

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

D. 1, 2, 3, 5, 6, 4

Discussion 0

Correct Answer: B Vote an answer

Question #14

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 take the tools01.dbf data file offline before you start a block media recovery.

B. You can perform only a complete media recovery of individual blocks, point-in-time recovery of individual data blocks is not supported.

C. You must put the database in NOARCHIVELOG mode to perform a block media recovery.

D. You must restore a backup control file to perform a block media recovery.

E. You must ensure that the SALES database is mounted or open.

Discussion 0

Correct Answer: B,E Vote an answer

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

Download Free Oracle 1z1-067 Demo