CertsTopics Logo

Labour Day Special - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: top65certs

Oracle Database 19c 1z0-083 Updated Exam

Page: 11 / 21
Total 286 questions
Get 1z0-083 Full Access Download 1z0-083 PDF

Oracle Database Administration II Questions and Answers

Question 41

You issued this command: RMAN> BACKUP RECOVERY FILES; Which two are true? (Choose two.)

Options:

A.

All Oracle recovery files not in the current FRA that have not been backed up already, are backed up.

B.

All non-Oracle files in the current FRA that have not been backed up already, are backed up.

C.

All Oracle recovery files in the current FRA that have not been backed up already, are backed up. D)All Oracle recovery files in the current fast recovery area (FRA) are backed up.

D.

These backups can be written to disk or SBT.

Question 42

A redaction policy was added to the SAL column of the SCOTT.EMP table: BEGIN DBMS_REDACT.ADD_POLICY( object_schema object_name column_name policy_name function_type expression => 'SCOTT', => 'EMP', => 'SAL', => 'SCOTT_EMP', => DBMS_REDACT.FULL, => 'SYS_CONTEXT(''SYS_SESSION_ROLES'',''MGR'') END; All users have their default set of system privileges. For which three situations will data not be redacted?

Options:

A.

SYSsessions,regardlessoftherolesthataresetinthesession

B.

SYSTEMsessions,regardlessoftherolesthataresetinthesession

C.

SCOTT sessions, only if the MGR role is set in the session

D.

SCOTT sessions, only if the MGR role is granted to SCOTT

E.

SCOTTsessions,becauseheistheownerofthetable

F.

SYSTEM session, only if the MGR role is set in the session

Question 43

Which two are true about Oracle Flashback features? (Choose two.)

Options:

A.

FLASHBACK QUERY can retrieve REDO records from ONLINE and ARCHIVE D REDO LOG files.

B.

FLASHBACK VERSION QUERY can retrieve REDO records from ONLINE and ARCHIVE D REDO LOG files.

C.

FLASHBACK TABLE can undrop a column.

D.

FLASHBACK DROP can undrop an index when undropping a table.

E.

After a database is restored from flashback logs using the FLASHBACK DATABASE command, it is sometimes rolled forward using redo logs.

Question 44

For which two requirements can you use the USER_TABLESPACE clause with the CREATE PLUGGABLE DATABASE command? (Choose two.)

Options:

A.

to specify a default tablespace in a PDB cloned from another PDB in the same CDB

B.

to exclude all tablespaces except SYSTEM, SYSAUX, and TEMP when plugging in a PDB

C.

to include specific user tablespaces only when relocating a PDB

D.

to specify the list of user tablespaces to include when moving a non-CDB to a PDB

E.

to exclude a temp tablespace when plugging in a PDB

F.

to specify the list of tablespaces to include when creating a PDB from the CDB seed

Page: 11 / 21
Total 286 questions
Get 1z0-083 Full Access Download 1z0-083 PDF