Oracle 1Z0-060 問題集

質問 1：
You are administering a database stored in Automatic Storage Management (ASM). You use RMAN to back up the database and the MD_BACKUP command to back up the ASM metadata regularly. You lost an ASM disk group DG1 due to hardware failure.
In which three ways can you re-create the lost disk group and restore the data? (Choose three.)
A. Use the MD_RESTORE command to restore the disk group with the changed disk group specification, failure group specification, name, and other attributes and use RMAN to restore the data.
B. Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group and data on the disk group.
C. Use the MD_RESTORE command to restore metadata for an existing disk group by passing the existing disk group name as input parameter and use RMAN to restore the data.
D. Use the MD_RESTORE command to restore both the metadata and data for the failed disk group.
E. Use the MKDG command to add a new disk group DG1 with the same or different specifications for failure group and other attributes and use RMAN to restore the data.
正解：A,B,E

質問 2：
You are connected to a pluggable database (PDB) as a common user with DBA privileges.
The STATISTICS_LEVEL parameter is PDB_MODIFIABLE. You execute the following:
SQL > ALTER SYSTEM SET STATISTICS_LEVEL = ALL SID = `*' SCOPE = SPFILE; Which is true about the result of this command?
A. Nothing happens; because there is no SPFILE for each PDB, the statement is ignored.
B. The STATISTICS_LEVEL parameter is set to all whenever the multitenant container database (CDB) is restarted.
C. The STATISTICS_LEVEL parameter is set to ALL whenever any PDB is reopened.
D. The STATISTICS_LEVEL parameter is set to all whenever this PDB is re-opened.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 3：
Examine the following command;
ALTER SYSTEM SET enable_ddl_logging = TRUE;
Which statement is true?
A. Only DDL commands that resulted in the creation of new segments are logged.
B. All DDL commands are logged in the alert log file.
C. All DDL commands are logged in a different log file that contains DDL statements and their execution dates.
D. All DDL commands are logged in XML format in the alert directory under the Automatic Diagnostic Repository (ADR) home.
E. Only the data definition language (DDL) commands that resulted in errors are logged in the alert log file.
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 4：
Which Oracle Database component is audited by default if the unified Auditing option is enabled?
A. Oracle Data Pump
B. Oracle Real Application Security
C. Oracle Label Security
D. Oracle Database Vault
E. Oracle Recovery Manager (RMAN)
正解：E

質問 5：
Examine the following command:

Which three statements are true about using an invisible column in the PRODUCTStable?
A. A primary key constraint can be added on the invisible column.
B. The DESCRIBE commands in SQL *Plus will not display the invisible column in the output.
C. The invisible column cannot be made visible and can only be marked as unused.
D. Referential integrity constraint cannot be set on the invisible column.
E. The %ROWTYPE attribute declarations in PL/SQL to access a row will not display the invisible column in the output.
正解：A,B,E
解説: (Topexam メンバーにのみ表示されます)

質問 6：
A database is stored in an Automatic Storage Management (ASM) disk group, disk group, DGROUP1with SQL:

There is enough free space in the disk group for mirroring to be done.
What happens if the CONTROLLER1failure group becomes unavailable due to error or for maintenance?
A. Mirroring of allocation units will be done to ASM disks in the CONTROLLER2 failure group until the CONTROLLER1 for failure group is brought back online.
B. The data in the CONTROLLER1 failure group is copied to the controller2 failure group and rebalancing is initiated.
C. Transactions accessing database objects contained in any tablespace stored in DGROUP1 will fail but queries will succeed.
D. ASM does not mirror any data until the controller failure group is brought back online, and newly allocated primary allocation units (AU) are stored in the controller2 failure group, without mirroring.
E. Transactions and queries accessing database objects contained in any tablespace stored in DGROUP1 will fall.
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 7：
Which three are true about the large pool for an Oracle database instance that supports shared server connections?
A. Contains a hash area performing hash joins of tables
B. Contains stack space
C. Allocates memory for RMAN backup and restore operations
D. Contains a cursor area for storing runtime information about cursors
E. Allocates memory for shared and private SQL areas
正解：A,C,D
解説: (Topexam メンバーにのみ表示されます)

質問 8：
Examine the types and examples of relationships that follow:
1. One-to-one
a) Teacher to students
2. One-to-many
b) Employees to Manager
3. Many-to-one
c) Person to SSN
4. Many-to-many
d) Customers to products
Which option indicates the correctly matched relationships?
A. 1-c, 2-a, 3-b, and 4-d
B. 1-c, 2-d, 3-a, and 4-b
C. 1-d, 2-b, 3-a, and 4-c
D. 1-a, 2-b, 3-c, and 4-d
正解：A