1Z0-083問題集、Oracle実際の試験問題

質問 1

Which three actions are mandatory post database upgrade?

A. Upgrading user tables that depend on Oracle-maintained abstract data types.

B. Setting threshold values for tablespace alerts.

C. Migration to unified auditing.

D. Resetting passwords to enforce case-sensitivity.

E. Run OPatch commands from the new Oracle home.

F. Updating client scripts with the new Oracle home.

正解: A,E,F

質問 2

Unified auditing is enabled in your database. The HR_ADMIN and OE_ADMIN roles exist and are granted system privileges. You execute the command:
SQL>CREATE AUDIT POLICY table_aud PRIVILEGES CREATE ANY TABLE, DROP ANY TABLE ROLES hr_admin,oe_admin; Which statement is true?

A. It fails because the command does notspecify when the unified audit policy should be enforced.

B. It fails because system privileges cannot be granted with roles in the same audit policy.

C. It succeeds and starts capturing only successful SQL statements for all users who have either the specified privileges or roles granted to them.

D. It succeeds and needs to be enabled to capture all SQL statements that require either the specified privileges or any privilege granted to the HR_ADMIN or OE_ADMIN role.

正解: D

質問 3

Which three are true about corrupted data blocks and their recovery in an Oracle Database?

A. If a row lock is held by a nonexistent transaction, the block containing the row is media corrupt.

B. If a row lock is held by a nonexistent transaction, the block containing the row is logically corrupt.

C. A media corrupt block is one where the block is not formatted correctly.

D. DB_LOST_WRITE_PROTECT=TYPICAL causes extra logging overhead on the standby database.

E. The ANALYZE TABLE VALIDATE STRUCTURE CASCADE command verifies that each table row has an index entry pointing to it.

F. DB_BLOCK_CHECKING=TRUE causes a check sum to be added to each data block to help detect physical or media corruption.

正解: B,D,E

質問 4

A redaction policy was added to the SALcolumn of the SCOTT.EMPtable:

All users have their default set of system privileges.
For which three situations will data not be redacted? (Choose three.)

A. SYS sessions, regardless of the roles that are set in the session

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

C. SYSTEM sessions, regardless of the roles that are set in the session

D. SCOTT sessions, because he is the owner of the table

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

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

正解: A,B,C

質問 5

Which two are true about the Optimizer Statistics Advisor?

A. It can recommend changes to improve the statistics gathering process.

B. It runs automatically every night by default. E) It can be run only automatically.

C. It can be run only manually.

D. It always analyzes all schemas in the database.

正解: A,B

質問 6

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

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

B. All Oracle recovery files in the current fast recovery area (FRA) are backed up.

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

D. These backups can be written to disk or SBT.

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

正解: C,E

解説: (PassTest メンバーにのみ表示されます)

質問 7

Which three statements are true about the keystore storage framework for transparent data encryption?

A. It enables a keystore to be stored only in a file on a file system.

B. It transparently decrypts data for the database users and applications that access this data.

C. It facilitates and helps to enforce keystore backup requirements.

D. It handles encrypted data without modifying applications.

E. It helps to track encryption keys and implement requirements such as keystore password rotation and master encryption key reset or re-key operations.

F. It enables separation of duties between the database administrator and the security administrator.

正解: C,E,F

質問 8

In a recent Automatic Workload Repository (AWR) report for your database, you notice a high number of buffer busy waits. The database consists of locally managed tablespaces with free list managed segments. On further investigation, you f ind that buffer busy waits is caused by contention on data blocks.
Which option would you consider first to decrease the wait event immediately?

A. Increasing db_buffer_cache based on t he V$DB_CACHE_ADVICE recommendation

B. Increasing the number of DBWN process

C. Using Automatic Segment Space Management (ASSM)

D. Decreasing PCTUSED

E. Decreasing PCTFREE

正解: C

Oracle Database Administration II - 1Z0-083 模擬練習