1Z0-035 Oracle - Braindumps.com.ua: question list for "Oracle 7.3 & 8 to Oracle9i DBA OCP Upgrade", page: 81

Add to favorites

Profile

Registration

Braindumps

Master braindump list

Forums

Vendor

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2462)

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-035: Oracle 7.3 & 8 to Oracle9i DBA OCP Upgrade

#801. What does tine-grained access enable you to do?

#802. You want to benefit from a partial partition-wise join for two tables. What is required?

#803. You decide to activate the resumable space allocation feature for all your database users by enabling the feature in a logon trigger.
This causes a statement that requires space beyond a user’s quota _____

#804. Examine this statement

 SELECT * 
 FROM (SELECT class_id, crs_id 
 FROM classes 
 ORDER BY start_date DESC) 
 WHERE ROWNUM <11;

What will happen when this executes?

#805. Given:
LOG_APCHIVE_DEST_2 = “LOCATION = /archive2 OPTIONAL”
What effect does OPTIONAL have in the location parameter?

#806. A switchover to a standby database differs from a failover to the standby in a number of ways. What are two of the key differences that characterize a switchover? (Choose two.)

#807. Click the Exhibit button.

Given the partition definition, which insert statement will fail?

#808. In the DBA_TRIGGERS data dictionary view, the value in the TABLE_NAME column will be NULL in which two situations? (Choose two.)

#809. Examine this startup script called startmydb.sql:
CONNECT myid/mypwd AS SYSDBA
STARTUP
EXIT
In Oracle8i, you could have executed this script by invoking Server Manager with the command: svrmgrl@startmydb.sql
Which alternative command could you use to run the startmydb.sql script with SQL*Plus to start your Oracle9i database?

#810. Which statements are true regarding the new Persistent Configuration feature in RMAN? (Choose two.)

[1] ... [81] [82] [83] [84] [85]

gen. 0.079

Server date 06:31 08-01-2009

Oracle 1Z0-035

Forum

Start online exam simulation

Master braindump