|
|
Oracle 1Z0-030: Oracle 9i: New Features For Administrators
|
#1. Examine the code. CREATE ROLE readonly IDENTIFIED 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 says CONTEXT (‘USERENV’, ‘ISDBA’=’TRUE’ THEN DBMS SESSION.SET_ROLE (‘READWRITE’) ; ELSE DMBS_SESSION_SET_ROLE )’READONLY’) ; END IF ; 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.)
|
|
#2. Which three statements are true about the privileged connection options available in Oracle9i? (Choose three.)
|
|
#3. 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?
|
|
#4. Oracle9i offers security improvements in the middle tier. One of these improvements is the Secure Application role. What are three key benefits of this improvement? (Choose three).
|
|
#5. You created a database by using the Database Configuration Assistant What must you do to access a user account in the sample schemas?
|
|
#6. You can use Oracle Flashback to look at past activity in your database. What are two other characteristics of Oracle Flashback? (Choose two.)
|
|
#7. The list below displays four steps that you need to execute in order to switch from the primary database role to the standby database role.
Choose the correct order of execution for the steps.
1. Shut down and start up the former primary instance without mounting the instance.
2. Issue the ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY command.
3. Issue the ALTER DATABASE MOUNT STANDBY DATABASE command.
4. End read or update activity on the former primary and standby databases.
|
|
#8. Why can setting too low a value for the FAST_START_MTTR_TARGET parameter reduce your overall database performance?
|
|
#9. To increase the availability of an Advanced Replication environment, you can add a new master to a replication group without quiescing the group. This is achieved____________.
|
|
#10. Which three table transformations can be done by using online redefinition of tables? (Choose three.)
|
|
|
|
 gen. 0.084
|
Server date 18:01 14-03-2010
|
Developed by Zip © 2006
|
|
|
|
|
1Z0-030 certification
1Z0-030 master dump