Oracle 10g Database Administration, Databases

Question: What happens once 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
The RMAN can use only the automatic space management features of the flash recovery area

Note: not sure
1. Report
Question: Which initialization parameter specifies the location of the alert log file?
A
UTL_FILE_DIR

B
USER_DUMP_DEST

C
LOG_ARCHIVE_DEST

D
BACKGROUND_DUMP_DEST

Note: not sure
1. Report
Question: What will the command EXECUTE DBMS_SCHEDULER.PURGE_LOG(); do?
A
Purge only all the window logs

B
Purge only all the job logs

C
Purge all window and job logs

D
Purge only yesterday's job logs

Note: not sure
1. Report
Question: Which data dictionary view shows the available free space in a certain tablespace?
A
DBA_EXTENTS

B
V$FREESPACE

C
DBA_FREE_SPACE

D
DBA_TABLESPACFS

Note: not sure
1. Report
Question: What are 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: If the DBCA is used to create a new database, when is the creation of the new flash recovery area mandatory?
A
Always

B
Only if the automatic backup using the OEM is configured

C
Only if user-managed backups is configured

D
Only if the database is run in the archive log mode

Note: Not available
1. Report
Question: What does the ARBn background process do in an ASM instance?
A
Coordinates disk activity

B
Performs disk rebalance work

C
Coordinates disk rebalance work

D
Manages the RBAL process

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 available
1. Report
Question: Which view provides the names of all the data dictionary views?
A
DBA_NAMES

B
DBA_TABLES

C
DICTIONARY

D
DBA_DICTIONARY

Note: not sure
1. Report
Question: How is the SQL profile used?
A
In the tuning mode of the optimizer only

B
In the normal mode of the optimizer

C
In neither the tuning nor the normal mode of the optimizer

D
Along with existing statistics, to get better SQL execution plans

Note: not sure
1. Report

First Prev 4 5 6 7 Next Last

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

Question: Which initialization parameter specifies the location of the alert log file?

Question: What will the command EXECUTE DBMS_SCHEDULER.PURGE_LOG(); do?

Question: Which data dictionary view shows the available free space in a certain tablespace?

Question: What are the functions of an ASM instance?

Question: If the DBCA is used to create a new database, when is the creation of the new flash recovery area mandatory?

Question: What does the ARBn background process do in an ASM instance?

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

Question: Which view provides the names of all the data dictionary views?

Question: How is the SQL profile used?