Weekend Sale Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: bigdisc65

Oracle Database 19c 1z0-083 Syllabus Exam Questions Answers

Page: 9 / 21
Question 36

Choose the best answer You want to create a duplicate database DUP_DB from your production database PROD on the same host. The PROD database uses Automatic Storage Management (ASM) for storage. Regular backups are taken using RMAN connected to a recovery catalog. You create an auxiliary instance and want to execute the command: RMAN> DUPLICATE TARGET DATABASE TO dup_db FROM ACTIVE DATABASE; What is a prerequisite for the successful execution of this command

Options:

A.

RMAN must be connected to the target database instance and the auxiliary instance.

B.

A most recent backup set of the PROD database must exist.

C.

Flashback must be enabled for the PROD database.

D.

The target database must be in MOUNT state.

Question 37

Choose two. Which two are true about backup set compression using RMAN default compression?

Options:

A.

Compressed backups cannot have a section size defined.

B.

Compressed backups can be written only to media.

C.

Binary compression adds CPU overhead to backup operations.

D.

Unused blocks below the high water mark are backed up.

E.

Compression can be done only for locally managed tablespaces.

Question 38

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

Question 39

Choose three. Which three are true in Oracle 19c and later releases?

Options:

A.

Tablespaces always remain in read/write mode during transportable tablespace operations.

B.

Tablespaces never remain in read/write mode during transportable tablespace operations.

C.

A transportable data pump import can leave a plugged-in tablespace in read-only mode.

D.

Simultaneous data pump jobs can be limited at the pluggable database (PDB) level.

E.

A transportable data pump import can leave a plugged-in tablespace in read/write mode.

F.

An ordinary data pump export of a table with encrypted columns will always encrypt the same columns when imported.

Page: 9 / 21
Exam Code: 1z0-083
Exam Name: Oracle Database Administration II
Last Update: May 11, 2024
Questions: 286
1z0-083 pdf

1z0-083 PDF

$28  $80
1z0-083 Engine

1z0-083 Testing Engine

$33.25  $95
1z0-083 PDF + Engine

1z0-083 PDF + Testing Engine

$45.5  $130