Oracle 10g Database Administration, Databases

Question: When is SGA created in an Oracle database environment?
A
When the database is created

B
When the instance is started

C
When the database is mounted

D
When a user process is started

Note: not sure
1. Report
Question: Which data dictionary view should be used to get a list of object privileges for all database users?
A
DBA_TAB_PRIVS

B
ALL_TAB_PRIVS

C
USER_TAB_PRIVS

D
ALL_TAB_PRIVS_MADE

Note: not sure
1. Report
Question: Which statement about the LOG_BUFFER initialization parameter is true?
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: Which of the following is true when John uses the RESETLOGS option?
A
He doesn't need to back up the database

B
He must back up the database right away

C
He can use archive redo logs from an older incarnation of the database

D
He can't use archive redo logs from an older incarnation of the database

Note: not sure
1. Report
Question: Which graphical DBA administration tool should be used to tune an Oracle database?
A
SQL*Plus

B
Oracle Enterprise Manager

C
Oracle Universal Installer

D
Oracle Database Configuration Assistant

Note: not sure
1. Report
Question: Which data dictionary view should be queried to find the following information about a user? 1.Whether the user's account has expired 2.The user's default tablespace name 3.The user's profile name
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 three major tuning areas does OEM Database Control provide information about?
A
Most-used objects

B
Top SQL statements

C
Memory usage

D
Top sessions affecting the instance

E
CPU and wait classes

Note: not sure
1. Report
Question: Which memory structure contains the information used by the server process to validate user privileges?
A
Buffer cache

B
Library cache

C
Data dictionary cache

D
Redo log buffer cache

Note: not sure
1. Report
Question: Examine the 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 1MB?
A
Extent

B
Segment

C
Oracle block

D
Operating system block

Note: not sure
1. Report
Question: What are the two main advantages of using bitmap indexes?
A
Bitmap indexes use less storage space

B
Bitmap indexes are easy to maintain when DML statements are issued

C
Bitmap segments are updated upon COMMIT, at the end of the transaction

D
Bitmap indexes work very fast with multiple predicates that are combined with AND, OR, and NOT operators

Note: not sure
1. Report

First Prev 1 2 3 4 Next Last

Question: When is SGA created in an Oracle database environment?

Question: Which data dictionary view should be used to get a list of object privileges for all database users?

Question: Which statement about the LOG_BUFFER initialization parameter is true?

Question: Which of the following is true when John uses the RESETLOGS option?

Question: Which graphical DBA administration tool should be used to tune an Oracle database?

Question: Which data dictionary view should be queried to find the following information about a user? 1.Whether the user's account has expired 2.The user's default tablespace name 3.The user's profile name

Question: Which three major tuning areas does OEM Database Control provide information about?

Question: Which memory structure contains the information used by the server process to validate user privileges?

Question: Examine the 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 1MB?

Question: What are the two main advantages of using bitmap indexes?