Oracle 1Z0-083 問題集

質問 1：
Which two are true about an RPM-based Oracle Database installation? (Choose two.)
A. It performs a software-only Oracle Database installation.
B. From Oracle Database 18c, a single RPM can be used to install only Oracle Database Server for a single instance.
C. It includes the Oracle Preinstallation RPM.
D. It requires an Unbreakable Linux Network (ULN) subscription.
E. It uses a service configuration script to create a single-instance database as part of the installation.
正解：A,E
解説: (Topexam メンバーにのみ表示されます)

質問 2：
Which two are true about the Optimizer Statistics Advisor?
A. It can recommend changes to improve the statistics gathering process.
B. It always analyzes all schemas in the database.
C. It can be run only manually.
D. It runs automatically every night by default. E) It can be run only automatically.
正解：A,D

質問 3：
Which two statements are true about Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)?
A. In a PDB plan, subplans may be used with up to eight consumer groups.
B. If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated.
C. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.
D. If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that PDB.
E. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups across all PDBs in the CDB.
正解：C,D

質問 4：
Which three are true about Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) in an Oracle multitenant environment? (Choose three.)
A. No AWR data is stored in the CDB$ROOT SYSAUX tablespace.
B. ADDM can run in a nonroot container.
C. All AWR data is stored in the CDB$ROOT SYSAUX tablespace.
D. AWR snapshots can be created in CDB$ROOT.
E. AWR snapshots can be created in a PDB.
F. AWR reports can be generated while connected to any container.
正解：B,D,E
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Which two are true in Oracle 19c and later releases?
A. Unified Auditing can be configured to audit only events that are issued indirectly by all users
B. Schema Only accounts can be granted administrator privileges.
C. Unified Auditing can be configured to audit only events that are issued directly by an audited user.
D. All the Oracle-supplied accounts are Schema Only accounts.
E. If the password file location changes, then the instance must be restarted.
正解：B,C

質問 6：
In one of your databases, unified auditing is enabled and an SH.SALES table exists. You successfully execute these commands:
SQL> CREATE AUDIT POLICY sales_pol ACTIONS select on sh.sales;
SQL> AUDIT POLICY sales_pol;
Which statement is true about SALES_POL?
A. It is enabled for all users having SELECT privilege on SH.SALES.
B. Audit records are always stored in an external audit file.
C. Only successful queries of SH.SALES are written to the audit trail.
D. It is only enabled for user SH.
正解：A