Oracle9i dba new features for Oracle7.3 and Oracle9 ocps - 1Z0-035 Exam Practice Test
What does using the package DBMS_RESOURCE_MANAGER enable you to do?
Correct Answer: E
Vote an answer
Click the Exhibit button and examine the code.
Which three statements correctly describe the Secure Application role definition?
(Choose three.) (The SYS_CONTEXT calls returns whether or not the session is a true DBA session.)
Which three statements correctly describe the Secure Application role definition?
(Choose three.) (The SYS_CONTEXT calls returns whether or not the session is a true DBA session.)
Correct Answer: A,C,D
Vote an answer
You need to add a column to a table that holds updateable image data. Which data type should you use for this column?
Correct Answer: A
Vote an answer
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'?
Correct Answer: D
Vote an answer
What is true regarding a shared, server-side parameter file for a Real Application Clusters database?
Correct Answer: A
Vote an answer
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: C
Vote an answer
The TYPE clause used in the creation of an external table defines which access driver is used to convert the data when needed by SQL statements inside the database. Which type of access driver is supported for external tables?
Correct Answer: B
Vote an answer
Which two can be obtained from the summary advisor? (Choose two.)
Correct Answer: B,C
Vote an answer
Which type of ROWID does Oracle use for global indexes on partitioned tables?
Correct Answer: B
Vote an answer
What happens during a complete refresh of a materialized view?
Correct Answer: D
Vote an answer
The new time and date data types support greater precision for capturing fractional seconds and time zone information. This gives the Oracle9i database greater flexibility in supporting locality preferences. What is the default degree of precision of fractional seconds when specifying the TIMESTAMP data type?
Correct Answer: A
Vote an answer
Which type of index requires the table partition key to be in the leading portion of the index key?
Correct Answer: C
Vote an answer
What is required for the Character Set Scanner to operate?
Correct Answer: D
Vote an answer