Oracle 1Z0-035 試験概要:

Oracle 1Z0-035 試験シラバストピック:

Oracle9i dba new features for Oracle7.3 and Oracle9 ocps 認定 1Z0-035 試験問題：

問題 #1
Examine the statement:
SQL> CREATE TABLESPACE user_data 2> EXTENT MANAGEMENT LOCAL 3> SEGMENT SPACE MANAGEMENT AUTO;
Which two assumptions must be true for this statement to execute successfully? (Choose two.)

A. The USER_DATA tablespace is managed using FET$/UET$ tables.
B. Space within segments in the USER_DATA tablespace is managed with freelists.
C. Oracle Managed Files are used for this instance.
D. The COMPATIBLE initialization parameter must be 9.0.0 or higher.

問題 #2
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?

A. You must grant all privileges that were on the REGIONS table in the SAMPLE tablespace to the REGIONS table in the USER_DATA tablespace.
B. You must rebuild the REG_ID_PK index.
C. You must drop the REGIONS table that is in the SAMPLE tablespace.
D. You must re-create the REGION_ID_NN and REG_ID_PK constraints.

問題 #3
What is true if you want to switch undo tablespaces from the current one, called UNDO1, to a new one called UNDO2?

A. It is NOT possible to switch unless no active transaction exists in UNDO1.
B. It is possible to switch to UNDO2; current active transactions will be automatically migrated to UNDO2.
C. It is possible to switch to UNDO2, but current active transactions will abort.
D. It is possible to switch to UNDO2; only current active transactions will continue to execute inside UNDO1.

問題 #4
Which three statements about Recovery Manager backups are true? (Choose three.)

A. In a full backup, Recovery Manager will back up all files and all used blocks only.
B. Each file in a backup set must have the same block size.
C. Incremental backups are noncumulative by default.
D. With multilevel incremental backups, you can have no more than three levels.
E. A control file backup set cannot contain any other types of files.

問題 #5
You are managing a complex multi-protocol networking environment. Which Oracle networking solution can you use to provide multiplexing of connections?

A. Oracle Names
B. Advanced Networking Option
C. Security Server
D. Connection Manager

解説：