1z0-032 Oracle - Braindumps.com.ua: question list for "Oracle 9i: Database Fundamentals II", page: 10

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-032: Oracle 9i: Database Fundamentals II

#91. Examine the statement:

 SQL> CREATE TABLE SPACE user_data 
 2> EXTENT MANAGEMENT LOCAL 
 3> SEGMENT SPACE MANAGEMENT AUTO;

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

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

#93. Which two statements regarding the control file and Recover Manager are true? (Choose two)

#94. You discover that a disk failure occurred on DISK3 where the data file belonging to the USER_DATA table space is stored. The database is currently open and you need to recover the data file. You will restore the data file to DISK2.
What is the correct sequence RMAN commands to restore and recover the data file?

#95. What is true regarding the role Oracle Net provides in a client server connection with no middle tier? (Choose two)

#96. When performing an incomplete recovery of the whole database, what must be true about the data files that are restored?

#97. You have performed the first step in placing your database into ARCHIVE LOG mode. The second step is deciding whether the online redo log files are to be archived automatically or manually. Which action should you take to enable archiving at instance startup?

#98. You issue this statement:

 ALTER DATABASE BACKUP CONTROL FILE TO TRACE;

What does the statement generate?

#99. Which statement is true regarding RMAN components?

#100. Oracle Net Services is composed of several communication layers, known as a stack, which enables clients and database severs to share, modify, and manipulate data. Which reveals the correct architecture, in hierarchical order, of the client-side stack?

[1] [2] [3] [4] [5] [6] [7] [8] [9] [10] [11] ... [37]

gen. 0.115

Server date 06:45 02-12-2008

Oracle 1z0-032

Forum

Start online exam simulation

Master braindump

User braindumps