[Q][031]Discuss Together

liu

I just want to make sure that all 18 chapters in Study Guide will be coverd in 031 exam. Am I correct?

lwn123

no: 7

The maximum and default value for MAXLOGFILES is dependent on your operating system.
所以A未必是错误的

xmzw

QUESTION NO: 60
Which steps should you take to gather information about checkpoints?
A. Set the LOG_CHECKPOINTS_TO_ALERT initialization parameter to TRUE. Monitor the alert log file.
B. Set the LOG_CHECKPOINT_TIMEOUT parameter. Force a checkpoint by using the FAST_START_MTTR_TARGET parameter.Monitor the alert log file.
C. Set the LOG_CHECKPOINT_TIMEOUT parameter.Force a log switch by using the command ALTER SYSTEM FORCE LOGSWITCH.Force a checkpoint by using the command ALTER SYSTEM FORCE CHECKPOINT.Monitor the alert log file.
D. Set the FAST_START_MTTR_TARGET parameter to TRUE.Force a checkpoint by using the command ALTER SYSTEM FORCE CHECKPOINT.Monitor the alert log file.
Answer: B               

我选择A

xmzw

QUESTION NO: 61
The DBA can structure an Oracle database to maintain copies of online redo log files to avoid losing database information.Which three are true regarding the structure of online redo log files? (Choose three.)
A. Each online redo log file in a group is called a member.
B. Each member in a group has a unique log sequence number.
C. A set of identical copies of online redo log files is called an online redo log group.
D. The Oracle server needs a minimum of three online redo log file groups for the normal operation of a database.
E. The current log sequence number of a redo log file is stored in the control file and in the header of all data files.
F. The LGWR background process concurrently writes the same information to all online and archived redo log files in a group.
Answer: B, C, E   
           
我选择 A,C,E

xmzw

QUESTION NO: 74
You set the value of the OS_AUTHENT_PREFIX initialization parameter to OPS$ and created a user account by issuing this SQL statement:
CREATE USER OPS$smith
IDENTIFIED EXTERNALLY;
Which two statements are true? (Choose two.)
A. Oracle server assigns the DEFAULT profile to the user.
B. You can specify the PASSWORD EXPIRE clause for an external user account.
C. The user does not require CREATE SESSION system privilege to connect to the database.
D. If you query the DBA_USERS data dictionary view the USERNAME column will contain the value SMITH.
E. The user account is maintained by Oracle, but password administration and user authentication are performed by the operating system or a network service.
Answer: C, D

我选择A,D

xmzw

QUESTION NO: 75
Which two statements about segments are true? (Choose two.)
A. Each table in a cluster has its own segment.
B. Each partition in a partitioned table is a segment.
C. All data in a table segment must be stored in one tablespace.
D. If a table has three indexes only one segment is used for all indexes.
E. A segment is created when an extent is created, extended, or altered.
F. A nested table of a column within a table uses the parent table segment.
Answer: B, F         

我选择B,C

xmzw

大家都没兴趣讨论一下吗？

xmzw

QUESTION NO: 79
Evaluate the SQL comman
CREATE TEMPORARY TABLESPACE temp_tbs
TEMPFILE '/usr/oracle9i/OraHomel/temp_data.dbf'
SIZE 2M
AUTOEXTEND ON;
Which two statements are true about the TEMP_TBS tablespace? (Choose two.)
A. TEMP_TBS has locally managed extents.
B. TEMP_TBS has dictionary managed extents.
C. You can rename the tempfile temp_data.dbf.
D. You can add a tempfile to the TEMP_TBS tablespace.
E. You can explicitly create objects in the TEMP_TBS tablespace.
Answer: B, C              

我选择A,D

lightjay

I believe so!  At least last chapter is covered.

最初由 liu 发布
[B]I just want to make sure that all 18 chapters in Study Guide will be coverd in 031 exam. Am I correct? [/B]

xmzw

QUESTION NO: 80
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 need to query?
A. DBA_INDEXES only
B. DBA_IND_COLUMNS only
C. DBA_INDEXES and DBA_USERS
D. DBA_IND COLUMNS and DBA_USERS
E. DBA_INDEXES and DBA_IND_EXPRESSIONS
F. DBA_INDEXES, DBA_TABLES, and DBA_USERS
Answer: F            

我选择 A