1z0-067 Oracle Exam Questions and Free Practice Test

Question 31

Which three requirements must be met before a tablespace can be transported across different platforms?

A. Both the source and target databases must use the same character set.

B. The platforms of both the source and target databases must have the same endian format.

C. The compatible parameter value must be the same in the source and target databases.

D. The minimum compatibility level for both the source and target databases must be 10.0.0.

E. The tablespace to be transported must be in read-only mod

Correct Answer:ADE

Question 32

Examine the following set of RMAN commands:
RMAN> CONFIGURE CHANNEL dc1 DEVICE TYPE DISK FORMAT ' /u02/backup/%U' ; RMAN> RUN
{
ALLOCATE CHANNEL ch1 DEVICE TYPE DISK;
EXECUTE SCRIPT arc_backup;
}
Which statement is true about the RMAN RUN block execution?

A. The script is executed and both DC1 and CH1 channels are used for script execution.

B. The execution of the script fails because multiple channels cannot exist simultaneously.

C. The persistent configuration parameter, DC1, is overridden because a new channel is allocated in the RMAN RUN block.

D. The new channel, CH1, is ignored because a channel has been configured alread

Correct Answer:C

Question 33

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

Correct Answer:ACDF

Question 34

You have a production Oracle 12c database running on a host.
You want to install and create databases across multiple new machines that do not have any Oracle database software installed. You also want the new databases to have the same directory structure and components as your existing 12c database.
The steps in random order:
1. Create directory structures similar to the production database on all new machines.
2. Create a response file for Oracle Universal Installer (OUI) with the same configurations as the production database.
3. Create a database clone template for the database.
4. Run the Database Configuration Assistant (DBCA) to create the database. 5.Run OUI in graphical mode on each machine.
6.Run OUI in silent mode using the OUI response file.
Identify the required steps in the correct sequence to achieve the requirement with minimal human intervention.

A. 2, 1, 6, and 4

B. 2, 3, and 6

C. 3, 1, 5, and 6

D. 2, 3, 1, and 6

E. 1, 5, and 4

Correct Answer:D

Question 35

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

Correct Answer:AD

Question 36

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

A. The backup must be performed in mount state.

B. The tablespace must be taken offline.

C. All files must be backed up as backup sets.

D. The database must be backed up as an image cop

Correct Answer:A
If you run multiple AUDIT statements on the same unified audit policy but specify different EXCEPT users, then Oracle Database uses the last exception user list, not any of the users from the preceding lists. This means the effect of the earlier AUDIT POLICY ... EXCEPT statements are overridden by the latest AUDIT POLICY ... EXCEPT statement https://docs.oracle.com/database/121/DBSEG/audit_config.htm#DBSEG459

START 1z0-067 EXAM