Oracle 1z0-067 問題集

質問 1：
You want to reduce fragmentation and reclaim unused space for the sales table but not its dependent objects.
During this operation, you want to ensure the following:
i.Long-running queries are not affected.
ii.No extra space is used.
iii.Data manipulation language (DML) operations on the table succeed at all times throughout the process.
iv.Unused space is reclaimed both above and below the high water mark.
Which alter TABLE option would you recommend?
A. DEALLOCATE UNUSED
B. SHRINK SPACE COMPACT
C. ROW STORE COMPRESS BASIC
D. SHRINK SPACE CASCADE
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 2：
In your database, the user SCOTT wants to retrieve the dropped HR.EMPLOYEES table by using the command:
SQL> FLASHBACK TABLE HR.EMPLOYEES TO BEFORE DROP;
What are three prerequisites for this command to succeed? (Choose three.)
A. No other table with the same name should exist in the HR schema.
B. No duplicates of the HR.EMPLOYEES table should exist in the recyclebin of the HR schema.
C. The recycle bin should be enabled.
D. Undo retention guarantee must be enabled.
E. SCOTT should have the FLASHBACK ANY TABLE privilege.
F. SCOTT should have the SELECT privilege on the HR schema and its recyclebin.
正解：C,E,F

質問 3：
You create a table with the period for clause to enable the use of the Temporal Validity feature of Oracle Database 12c.
Examine the table definition:
create table employees
(empno number, salary number,
deptid number, name varchar2(100),
period for employee_time);
Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table?
A. The valid time columns are not populated by the Oracle Server automatically.
B. The valid time columns are visible by default when the table is described.
C. The valid time columns employee_time_start and employee_time_end are automatically created.
D. Setting the session valid time using DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for data manipulation language (DML), data definition language (DDL), and queries performed by the session.
E. The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.
正解：A,C,E

質問 4：
Your database is running in archivelog mode. Examine the initialization parameters you plan to set for your database instance.
LOG_ARCHIVE_DEST_1 = 'LOCATION=/disk1/arch'
LOG_ARCHIVE_DEST_2 = 'L0CATI0N=/disk2/arch'
LOG_ARCHIVE_DEST_3 = 'LOCATION=/disk3/arch'
L0G_ARCHIVE_DEST_4 = 'L0CATI0N=/disk4/arch MANDATORY'
Identify the statement that correctly describes these settings.
A. An online redo log file is not allowed to be overwritten if the archived log file cannot be created in any of the log_archive_dest_.n destinations.
B. These settings work only if log__archive_min_succeed_dest is set to a value of 4.
C. Optional destinations cannot use the fast recovery area.
D. An online redo log file is not allowed to be overwritten if the archived log file cannot be created in the location specified for log_archive_dest_4.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Which two statements are true about Flashback Version Query?
A. It can be used only if Flashback Data Archive is enabled for a table.
B. It retrieves all versions of rows that exist in a time interval, including the start time and end time.
C. It can be used to create views.
D. The result of a query can be used as part of a DML statement.
E. It can be used to retrieve the SQL that is required to undo a row change and the user responsible for the change.
正解：B,E

質問 6：
Which two statements are true about roles in multitenant container databases (CDBs)?
A. The root container can have both local and common roles.
B. A common user can create a local role by default in any pluggable database (PDB) that is plugged in to a CDB.
C. A common role can be granted only to a common user.
D. Local roles can be granted to local and common users.
E. A local role can be assigned to a common role in a PDB.
F. A common role can be granted only system privileges.
正解：E,F

質問 7：
Which three statements are true about Oracle Restart?
A. While starting any components, it automatically attempts to start all dependencies first and in proper order.
B. It runs periodic check operations to monitor the health of Oracle components.
C. It can be used to only start Oracle components.
D. It can be configured to automatically restart a database in case of normal shutdown of the database instance.
E. It can be configured to automatically attempt to restart various components after a hardware or software failure.
正解：A,B,E
解説: (Topexam メンバーにのみ表示されます)