Oracle9i dba new features for Oracle7.3 and Oracle9 ocps (1Z0-035) Free Practice Test
Question 1
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.
Correct Answer: D
Question 2
In order to speed foreign key creation, Oracle9i will cache the first _____ primary key values only where there are multirow DML statements.
Correct Answer: A
Question 3
Which three things can the ALTER INDEX REBUILD command accomplish? (Choose three.)
Correct Answer: B,C,D
Question 4
The CURSOR_SHARING parameter is set to SIMILAR at the instance level and you issue these SELECT statements in the order shown below:
SELECT * FROM employees WHERE department_id=50; SELECT * FROM employees WHERE department_id=70;
There is an index on the DEPARTMENT_ID column of the 1,000,000 row EMPLOYEES table.
Ninety percent of the employees are part of DEPARTMENT_ID 50.
In which two scenarios will Oracle9i share the corresponding cursors for the two statements? (Choose two.)
SELECT * FROM employees WHERE department_id=50; SELECT * FROM employees WHERE department_id=70;
There is an index on the DEPARTMENT_ID column of the 1,000,000 row EMPLOYEES table.
Ninety percent of the employees are part of DEPARTMENT_ID 50.
In which two scenarios will Oracle9i share the corresponding cursors for the two statements? (Choose two.)
Correct Answer: C,D
Question 5
You issue these queries to obtain information about the REGIONS table:
SQL> SELECT segment_name, tablespace_name 2> FROM user_segments 3> WHERE segment_name = 'REGIONS';
SEGMENT_NAME TABLESPACE_NAME
REGIONS SAMPLE
SQL> SELECT constraint_name, constraint_type 2> FROM user_constraints 3> WHERE table_name = 'REGIONS';
CONSTRAINT_NAME C
REGION_ID_NN C REG_ID_PK P SQL> SELECT index_name 2> FROM user_indexes 3> WHERE table_name = 'REGIONS';
INDEX_NAME
REG_ID_PK
You then issue this command to move the REGIONS table:
ALTER TABLE regions
MOVE TABLESPACE user_data;
What else must you do to complete the move of the REGIONS table?
SQL> SELECT segment_name, tablespace_name 2> FROM user_segments 3> WHERE segment_name = 'REGIONS';
SEGMENT_NAME TABLESPACE_NAME
REGIONS SAMPLE
SQL> SELECT constraint_name, constraint_type 2> FROM user_constraints 3> WHERE table_name = 'REGIONS';
CONSTRAINT_NAME C
REGION_ID_NN C REG_ID_PK P SQL> SELECT index_name 2> FROM user_indexes 3> WHERE table_name = 'REGIONS';
INDEX_NAME
REG_ID_PK
You then issue this command to move the REGIONS table:
ALTER TABLE regions
MOVE TABLESPACE user_data;
What else must you do to complete the move of the REGIONS table?
Correct Answer: D
Question 6
Which statements are true regarding the new Persistent Configuration feature in RMAN? (Choose two.)
Correct Answer: A,B
Question 7
What is true regarding fact tables having bitmap join indexes defined on them?
Correct Answer: D
Question 8
What is true regarding a transaction executed in Automatic Undo Management mode?
Correct Answer: B