Oracle 1Z0-083 問題集

質問 1：
After implementing full Oracle Data Redaction, you change the default value for the number data type as follows:
SQL> SELECT NUMBER_VALUE FROM REDACTION_VALUES_FOR_TYPE_FULL;
NUMBER_VALUE
-------------------------
SQL> EXEC DBMS_REDACT.UPDATE_FULL_REDACTI0N_VALUES(-1)
PL/SQL procedure successfully completed.
SQL> select number_value from redaction_values_for_type_full;
NUMBER VALUE
------------------------
After changing the value, you notice that FULL redaction continues to redact numeric data with a zero.
What must you do to activate the new default value for numeric full redaction?
A. Flush the shared pool.
B. Re-connect the sessions that access objects with redaction policies defined on them.
C. Restart the database instance.
D. Re-create redaction policies that use FULL data redaction.
E. Re-enable redaction policies that use FULL data redaction.
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 2：
Which three are true about thresholds, metrics, and server-generated alerts? (Choose three.)
A. A space usage management alert is automatically cleared after the underlying problem is resolved.
B. Metrics are statistical counts for a specific unit.
C. Cleared stateful alerts are displayed by querying DBA_ALERT_HISTORY.
D. They are generated by SMON when a tablespace is 97% full.
E. All metrics are instance related.
F. STATISTICS_LEVEL must be set to ALL to generate alerts.
正解：A,B,C
解説: (Topexam メンバーにのみ表示されます)

質問 3：
Which three are located by using environment variables? (Choose three.)
A. the temporary disk space used by Oracle Installer during installation
B. default directories for temporary files used by temporary tablespaces
C. the list of a disk group names to be mounted by an Oracle Automatic Storage Management (ASM) instance at startup
D. the maximum number of database files that can be opened by a database instance
E. the location of Oracle Net Services configuration files
F. the Optimal Flexible Architecture (OFA) compliant path to store Oracle software and configuration files.
正解：A,E,F
解説: (Topexam メンバーにのみ表示されます)

質問 4：
Which operating system group is NOT needed to perform an Oracle Database installation?
A. OSKMDBA
B. OSASM
C. OSOPER
D. OSDBA
E. OSRACDBA
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Which two are true about memory advisors? (Choose two.)
A. All memory advisors use data from Automatic Workload Repository.
B. If Automatic Memory Management is enabled, the Shared Pool Advisor and Buffer Cache Advisor are available to set the maximum size for these individual System Global Area components.
C. If Automatic Memory Management is enabled, no memory advisors are available.
D. If Manual Shared Memory Management is enabled, only the Shared Pool Advisor and Buffer Cache Advisor are available.
E. If Automatic Shared Memory Management is enabled, both the SGA Advisor and PGA Advisor are always available.
正解：A,E
解説: (Topexam メンバーにのみ表示されます)

質問 6：
Which three are true about managing memory components in an Oracle database instance?
(Choose three.)
A. Automatically tuned and resized System Global Area components will always revert to their initial sizes after an instance restart.
B. With Automatic Memory Management, the database instance can increase the System Global Area size by reducing the Program Global Area size.
C. On Line Transaction Processing systems often use less Program Global Area than Decision Support Systems.
D. Automatic Memory Management must be used together with locking the System Global Area into physical memory.
E. With Automatic Shared Memory Management, the database instance can increase the Large Pool size by reducing the Shared Pool size.
F. With Automatic Shared Memory Management, the database instance can increase the Program Global Area size by reducing the System Global Area size.
正解：B,C,E
解説: (Topexam メンバーにのみ表示されます)