Oracle 1Z0-182 問題集

質問 1：
You want to view the initialization parameter settings for only a specific PDB. Which of the following statements is true?
A. From the PDB, execute SELECT NAME, VALUE, ISPDB_MODIFIABLE FROM v$parameter;
B. From the CDB root, execute SELECT NAME, VALUE, ISPDB_MODIFIABLE FROM v$parameter;
C. From the PDB, execute SELECT db_uniq_name, pdb_uid, name, value$ FROM pdb_spfile$;
D. From the CDB root, execute SELECT db_uniq_name, pdb_uid, name, value$ FROM pdb_spfiles;
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 2：
Which three statements are true about roles?
A. All roles granted to a user are set on default when the user logs in.
B. The SET ROLE statement can enable one or more roles for a session.
C. Roles must be password protected.
D. The SET ROLE statement can disable one or more roles for a session.
E. Object privileges may not be granted to roles.
F. Roles may be granted to other roles.
正解：B,D,F
解説: (Topexam メンバーにのみ表示されます)

質問 3：
Which two statements describe how Optimizer Statistics are collected?
A. Optimizer Statistics are collected automatically by an automatic maintenance job that runsduring predefined maintenance windows.
B. Optimizer Statistics are collected by the Statistics Advisor.
C. Optimizer Statistics are collected in real-time as data is inserted, deleted, or updated.
D. Optimizer Statistics are collected automatically by Automatic Workload Repository (AWR) Snapshot.
E. Optimizer Statistics can be manually collected at multiple levels using DBMS_STATS.GATHER_*_STATS PL/SQL procedures.
正解：A,E
解説: (Topexam メンバーにのみ表示されます)

質問 4：
What memory structure caches the data dictionary providing access to all database user processes?
A. The Java Pool
B. The Streams Pool
C. The Large Pool
D. The Shared Pool
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Which two account management capabilities can be configured using Oracle profiles?
A. The maximum amount of CPU time allowed for a user's sessions before their account is locked.
B. The maximum number of sessions permitted for a user before the password must be changed.
C. The number of days for which an account may be logged in to one or more sessions before it is locked.
D. The number of days for which an account may be inactive before it is locked.
E. The ability to prevent a password from ever being reused.
正解：D,E
解説: (Topexam メンバーにのみ表示されます)