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

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

#31. When you are performing media recover, and an archived log is lost or corrupt, which type of recover must you perform?

#32. Which three features are provided by Oracle Net Services? (Choose three)

#33. Which phrase best describes RMAN multiplexed backup sets?

#34. Which modifier is used to change listener parameters in the Listener Control utility environment?

#35. You company has four DBAs. You need to know which DBA added a column to the JOB_HISTORY table. The database cannot be offline during work hours. Which Log Miner command can you use to find out which user made the table change?

#36. Automatic Consumer Group Switching is an important new feature of the Database Resource Manager. Which three plan directive parameters are used to control this feature? (Choose three)

#37. How can you make a shared server-side initialization parameter file available to all instances of a Real Application Clusters database?

#38. Examine the command:

 ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;

What does the command accomplish?

#39. Consider this RMAN command:
RMAN> CONFIGURE RETENTION POLICY CLEAR;
What is the effect of this command?

#40. Examine the code:

 CREATE ROLE readonly IDENTIFIES USING app.chk_readwrite ; 
 CREATE ROLE readwrite IDENTIFIED USING app.chk_readwrite ; 
 CREATE OR REPLACE PROCEDURE app.chk_readwrite 
 AUTHID CURRENT_USER IS 
 ipchk STRING(30); 
 BEGIN 
 IF SYS_CONTEXT(‘USERENV’,’ISDBA’)=’TRUE’ 
 THEN DBMS_SESSION.SET_ROLE‘READ WRITE’) ; 
 ELSE DBMS_SESSION.SET_ROLE(‘READ ONLY’) ; 
 END;

Which three statements correctly describe the Secure Application role definition? (Choose three) (The SYS_CONTEXT calls returns whether or not the session is a true DBA session.)

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

gen. 0.12

Server date 06:30 02-12-2008

Oracle 1z0-032

Forum

Start online exam simulation

Master braindump

User braindumps