Oracle 10g, Databases

Question: Which of the following statements are correct with regard to Rebuilding Indexes?
A
The ALTER INDEX REBUILD command is used to change the storage characteristics of an index

B
Using the ALTER INDEX REBUILD is usually faster than dropping and recreating an index because it uses the fast full scan feature

C
Oracle8i allows the creation of an index or re-creation of an existing index while allowing concurrent operations on the base table

D
When building an index, the NOLOGGING and UNRECOVERABLE keywords can be used concurrently to reduce the time it takes to rebuild

Note: not sure
1. Report
Question: Which of the following constitute the functions of an ASM instance?
A
Managing disk groups and communicating file metadata to the Oracle database using ASM files

B
Managing database files and communicating file metadata to the ASM instance using ASM files

C
Managing disk groups and communicating file metadata to the RMAN

D
Protecting disk groups

Note: not sure
1. Report
Question: You want to find the following information about a user: - The expiry date of the user's account - The user's default tablespace name - The user's profile name Which data dictionary view should be queried for the purpose?
A
DBA_USERS only

B
DBA_USERS and DBA_PROFILES

C
DBA_USERS and DBA_TABLESPACES

D
DBA_USERS, DBA_TS_QUOTAS, and DBA_PROFILES

Note: not sure
1. Report
Question: Which of the following is a new initialization parameter for Oracle Database 10g?
A
UNDO_SUPPRESS_ERRORS

B
PARALLEL_AUTOMATIC_TUNING

C
RESUMABLE_TIMEOUT

D
SHARED_SERVER

Note: not sure
1. Report
Question: What should you confirm before changing the CURSOR_SPACE_FOR_TIME parameter (in your initialization file) to TRUE?
A
The TIMED_STATISTICS parameter is set to TRUE

B
The hit percentage in the buffer cache is at least 95%

C
The OPEN_CURSOR parameter is set to at least twice the default value

D
The value in the RELOADS column of V$LIBRARYCACHE is consistently zero

Note: not sure
1. Report
Question: ________________ shows the free space available in a certain tablespace.
A
DBA_EXTENTS

B
V$FREESPACE

C
DBA_FREE_SPACE

D
DBA_TABLESPACFS

Note: not sure
1. Report
Question: Examine the following SQL statement: CREATE TABLESPACE user_data DATAFILE '/u01/oradata/user_data_0l.dbf' SIZE 100M LOCALLY MANAGED UNIFORM SIZE 1M AUTOMATIC SEGMENT SPACE MANAGEMENT; Which part of the tablespace will be of a uniform size (of 1 MB)?
A
Extent

B
Segment

C
Oracle block

D
Operating system block

Note: not sure
1. Report
Question: Which DBMS_LOGMNR feature facilitates the automatic addition of the redo log files for mining?
A
REMOVE_LOGFILE

B
CONTINUOUS_MINE

C
NO_ROWID_IN_STMT

D
AUTOMATIC_LOGFILE

Note: not sure
1. Report
Question: Which of the following statements are correct for rebuilding an index?
A
The resulting index may contain deleted entries

B
A new index is built using an existing index as the data source

C
Queries cannot use the existing index while the new index is being built

D
During a rebuild, sufficient space is needed to accommodate both the old and new indexes in their respective tablespaces

Note: not sure
1. Report
Question: Which of the following helps you identify your statement in the DBA_TUNE_MVIEW view?
A
The STATEMENT variable

B
The STATEMENT_ID column

C
The VIEW_ID column

D
The TASK_NAME variable

Note: not sure
1. Report

First Prev 1 2 3 4 Next Last

Question: Which of the following statements are correct with regard to Rebuilding Indexes?

Question: Which of the following constitute the functions of an ASM instance?

Question: You want to find the following information about a user: - The expiry date of the user's account - The user's default tablespace name - The user's profile name Which data dictionary view should be queried for the purpose?

Question: Which of the following is a new initialization parameter for Oracle Database 10g?

Question: What should you confirm before changing the CURSOR_SPACE_FOR_TIME parameter (in your initialization file) to TRUE?

Question: ________________ shows the free space available in a certain tablespace.

Question: Examine the following SQL statement: CREATE TABLESPACE user_data DATAFILE '/u01/oradata/user_data_0l.dbf' SIZE 100M LOCALLY MANAGED UNIFORM SIZE 1M AUTOMATIC SEGMENT SPACE MANAGEMENT; Which part of the tablespace will be of a uniform size (of 1 MB)?

Question: Which DBMS_LOGMNR feature facilitates the automatic addition of the redo log files for mining?

Question: Which of the following statements are correct for rebuilding an index?

Question: Which of the following helps you identify your statement in the DBA_TUNE_MVIEW view?