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

Oracle 1z0-182 - Oracle Database 23ai Administration Associate

Oracle 1z0-182 Premium Access     Download Demo    
Page: 3 / 3
Total 94 questions

Which two statements are true about the configuration and use of UNDO?

A.

Active UNDO is always retained.

B.

Unexpired UNDO is always retained.

C.

UNDO_RETENTION specifies for how long Oracle attempts to keep expired and unconsumed UNDO.

D.

UNDO_RETENTION specifies how long all types of UNDO are retained.

E.

UNDO_RETENTION specifies for how long Oracle attempts to keep unexpired UNDO.

You want to apply the principle of Least Privilege in all your live databases. One of your requirements is to revoke unnecessary privileges from all users who have them using Privilege Analysis. Which three types of analyses can be done using the DBMS_PRIVILEGE_CAPTURE package?

A.

Analysis of privileges that a user has on their own schema objects that they did not use.

B.

Analysis of all privileges used by all users including administrative users in the database.

C.

Analysis of all privileges used by all users but excluding administrative users in the database.

D.

Analysis of privileges granted directly to a role that are then used by a user who has been granted that role.

E.

Analysis of privileges granted indirectly to a role that are then used by a user who has beengranted that role.

F.

Analysis of privileges that a user has on their own schema objects that they did use.

Which two statements describe why Database Auditing is a security requirement?

A.

To monitor suspicious activity.

B.

To alert DBAs about system issues.

C.

To protect against data theft by a non-authorized user.

D.

To protect against data corruption.

E.

To monitor proper usage of the system and data by privileged users.

Which two tasks can be performed in the NOMOUNT state?

A.

Renaming data files.

B.

Enabling online redo log archiving.

C.

Creating a database.

D.

Re-creating control files.

E.

Full database recovery.

Which three statements are true about the Oracle Database server during and immediately after SHUTDOWN TRANSACTIONAL?

A.

Instance recovery occurs automatically during the shutdown.

B.

Uncommitted transactions are allowed to continue to the next ROLLBACK.

C.

New connection requests made to the database instance are refused.

D.

Sessions remain connected even if they are not running a transaction.

E.

Uncommitted transactions are allowed to continue to the next COMMIT.

You have connected to the CDB root as a common user with the CREATE PLUGGABLE DATABASE system privilege and issued the following command: SQL> CREATE PLUGGABLE DATABASE pdb1 ADMIN USER admin1 IDENTIFIED BY p1 ROLES = (CONNECT) FILE_NAME_CONVERT = ('PDB$SEEDdir', 'PDB1dir'); Which three are results of the CREATE command?

A.

It creates new default schemas for the PDB.

B.

It creates tablespaces to store metadata.

C.

It creates a new local user ADMIN with SYSDBA privileges.

D.

The PDB must be opened Read Only to complete the integration of the PDB into the CDB.

E.

After the PDB is created, it is automatically opened Read/Write.

F.

It creates a new local user ADMIN with restricted privileges.

Which three actions are ways to apply the principle of least privilege?

A.

Enabling Unified Auditing.

B.

Revoking execute privilege on UTL_SMTP, UTL_TCP, UTL_HTTP, and UTL_FILE from the roles/users (assuming typo for duplicate option).

C.

Using Access Control Lists (ACLs).

D.

Setting the O7_DICTIONARY_ACCESSIBILITY parameter to TRUE.

E.

Setting the REMOTE_OS_AUTHENT parameter to TRUE.

Which two statements are true concerning logical and physical database structures?

A.

A segment can span multiple data files in some tablespaces.

B.

Segments can span multiple tablespaces.

C.

A segment might have only one extent.

D.

All tablespaces may have one or more data files.

E.

A segment’s blocks can be of different sizes.