Online 1Z0-083 Practice Test

Question 1

Which three can be done using Oracle Database Configuration Assistant (DBCA) starting from Oracle Database 19c? (Choose three.)

Options :

A : cloning a remote container database in interactive mode

B : cloning a remote pluggable database in silent mode

C : relocating a remote pluggable database in interactive mode

D : relocating a remote container database in silent mode

E : cloning a remote container database in silent mode

F : relocating a remote pluggable database in silent mode

G : relocating a remote container database in interactive mode.

Answer: A,B

Question 2

Choose three. In which three situations can you use threshold server-generated alerts to help diagnose and fix problems?

Options :

A : when free space in a dictionary managed tablespace falls below a specified percentage

B : when free space in a locally managed tablespace falls below a specified percentage

C : when the total number of locked user account exceeds a specific value

D : when the number of logons per second exceeds a specific value

E : when a resumable statement is suspended

F : when the total number of logons exceeds a specific value

Answer: B,C,D

Question 3

Which two are true about Oracle Optimizer Statistics, their use, and their collection? (Choose two.)

Options :

A : The number of table rows is considered when evaluating the cost of accessing a table using an index.

B : Index balanced B*Tree height is considered when evaluating the cost of using an index.

C : The Statistics Advisor can help recommend the best way to gather statistics.

D : Statistics collected using DBMS_STATS always yield the best optimizer result.

E : The Statistics Advisor generates actions for all recommendations.

Answer: B,C

Question 4

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

Options :

A : Transparent encryption of backups uses an encryption wallet.

B : Image copy backups can be created by using password encryption.

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

D : Encrypted backups can only be written to disk.

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

Answer: A,C

Question 5

choose two You take your database backups by using the RMAN media management interface (MMI). Which two are true about the use of the RMAN MMI?

Options :

A : Integration with Third-Party Media Managers

B : Use of SBT (Sun Business Talk) Interface

C : Channel Allocation

D : Requires Configuration

E : Vendor-Specific Modules

Answer: A,D

EXPERTY DESIGNED 1Z0-083 PRACTICE TEST