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
#101. Examine the PROD database file configuration.

Which statement about the PROD database file configuration is true?

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

#102. Why must you recreate the control file if you change the MAXDATAFILES parameter for the PROD database?

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

#103. You issued a CREATE DATABASE statement that failed because you were attempting to create log files that already existed.
What should you do before reissuing the CREATE DATABASE statement?

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

#104. Evaluate this CREATE DATABASE statement:
  1. CREATE DATABASE U16
  2. MAXLOGFILES 5
  3. MAXLOGMEMBERS 5
  4. MAXDATAFILES 100
  5. MAXLOGHISTORY 100
  6. LOGFILE
  7. GROUP 1 '/disk3/log1a.rdo, /disk4/log1b.rdo',
  8. GROUP 2 '/disk3/log2a.rdo, /disk4/log2b.rdo' REUSE
  9. DATAFILE '/disk2/system01.dbf' SIZE 50M;
Which line will return an error under any condition?

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

#105. You used the Database Configuration Assistant to create a database template from an existing database. You copied only the database structure, not the data. Which statement is true?

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

#106. Which data dictionary view would you query to check the status of a view based on a table that was dropped?

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

#107. Which data dictionary category would a member of the SELECT_CATALOG_ROLE role query to find the owner of the PRODUCT1 table?

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

#108. Which two dynamic performance views could you query to display the names and locations of the control files? (Choose two.)

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

#109. Evaluate this SQL statement:
  1. SELECT * FROM DBA_TAB_PRIVS;
Which results are displayed by this statement?

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

#110. You issue this SQL statement:
  1. SELECT * FROM user_tables;
Which two statements about the results returned by this SQL statement are true? (Choose two.)

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


  [1] ...  [11] [12] [13] [14] [15] [16] [17] [18] [19] [20] [21] ... [37 
Up ^ gen. 0.245 Server date 08:45 22-11-2008 Developed by Zip © 2006 Up ^
Forum
Start online exam simulation
Master braindump
User braindumps