Oracle 10g Database Administration, Databases

Question: When a deadlock shutdown is detected by Oracle, where is the trace file generated?
A
SQL_TRACE

B
TRACE_DEST

C
USER_DUMP_DEST

D
CORE_DUMP_DEST

Note: not sure
1. Report
Question: How can the SQL Access Advisor be managed?
A
Through the DBMS_SQLTUNE package

B
Through the DBMS_ADVISOR package

C
Through the SQL_TUNE package

D
Through the DBA_ADVISOR package

Note: not sure
1. Report
Question: User Smith created indexes on some tables owned by user John. The following has to be displayed: 1.Index names 2.Index types Which data dictionary view(s) should be queried?
A
DBA_INDEXES only

B
DBA_IND_COLUMNS only

C
DBA_INDEXES and DBA_USERS

D
DBA_IND COLUMNS and DBA_USERS

Note: not sure
1. Report
Question: For which two tasks would it be best not to use the utility SQL*Loader?
A
When loading selected rows into each table

B
When loading data from an export dump file

C
When loading data from disk, tape, or named pipes

D
When data is not being inserted from a flat file

Note: not sure
1. Report
Question: Which of the following helps the user identify his 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
Question: Which DBMS_LOGMNR feature facilitates the automatic adding of 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 commands are used to copy ASM files?
A
RMAN commands

B
OMF commands

C
Operating system commands

D
Logical Volume Manager commands

Note: not sure
1. Report
Question: Which statement is valid regarding index clusters?
A
Index clusters can only be used for tables with low cardinality columns

B
Index clusters are generally well suited for tables that have many full table scans

C
Normal B-Tree indexes do not store null key values, whereas cluster indexes store null keys

D
A cluster index always takes up much more storage space than a normal index for the same set of key values

Note: not sure
1. Report
Question: Which three statements among the following are true about 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 for 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 itself

Note: not sure
1. Report
Question: What do ASM disk groups provide?
A
Redundancy through striping

B
Performance through mirroring

C
Redundancy through mirroring

D
Performance through striping

Note: not sure
1. Report

First Prev 3 4 5 6 7 Next Last

Question: When a deadlock shutdown is detected by Oracle, where is the trace file generated?

Question: How can the SQL Access Advisor be managed?

Question: User Smith created indexes on some tables owned by user John. The following has to be displayed: 1.Index names 2.Index types Which data dictionary view(s) should be queried?

Question: For which two tasks would it be best not to use the utility SQL*Loader?

Question: Which of the following helps the user identify his statement in the DBA_TUNE_MVIEW view?

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

Question: Which of the following commands are used to copy ASM files?

Question: Which statement is valid regarding index clusters?

Question: Which three statements among the following are true about rebuilding indexes?

Question: What do ASM disk groups provide?