{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

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

Info icon This 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
Image of page 1

Info icon This 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
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.
Image of page 3

Info icon This 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 ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern