最新的Oracle9i dba new features for Oracle7.3 and Oracle9 ocps - 1Z0-035免費考試真題
To assist you in migrating your existing LONG columns to LOB data types, the ALTER TABLE syntax has been enhanced to support LONG to CLOB migration and LONG RAW to BLOB migration.
During this migration, if redo logging is enabled for the table or for the LOB being created, the ALTER TABLE ?MODIFY command temporarily _____ the space requirements.
During this migration, if redo logging is enabled for the table or for the LOB being created, the ALTER TABLE ?MODIFY command temporarily _____ the space requirements.
正確答案: D
Consider this RMAN command:
RMAN> CONFIGURE RETENTION POLICY CLEAR;
What is the effect of this command?
RMAN> CONFIGURE RETENTION POLICY CLEAR;
What is the effect of this command?
正確答案: D
User defined events in Oracle Enterprise Manager return status, and possibly values, to the Oracle Enterprise Manager Event Monitor. What are user defined events?
正確答案: C
Which two options are valid for LOBs during their creation? (Choose two.)
正確答案: A,C
Which four are true regarding the Workspace Manager in Oracle9i? (Choose four.)
正確答案: B,C,D,E
Examine this fragment from a SQL*Plus session:
SQL> SELECT name, value FROM v$sysstat 2> WHERE name LIKE 'work area executions%';
NAME VALUE
work area executions - optimal 1544 work area executions - onepass 11 work area executions - multipass 1038
What can you conclude about the setting of the PGA_AGGREGATE_TARGET initialization parameter?
SQL> SELECT name, value FROM v$sysstat 2> WHERE name LIKE 'work area executions%';
NAME VALUE
work area executions - optimal 1544 work area executions - onepass 11 work area executions - multipass 1038
What can you conclude about the setting of the PGA_AGGREGATE_TARGET initialization parameter?
正確答案: B
Oracle9i extends the cursor sharing functionality with the new value of SIMILAR for the CURSOR_SHARING parameter. With CURSOR_SHARING = SIMILAR, cursors are shared for safe literals only.
What is meant by 'safe literals only'?
What is meant by 'safe literals only'?
正確答案: D
Which statement correctly describes the function of the Oracle9i Cache Fusion feature?
正確答案: C
What is true regarding fact tables having bitmap join indexes defined on them?
正確答案: B
What does the DBMS_OLAP.VALIDATE_DIMENSION procedure do?
正確答案: B
Which two statements are true? (Choose two.)
正確答案: A,D
ABC Company consolidated into one office building, so the very large EMPLOYEES table no longer requires the OFFICE_LOCATION column. The DBA decided to drop the column using the syntax below:
ALTER TABLE hr.employees DROP COLUMN building_location CASCADE CONSTRAINTS; Dropping this column has turned out to be very time consuming and is requiring a large amount of undo space.
What could the DBA have done to minimize the problem regarding time and undo space consumption?
ALTER TABLE hr.employees DROP COLUMN building_location CASCADE CONSTRAINTS; Dropping this column has turned out to be very time consuming and is requiring a large amount of undo space.
What could the DBA have done to minimize the problem regarding time and undo space consumption?
正確答案: B
When executing parallel DELETE statements, what is the maximum degree of parallelism allowed on a table?
正確答案: A
When enabling Flashback using a wall-clock time, within what period does the database choose a System Commit Number (SCN)?
正確答案: B
What must you do to enable Automated SQL Execution Memory Management?
正確答案: C