1z0-032 Oracle - Braindumps.com.ua: question list for "Oracle 9i: Database Fundamentals II", 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-032: Oracle 9i: Database Fundamentals II

#81. 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 from the backup on DISK5 to DISK2. What is the correct sequence of commands to restore and recover the data file?

#82. In this scenario, assume that you archive logs 101 to 104 to two archiving destinations, /log1 and /log2. The control file contains archived log records as follows:
Sequence Filename
101 /log1/log_1_101.arc
101 /log2/log_1_101.arc
102 /log1/log_1_102.arc
102 /log2/log_1_102.arc
103 /log1/log_1_103.arc
103 /log2/log_1_103.arc
104 /log1/log_1_104.arc
104 /log2/log_1_104.arc
You accidentally delete logs 102 and 104 from log 1.
You run this command:

 BACKUP ARCHIVE LOG FROM SEQUENCE 101 UNTIL SEQUENCE 105;

What happens?

#83. You have just run this syntax to start the listener from the Listener Control utility:
LSNRCTL>START
Starting /mstgelai/oracle/bin/tnslsnr: please wait…
System parameter file is /u01/oracle/network/admin/listener.ora
Log messages written to /u01/oracle/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=stc-sun01-
server)(PORT=1521)))
Connecting to…
The command completed successfully
What is the name of the Listener you started?

#84. Which three table transformations can be done using online redefinition of tables? (Choose three)

#85. What is true about version-enabled tables?

#86. You can use Oracle Flashback to look at past activity in your database.
What are two other characteristics of Oracle Flashback? (Choose two)

#87. What is true regarding a transaction executed in Automatic Undo Management mode?

#88. Click the Exhibit (missing) button and examine the extract from a SQL*Plus session

Assuming that there is at least one row for each value shown in the HIGH VALUE column, what is the result of the ALTER TABLE statement?

#89. What should you look at first to compute the number of undo blocks written per second to disk?

#90. The EMPLOYEES table is stored in the SAMPLE table space.
The corresponding IPK_EMP index for the EMPLOYEES table’s primary key is stored in the INDX table space.
Out of 12 partitions, only partition P1 of the SALES table is stored in the SAMPLE table space. Which object will be exported by this command? exp system/manager table spaces=SAMPLE

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

gen. 0.089

Server date 05:33 02-12-2008

Oracle 1z0-032

Forum

Start online exam simulation

Master braindump

User braindumps