1Z0-030 Oracle - Braindumps.com.ua: question list for "Oracle 9i: New Features For Administrators", page: 9

Add to favorites

Profile

Registration

Braindumps

Master braindump list

Forums

Vendor

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2461)

Network Appliance (2)

Authorization

Login:
Password:
remember me:

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-030: Oracle 9i: New Features For Administrators

#81. What is true regarding a shared, server-side parameter file for a Real Application Clusters database?

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

#82. You are attempting to create an Oracle-Managed Files (OMF) tablespace in a production database with the following statement and receive the following error message:

 CREATE TABLESPACE tbs1;

ORA-02199: missing DATAFILE/TEMPFILE clause
oerr ora 2199
02199, 00000, "missing DATAFILE/TEMPFILE clause"
*Cause: A CREATE TABLESPACE statement has no DATAFILE/TEMPFTLE clause.
*Action: Specify DATAFILE/TEMPFILE clause.
What is the corrective action to create the OMF based tablespace?

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

#83. Examine the statement:

 DROP TABLESPACE IND2 
 INCLUDING CONTENTS 
 AND DATAFILES;

What is the result of the statement?

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

#84. If you create your database using Oracle Managed Files (OMF), what is true?

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

#85. Examine the following parameter settings from an initialization (init.ora) file:
DB_CREATE_FILE_DEST = '/u01/oradata/'
DB_CREATE_ONLINE_LOG_DEST_1 = '/u02/oradata/'
DB_CREATE_ONLINE_LOG_DEST_2 = '/u03/oradata/'
If you create an Oracle Managed Files (OMF) database using these settings, what is the result?

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

#86. Examine the statement:

 SQL> CREATE TABLESPACE user_ data 
 2> EXTENT MANAGEMENT LOCAL 
 3> SEGMENT SPACE MANAGEMENT AUTO;

Which two assumptions must be true for this statement to execute successfully? (Choose two.)

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

#87. You want to drop the TBS1 tablespace from your database.
You also want to delete the corresponding data files automatically, and not have to do it manually. What should you do?