Summer Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: ecus65

Oracle 1z0-083 - Oracle Database Administration II

Oracle 1z0-083 Premium Access     Download Demo    
Page: 3 / 9
Total 286 questions

Which two are true about the execution of operating system scripts starting from Oracle Database 19c? (Choose two.)

A.

orainstRoot.sh can be executed automatically by the Database installer by using sudo or root credentials.

B.

root.sh can be executed automatically by the Database Installer only if it is provided with root credentials.

C.

The sudo password can be specified in a response file.

D.

root.sh can be executed automatically by the Database installer only by using sudo credentials.

E.

The sudo password must be specified in a response file.

F.

The root password cannot be specified in a response file.

Choose three. Which three are true about recovery operations done without using Recovery Manager (RMAN)?

A.

A lost PFILE can be re-created from alert.log using SQL*PLUS.

B.

A lost index tablespace can be re-created without performing any recovery.

C.

A lost password file can be manually re-created with the orapwd utility.

D.

A lost password file can be re-created with SQL*PLUS.

E.

A lost SPFILE can be recovered from memory using SQL*PLUS.

F.

A lost TEMPFILE must always be re-created manually.

You execute the following piece of code with appropriate privileges: BEGIN DBMS_REDACT.ADD_POLICY ( END; 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'') = ''FALSE'''); END; BEGIN DBMS_REDACT.ADD_POLICY ( object_schema object_name column_name policy_name function_type expression => 'SCOTT', => 'EMP_VW', => 'SAL', => 'SCOTT_EMP_VW', => DBMS_REDACT.NONE, => 'SYS_CONTEXT (''SYS_SESSION_ROLES'',''MGR'') = ''FALSE'''); User SCOTT has been granted the CREATE SESSION privilege and the MGR role. Which two statements are true when a session logged in as SCOTT queries the SAL column in the view and the table?

A.

DataisredactedfortheEMP.SALcolumnonlyiftheSCOTTsessiondoesnothavetheMGR role set.

B.

DataisredactedforEMP.SALcolumnonlyiftheSCOTTsessionhastheMGRroleset.

C.

Data is never redacted for the EMP_VW.SAL column.

D.

Data is redacted for the EMP_V.SAL column only if the SCOTT session has the MGR role set.

E.

Data is redacted for the EMP_V.SAL column only if the SCOTT session does not have the MGR role set. Correct

Which two are true about RMAN duplexed backup sets? (Choose two.)

A.

A duplexed backup set uses the same number of SBT channels as a non-duplexed backup set for the same number of files.

B.

A non-duplexed backup set written to disk can be duplexed to disk by backing up the backup set that is already on disk.

C.

A non-duplexed backup set written to SBT can be duplexed to tape by backing up the backup set that is already on tape.

D.

A non-duplexed backup set written to disk can be duplexed to tape by backing up the backup set that is already on disk.

E.

A non-duplexed backup set written to SBT can be duplexed to disk by backing up the backup set that is already on tape.

F.

A duplexed backup set always uses twice as many SBT channels as a non-duplexed backup set for the same number of files.

Which two are true about server-generated alerts? (Choose two.)

A.

Stateful alerts must be created by a DBA after resolving the problem.

B.

Stateless alerts can be purged manually from the alert history.

C.

Stateless alerts can be cleared manually.

D.

Stateless alerts are automatically cleared.

E.

Stateful alerts are purged automatically from the alert history

Choose two. When backing up to the Oracle Fast Recovery Area (FRA), you determine that the backup takes too long and suspect a performance bottleneck. Which two are true about diagnosing and tuning these problems?

A.

Data files with a high value in V$BACKUP_ASYNC_IO.SHORT_WAITS are a potential performance bottleneck when asynchronous I/O is used.

B.

If an RMAN BACKUP VALIDATE command takesroughly the same time as an actual backup, then read I/O is a likely bottleneck.F

C.

If an RMAN BACKUP VALIDATE command takes noticeably less time than an actual backup, then write I/O is a likely bottleneck.

D.

If an RMAN BACKUP VALIDATE command takesroughly the same time as an actual backup, then both read and write I/O are likely bottlenecks.

E.

Data files with a high value in V$BACKUP_SYNC_IO.DISCRETE_BYTES_PER_SECOND are a potential performance bottleneck when synchronous I/O is used.

Choose three. Which three are true about actions that can or cannot be performed by users with the SYSBACKUP privilege?

A.

They can view data from any data dictionary view or dynamic performance view.

B.

They can drop any tablespace.

C.

They can view data from any user-defined tables.

D.

They can create any table.

E.

They cannot create restore points.

F.

They cannot drop tablespaces.

Choose the best answer. Application PDBs, SALES_APP1 and SALES_APP2, must be created and they must access common tables of the SALES_APP application. Examine these steps: 1. Install the SALES_APP application, including the common tables, in the application root. 2. Install the SALES_APP application in the application root and the common tables in both the CDB root and the application root. 3. Create an application seed.; 4. Install the SALES_APP application in the application seed. 5. Create the SALES_APP1 and SALES_APP2 application PDBs. 6. Sync root. 7. Sync seed. 8. Sync the SALES_APP1 and SALES_APP2 application PDBs with the application the SALES_APP1 and SALES_APP2 application PDBs with the application the application seed with the application root.

Which are the minimum required steps in the correct sequence?

A.

1,3,5,7

B.

3,4,1,6,8

C.

1,3,5,6,7

D.

1,5,6

E.

2,5,6

Which three are true about opatch auto? (Choose three.)

A.

It performs a shutdown and then a restart of all processes in both Oracle Grid Infrastructure and Oracle Database home during the patching process.

B.

It must be invoked by a user with root user privileges.

C.

Patches are applied via opatchauto.

D.

Users must always input patch plans to opatchauto.

E.

It requires the Oracle Grid Infrastructure and Oracle Database instances to be shut down before being invoked.

F.

It applies patches in nonrolling mode by default.

G.

It is used to apply interim patches to Oracle Grid Infrastructure and Oracle Database home combinations.

Choose four. Which four are true about performing Tablespace Point-In-Time Recovery (TSPITR) using Recovery Manager (RMAN)?

A.

It can be performed using an auxiliary instance managed by RMAN.

B.

It can be performed using an auxiliary instance managed by a DBA.

C.

It can be used to recover a truncated table.

D.

It can be performed repeatedly until the correct time is found without using an RMAN catalog. E)RMAN always includes tablespaces containing UNDO segments in the recovery set.

E.

RMAN automatically adds any required tablespaces to the recovery set to make it selfcontained. G) FLASHBACK DATABASE must be enabled for it to work. H) It can be used to recover a dropped

tablespace.