1z1-067 무료 덤프문제 온라인 액세스

You want the execution of large database operations to suspend, and then resume, in the event of space allocation failures.
You set the value of the initialization parameter resumable_timeout to 3600.
Which two statements are true?

• A.Data Manipulation Language (DML) operations are resumable, provided that they are not embedded in a PL/SQL block.
• B.A suspended statement will report an error if no corrective action has taken place during a timeout period.
• C.Suspending a statement automatically results in suspending a transaction and releasing all the resources held by the transaction.
• D.A resumable statement can be suspended and resumed only once during execution.
• E.Before a statement executes in resumable mode, the alter session enable resumable statement must be issued in its session.

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 employee_time_start and employee_time_end are automatically created.
• B.The valid time columns are visible by default when the table is described.
• C.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.
• D.The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.
• E.The valid time columns are not populated by the Oracle Server automatically.

Which two statements are true when row-archival management is enabled?

• A.The ORA_ARCHIVE_STATE column is updated automatically by the database based on activity tracking columns, to indicate that a row is no longer considered active.
• B.The ORA_ARCHIVE_STATE column is visible if it is referenced in the select list of a query.
• C.The ORA_ARCHIVE_STATE column is updated manually or by a program that can reference activity tracking columns, to indicate that a row is no longer considered active.
• D.The row archival visibility session parameter defaults to all rows.
• E.Visibility of the ORA_ARCHIVE_STATE column is controlled by the row archival visibility session parameter.

Before a Flashback Table operation, you execute the following command:
ALTER TABLE employees ENABLE ROW MOVEMENT;
Why would you need this to be executed?

• A.Because row IDs may change during the flashback operation
• B.Because the table is moved forward and back to a temporary during the flashback operation
• C.Because the object number changes after the flashback operation
• D.Because the rows are retrieved from the recycle bin during the flashback operation

You set the following parameters in the parameter file and restart the database instance:
MEMORY_MAX_TARGET=0
MEMORY__TARGET=500M
PGA_AGGREGATE_TARGET=90M
SGA_TARGET=270M
Which two statements are true?

• A.The memory_max_target parameter is automatically set to 500 MB.
• B.The pga_aggregate_target and sga_target parameters are automatically set to zero.
• C.The value of the memory_max_target parameter remains zero for the database instance.
• D.The lower limits of the pga_aggregate_target and sga_target parameters are set to 90 MB and 270 MB respectively.
• E.The instance does not start up because Automatic Memory Management (AMM) is enabled but pga_aggregate_target and sga_target parameters are set to nonzero values.