Oracle 1z0-062 問題集

質問 1：
You execute the commands:

Which two statements are true? (Choose two.)
A. The user Sidney is created but cannot connect to the database instance because no profile is default.
B. The user Sidney is created and authenticated by the operating system.
C. The user Sidney can connect to the database instance but requires relevant privileges to create objects in the users tablespace.
D. The user Sidney can connect to the database instance but cannot perform sort operations because no space quota is specified for the temp tablespace.
E. The create user command fails if any role with the name Sidney exists in the database.
正解：C,E

質問 2：
Examine the resources consumed by a database instance whose current Resource Manager plan is displayed.

Which two statements are true? (Choose two.)
A. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to resource management.
B. An attempt to start a new session by a user belonging to DSS_QUERIES fails with an error.
C. A user belonging to the DSS__QUERIES resource consumer group can create a new session but the session will be queued.
D. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to I/O waits and latch or enqueue contention.
E. An attempt to start a new session by a user belonging to OTHER_GROUPS fails with an error.
正解：A,C

質問 3：
Which three statements are true concerning the multitenant architecture? (Choose three.)
A. Different PDBs can have different default block sizes.
B. Instance recovery is always performed at the CDB level.
C. A PDB can have a private temp tablespace.
D. Log switches occur only at the multitenant container database (CDB) level.
E. Each pluggable database (PDB) has its own set of background processes.
F. PDBs can share the sysaux tablespace.
G. PDBs share a common system tablespace.
正解：B,C,D
解説: (Topexam メンバーにのみ表示されます)

質問 4：
A redaction policy was added to the SAL column of the SCOTT.EMP table:

All users have their default set of system privileges.
For which three situations will data not be redacted? (Choose three.)
A. SCOTT sessions, only if the MGR role is set in the session
B. SYSTEM session, only if the MGR role is set in the session
C. SYS sessions, regardless of the roles that are set in the session
D. SYSTEM sessions, regardless of the roles that are set in the session
E. SCOTT sessions, because he is the owner of the table
F. SCOTT sessions, only if the MGR role is granted to SCOTT
正解：C,D,F

質問 5：
Which three resources might be prioritized between competing pluggable databases when creating a multitenant container database plan (CDB plan) using Oracle Database Resource Manager? (Choose three.)
A. CPU
B. Local file system I/O
C. Parallel server limit
D. Maximum Idle time
E. Exadata I/O
F. Maximum Undo per consumer group
正解：A,C,E