Oracle 10g, Databases

Question: User Smith created indexes on some tables owned by user John. You need to display the following: Index names Index types Which data dictionary view(s) would you query?
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: Which of the following conditions must be met to make tablespace read-only?
A
The tablespace must contain an active rollback segments

B
The tablespace must be online

C
The tablespace must not contain any active rollback segments

D
The tablespace must not be involved in an open backup

E
The tablespace must be involved in an open backup

Note: not sure
1. Report
Question: Where can you find the non default parameters when the instance is started?
A
Alert log

B
Online redo log

C
Archiver redo log

D
SYSTEM user's trace file

Note: not sure
1. Report
Question: Which of the following types of commands is 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 of the following items are stored in the flash recovery area?
A
Datafiles

B
Undo segments

C
Datafile copies

D
Archived redo log files

Note: not sure
1. Report
Question: What happens when the DBA disables the flash recovery area?
A
The RMAN will continue to be able to access the files in the flash recovery area

B
The RMAN will be unable to access the files in the flash recovery area

C
The RMAN will be unable to access the automatic space management features of the flash recovery area

D
None of these

Note: not sure
1. Report
Question: Which of the following statements is correct with regard to 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: What is the default value for the OPTIMIZER_MODE initialization parameter?
A
FIRST_ROWS

B
ALL_ROWS

C
CHOOSE

D
COST

Note: not sure
1. Report
Question: Which of the following statements is correct with regard to LOG_BUFFER initialization parameter?
A
The LOG_BUFFER parameter can be changed dynamically

B
The minimum value for the LOG_FILE parameter is 512KB

C
The LOG_BUFFER parameter value must be a multiple of the database block size

D
The LOG_BUFFER parameter value must be a multiple of the operating system block size

Note: not sure
1. Report
Question: The RMAN CATALOG command:
A
Helps create the image copies of datafiles

B
Helps create the image copies of current control files

C
Helps catalog the new files that are not a part of the recovery catalog

D
Helps catalog only the old files

Note: not sure
1. Report

First Prev 2 3 4 5 Next Last

Question: User Smith created indexes on some tables owned by user John. You need to display the following: Index names Index types Which data dictionary view(s) would you query?

Question: Which of the following conditions must be met to make tablespace read-only?

Question: Where can you find the non default parameters when the instance is started?

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

Question: Which of the following items are stored in the flash recovery area?

Question: What happens when the DBA disables the flash recovery area?

Question: Which of the following statements is correct with regard to index clusters?

Question: What is the default value for the OPTIMIZER_MODE initialization parameter?

Question: Which of the following statements is correct with regard to LOG_BUFFER initialization parameter?

Question: The RMAN CATALOG command: