1z0-067 sample questions

Question 1

Which two statements are true about Flashback Version Query?

Accepted Answer

|t retrieves all versions of rows that exist in a time interval, including the start time and end time.

Accepted Answer

|t can be used to retrieve the SQL that is required to undo a row change and the user responsible for the change.

Answer

|t can be used only if Flashback Data Archive is enabled for a table.

Answer

It can be used to create views.

Answer

The result of a query can be used as part of a DML statement.

Question 2

Which two statements are true regarding SecureFile lobs?

Accepted Answer

Fragmentation is minimized by using variable-sized chunks.

Accepted Answer

They support random reads and writes of encrypted LOB data.

Answer

The amount of undo retained is user controlled.

Answer

They can be used only for nonpartitioned tables.

Question 3

You want to back up a database such that only formatted blocks are backed up. Which statement is true about this backup operation?

Accepted Answer

The backup must be performed in mount state.

Answer

The database must be backed up as an image copy.

Answer

All files must be backed up as backup sets.

Answer

The tablespace must be taken offline.

Question 4

During the day, your database must support an OLTP workload that requires a large database buffer cache. At night, it must support batch jobs that require a higher value to be set for large pool.
What must you do to allow the memory pools to change size automatically as required? (Choose the best answer.)

Accepted Answer

Enable AMM and set the PRE_PAGE_SGA initialization to TRUE.

Answer

Enable Automatic Memory Management (AMM) and set the PGA_TARGET initialization parameter to a nonzero value.

Answer

Enable AMM and set the PGA_TARGET initialization parameter to a nonzero value.

Answer

Enable AMM and set the SGA_TARGET initialization parameter to a nonzero value.

Question 5

Examine the statements that use flashback technologies: 1. FLASHBACK TABLE customers TO TIMESTAMP TO_TIMESTAMP (‘2013-02-04 09:30:00’, ‘YYYY-MM-DD HH:MI:SS’); 2. SELECT * FROM customers AS OF SCN 123456; 3. FLASHBACK TABLE customers TO BEFORE DROP; 4. FLASHBACK DATABASE TO TIMESTAMP TO_TIMESTAMP (‘2013-02-04 09:30:00’, ‘YYYY-MM-DD HH:MI:SS’);
5. SELECT * FROM customers VERSIONS BETWEEN SCN 123456 AND 123999; 6. ALTER TABLE customers FLASHBACK ARCHIVE;

Which set of statements depends on the availability of relevant undo data in the undo tablespace? (Choose the best answer.

Accepted Answer

1,2, 5

Answer

2, 3, 5, 6

Answer

3,4,5

Answer

1,3,6

Question 6

A user issues a query on the sales table and receives the following error:
ERROR at line 1: ORA-01565: error in identifying file 7uOI/app/oracle/oradata/ORCL/temp01.dbf ORA-27037: unable to obtain file status

Which two actions would you take to recover the temporary tablespace?

Accepted Answer

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

Accepted Answer

Add a new temp file to the temporary tablespace and drop the tempOl.dbf file.

Answer

Drop the tempOl .dbf file, and then re-create the temp file.

Answer

Take the temporary tablespace offline, recover the missing temp file, and then bring the temporary tablespace online.

Answer

Shut down the database instance, start up the database instance in mount state, create a new temporary tablespace, and then open the database.

Question 7

Which two statements are true about encrypted backups performed by using RMAN? Choose two.

Accepted Answer

Transparent encryption of backups uses an encryption wallet.

Accepted Answer

A password encryption of backups uses the password while creating and restoring backups.

Answer

A database uses the same encryption key for every encrypted backup.

Answer

Encrypted backups can only be written to disk.

Answer

Image copy backups can be created by using password encryption.

Question 8

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?

Accepted Answer

The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.

Accepted Answer

The valid time columns employee_time_start and employee_time_end are automatically created.

Accepted Answer

The valid time columns are not populated by the Oracle Server automatically.

Answer

The valid time columns are visible by default when the table is described.

Answer

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 queries performed by the session.

Question 9

Which three statements are true regarding the use of the Database Migration Assistant for Unicode (DMU)?

Accepted Answer

A DBA can check specific tables with the DMU

Accepted Answer

The DMU can report columns that are too long in the converted characterset

Accepted Answer

The DMU can report columns that are not represented in the converted characterset

Answer

The release of the database to be converted can be any release since 9.2.0.8.

Answer

The database to be migrated must be opened read-only.

Question 10

You administer a database that was created using Oracle Database 10g.
The default tablespace type property was not changed. You execute this statement to create a tablespace, mytbs: CREATE TABLESPACE mytbs DATAFILE 7u1/data/mytbs.dbf SIZE 100M;

Which two statements are correct regarding the mytbs tablespace? (Choose two.)

Accepted Answer

It is a smallfile tablespace

Accepted Answer

it is a locally managed tablespace with autoallocate

Answer

it is a locally managed tablespace with uniform size of 8m

Answer

It is a dictionary-managed tablespace

Answer

it is a bigfile tablespace

1z0-067 Sample Questions & Answers

Ready for the real thing?

1z0-067 Sample Questions & Answers

Related practice tests

Ready for the real thing?