{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

1Z0-030 - Exam 1Z0-030 Title Oracle9i New Features for...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Exam : 1Z0-030 Title : Oracle9i: New Features for Administrators Ver : 09.05.06
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
1Z0-030 Actualtests.com - The Power of Knowing QUESTION 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.) A. No user or application has to remember or hide a password. B. It prevents everyone except a true DBA session from acquiring the READWRITE role. C. app.chk_readwrite is called whenever a user tries to access rows protected by the READONLY or READWRITE label. D. app.chk_readwrite is called by users or applications when they want to enable the READONLY or READWRITE role. Answer: A, B, D Explanation: Oracle8i introduced the Secure Application Context to enable an application to tailor access control based on using the attributes of the user's session. Oracle prevents users from bypassing privileges validation procedure by restricting application attribute changes to the procedure that implements the context. Oracle9i takes the concept of the application context one step further; it provides a means of associating the application context with the security role. Incorrect Answers C: App.chk_readwrite will not be called whenever a user tries to access rows protected by the READONLY or READWRITE label. It will be called only when they want to enable the READONLY or READWRITE role. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 10-14 Chapter 1: Security Enhancements Oracle 9i New Features, Robert Freeman, p. 132-135 Chapter 5: Miscellaneous Oracle9i Features and Enhancements
Background image of page 2
1Z0-030 Actualtests.com - The Power of Knowing QUESTION 2: Examine the extract from a SQL*Plus session. SQL> SELECT partition_name, high_value, tablespace_name 2 FROM user_tab_partitions 3 WHERE table_name = 'LOCATIONS'; PARTITION_NAME HIGH_VALUE TABLES ----------- ------ ----- REGION_EAST 'MA', 'NY', 'CT', 'NH', NULL, 'MD', 'VA', 'PA', 'NJ' tbs1 REGION_WEST 'CA', 'AZ', 'NM', 'OR', 'WA', 'UT', 'NV', 'CO', tbs2 REGION_SOUTH 'TX', 'KY', 'TN', 'LA', 'MS', 'AR', 'AL', 'GA' tbs3 REGION_CENTRAL 'OH', 'ND', 'SD', 'MO', 'IL', 'MI', NULL, 'IA' tbs4 SQL> ALTER TABLE locations 2 SPLIT PARTITION region_east 3 VALUES('CT','MA','MD') 4 INTO 5 (PARTITION region_north_east TABLESPACE tbs2 6 ,PARTITION region_south_east STORAGE (NEXT 2M)); 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? A. The REGION_SOUTH_EAST partition will be created in the TBS2 tablespace.
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}