1z0-067 Oracle Exam Questions and Free Practice Test

Question 7

Which two statements are true regarding an Automatic Storage Management (ASM) instance? (Choose two.)

A. An ASM instance mounts an ASM control file

B. An ASM instance uses the ASMB process for rebalancing of disks within a disk group

C. Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameters not set explicitly

D. An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started

Correct Answer:CD

Question 8

Examine the RMAN command:
RMAN> BACKUP VALIDATE DATABASE;
Which statement is true about the execution of the command?

A. Block change tracking must be enabled before executing this command.

B. The database must be running in archivelog mode for the successful execution of this command.

C. A complete database backup must exist before executing this command.

D. The command checks for blocks containing all zeros, an invalid checksum, or a corrupt block header.

E. The command checks for blocks that contain a valid checksum and matching headers and footers, but that has logically inconsistent contents.

Correct Answer:D

Question 9

A complete database backup to media is taken for your database every day. Which three actions would you take to improve backup performance?

A. Set the backup_tape_io_slaves parameter to true.

B. Set the dbwr_io_slaves parameter to a nonzero value if synchronous I/O is in use.

C. Configure large pool if not already done.

D. Remove the rate parameter, if specified, in the allocate channel command.

E. Always use RMAN compression for tape backups rather than the compression provided by media manager.

F. Always use synchronous I/O for the databas

Correct Answer:BCD
Tuning RMAN Backup Performance: Procedure Many factors can affect backup performance. Often, finding the solution to a slow backup is a process of trial and error. To get the best performance for a backup, follow the suggested steps in this section: Step 1: Remove RATE Parameters from Configured
and Allocated Channels Step 2: If You Use Synchronous Disk I/O, Set DBWR_IO_SLAVES Step 3: If You Fail to Allocate Shared Memory, Set LARGE_POOL_SIZE Step 4: Tune RMAN Tape Streaming Performance Bottlenecks Step 5: Query V$ Views to Identify Bottlenecks https://docs.oracle.com/database/121/BRADV/rcmtunin.htm#BRADV172

Question 10

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

Correct Answer:B
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

Question 11

Which two are prerequisites for creating a backup-based duplicate database?

A. connecting to the target database and a recovery catalog to execute the duplicate command

B. creating a password file for an auxiliary instance

C. connecting to an auxiliary instance

D. matching the database identifier (DBID) of the source database and the duplicate database

E. creating an SPFILE for the target database

Correct Answer:BC
References:
http://docs.oracle.com/cd/E11882_01/backup.112/e10643/rcmsynta020.htm#CHDEDFFH

Question 12

Which statements describe the capabilities of the DBMS_NETWORK_ACL_ADMIN package? (Choose all that apply.)

A. It can be used to allow the access privilege settings for users but not roles.

B. It can be used to allow the access privilege settings for users as well as roles.

C. It can be used to control the time interval for which the access privilege is available to a user.

D. It can be used to selectively restrict the access for each user in a database to different hostcomputers.

E. It can be used to selectively restrict a user's access to different applications in a specific host computer.

Correct Answer:BCD

START 1z0-067 EXAM