Oracle9i dba new features for Oracle7.3 and Oracle9 ocps - 1Z0-035 Free Exam Questions

A. Issue the CREATE TABLESPACE tbs1 DATAFILE SIZE 10M; command.

B. An OMF tablespace is not allowed; only control files and/or redo log files can be created by OMF.

C. Set the db_create_file_dest parameter using the ALTER SESSION command and re-issue the statement.

D. Issue the CREATE TABLESPACE tbs1 EXTENT MANAGEMENT ORACLE; command.

A. The utility can cause contention in the shared pool when there is high activity in the database.

B. The utility can be used to verify redo-log files for corruption.

C. The utility is useful only when the database is in ARCHIVELOG mode.

D. The utility can be used with the database shut down.

A. Nonpartitioned indexes on the SALES table will be marked UNUSABLE, while valid partitioned global and local indexes will retain their USABLE status.

B. Valid indexes on the exchanged table SALES_Q1_2000 will remain in the USABLE state, while all indexes associated with the new partition Q1_2000, will be marked UNUSABLE, including any global indexes on SALES.

C. All valid global indexes on the SALES table will retain their USABLE status after the statement completes.

D. Global indexes on the SALES table will be maintained concurrently with the exchange operation if the statement executes with the desired degree of parallelism (four) otherwise it will execute serially and mark the global indexes UNUSABLE.

A. duplicate space is not required while the command executes.

B. all operations, such as INSERT, UPDATE, DELETE, and SELECT can be performed while the operation completes.

C. index definitions are retained.

D. row chaining is eliminated.

A. insert into sales(year,month,day) values (2000,01,01);

B. insert into sales(year,month,day) values (2000,03,32);

C. insert into sales(year,month,day) values (2000,02,33);

D. insert into sales(year,month,day) values (2000,01,17);

A. The Oracle server creates a new histogram based on existing histogram definitions for all table, column, and index statistics for the OE schema.

B. The Oracle server creates a histogram based on data distribution regardless of how the application uses the column/s for all table, column, and index statistics for the OE schema.

C. The Oracle server creates a histogram based on application usage, regardless of data distribution, for all table, column, and index statistics for the OE schema.

D. The Oracle server creates a histogram based on data distribution and application usage of the column/s for all table, column, and index statistics for the OE schema.

A. SMON is responsible for shrinking undo segments as needed.

B. Oracle9i automatically creates a fixed number of undo segments per undo tablespace.

C. In a Real Application Clusters environment, you must create one undo tablespace per opened instance.

D. To use this feature, you must create undo segments into an undo tablespace.

E. PMON is responsible for shrinking undo segments as needed.

A. VARCHAR

B. LONG

C. RAW

D. LONG RAW

A. tables containing a multi-column primary key

B. tables containing fewer than 16 columns, including a LONG data type column

C. tables greater than 10 GB in size

D. tables containing more than 16 columns, including a LONG data type