English Русский Contacts Site map Add to favorites
Registration
Login
Master braindump list
New braindumps
Submit a dump
Get latest dump
braindumps.com.ua
flame
3COM (7)
Adobe (1)
BEA (1)
Checkpoint (22)
Cisco (20)
Citrix (17)
CIW (15)
Compaq (0)
CompTIA (51)
CWNA (2)
EMC (2)
Exin (4)
GEJOS (4)
HDI (1)
HP (4)
IBM (13)
Juniper (1)
Linux Prof Institute (LPI) (2)
Lotus (11)
Microsoft (2461)
Network Appliance (2)
Novell (16)
Oracle (412)
PLSQL (1)
PMI (4)
SAS (1)
Sun (87)
Teradata (4)
Login:
Password:
RSS feed

Contacts
Certification links
Links
Authorized user can see question and answers.
Please log in or sign up.

Exam question list:
Show all comments
Oracle 1Z0-031: Oracle9i: Database Fundamentals I
#71. A table is stored in a data dictionary managed tablespace. Which two columns are required from DBA_TABLES to determine the size of the extent when it extends? (Choose two.)

Show comments for this question (1)
Add comments
Link to this question

#72. Which three statements about the Oracle database storage structure are true? (Choose three.)

Show comments for this question (1)
Add comments
Link to this question

#73. For which result would you set the DB_CREATE_ONLINE_LOG_DEST_n parameter?

Show comments for this question (1)
Add comments
Link to this question

#74. Which statement about starting an instance without mounting the database (NOMOUNT) is true?

Show comments for this question (1)
Add comments
Link to this question

#75. Which value does the BACKGROUND_DUMP_DEST initialization parameter specify?

Show comments for this question (1)
Add comments
Link to this question

#76. For which information would you access a user trace file?

Show comments for this question (1)
Add comments
Link to this question

#77. You are preparing to create the PROD database and are configuring to use Oracle Managed Files (OMF). You set these initialization parameters before database creation:
DB_CREATE_FILE_DEST = '/u01/oradata/'
DB_CREATE_LOG_DEST_1 = '/u02/oradata/'
DB_CREATE_LOG_DEST_2 = '/u03/oradata/'
Which statement about the PROD database is true?

Show comments for this question (1)
Add comments
Link to this question

#78. Which SHUTDOWN mode will only wait for the pending transaction of a current user to end before ending the user's session?

Show comments for this question (1)
Add comments
Link to this question

#79. You notified users that a power outage would occur at 9:00 am and the database would be shut down prior to the outage. Most users have voluntarily logged off, but a few users are still connected. You need to shut down the database without waiting for the current sessions and transactions to end, but want to force a checkpoint and close the database files. Which SHUTDOWN statement should you use?

Show comments for this question (1)
Add comments
Link to this question

#80. The default location for the HR database initialization files contains these files:
init.ora
spfile.ora
initHR.ora
spfileHR.ora
Which file will the Oracle server attempt to read first when you start up the database without specifying an initialization file?

Show comments for this question (1)
Add comments
Link to this question


 [1] [2] [3] [4] [5] [6] [7] [8] [9] [10] [11] ... [37 
Up ^ gen. 0.067 Server date 06:38 22-11-2008 Developed by Zip © 2006 Up ^
Forum
Start online exam simulation
Master braindump
User braindumps