testking oracle 9i 1z0-030
Visited 389 times, 5 so far today
Exam 1z0-030: Oracle9i: New Features for Administrators
Exam Number: 1Z0-030
Associated Certifications: Oracle8i DBA OCPs to Oracle9i DBA
Exam Price: $125.00 USD
Exam Registration: Register
Duration: 105 minutes
Number of Questions: 60
Passing Score: 50%
Recommended Training and Preparation
The exam is based on Oracle9i Release 2
Oracle9i: New Features for Administrators
Oracle9i New Features for Administrators Self-Study CD Course (NETg)
Self-Study CD-ROMs are an excellent tool to help you prepare for your exam. SSCDs reinforce the course material and allow you to focus on sections that you need to review. Note: the SSCDs do not count towards your course requirements for certification and should be used as a study aid only.
Additional Information & Resources
Practice Exams
Oracle authorized practice exam from Self Test Software. 1Z0-030 Oracle 9i New Features for Administrators
Oracle authorized practice exam from Transcender: Cert-1Z0-030 : DBCert: 9i Database: New Features for Administrators
Oracle9i DBA Certification Exam Candidate Guide
Exam Retake Policy
Exam Topics
Oracle Server Security
[ ] Explain the new privileged connection options
[ ] Describe the new security features and their application: Secure Application Role, Global Context, Partitioned Fine Grain Access Control, Fine Grained Auditing
[ ] Describe the optional security products
General High Availability Technology
[ ] Explain new features designed to harden the database against unplanned downtime
[ ] Describe minimal I/O recovery
[ ] Describe fast-start time-based recovery limit
[ ] Explain the new Oracle Flashback feature
[ ] Describe Resumable Space Allocation
[ ] Describe the new Export/Import features
Oracle9i LogMiner Enhancements
[ ] Explain LogMiner new features: DDL statement support, dictionary staleness detection, ability to use an online dictionary, ability to skip log corruptions
[ ] Describe the LogMiner Viewer
Backup and Recovery
[ ] Describe new RMAN manageability features: new backup enhancements, new restore/recovery enhancements
[ ] Describe new RMAN reliability features: Block media recovery (BMR), Trial Recovery
[ ] Describe other RMAN improvements
Oracle9i Data Guard
[ ] Explain the Oracle9i Data Guard Architecture
[ ] Configure the physical Standby Database in no-data- loss mode
[ ] Initiate a Database Switchover operation
[ ] Setup automatic archive gaps detection
[ ] Launch managed recovery mode in the background
[ ] Apply a delay to redo application on the standby site
Database Resource Manager Enhancements
[ ] Automatically detect long running operations
[ ] Automatically limit resource consumption other than CPU and DOP
Online Operations
[ ] Discuss new features designed to reduce planned downtime
[ ] Explain online index rebuild new functionality
[ ] Explain online functionality for index-organized tables (IOTs)
[ ] Describe online table redefinitions
[ ] Explain online analyze validate
[ ] Describe the use of the Server Parameter File (SPFILE)
Segment Management (Part I)
[ ] Use the automatic global index maintenance feature
[ ] Explain the use of external tables
[ ] Use the new LIST partitioning method
[ ] Explain the basics of meta data Application Programming Interface
Segment Management (Part II)
[ ] Explain and use the new Automatic Segment-Space Management functionality
[ ] Create, and use bitmap join indexes
Performance Improvements
[ ] Use the indexes monitoring feature
[ ] Describe skip scan index access
[ ] Describe the cursor sharing enhancements
[ ] Identify cached execution plans
[ ] Use the new first rows optimization
[ ] Gather system statistics
Real Application Clusters
[ ] Explain Cache Fusion
[ ] Configure a shared server-side initialization parameter file
File Management
[ ] Explain the concept and benefits behind Oracle- Managed Files (OMF)
[ ] Create and manage OMF files
[ ] Use SQL syntax to remove associated OS files when removing a non-OMF tablespace from the database
[ ] Create and alter default temporary tablespaces
Tablespace Management
[ ] Explain the concept of Automatic Undo Management
[ ] Create and maintain UNDO tablespaces
[ ] Create and properly use multiple block sizes within a database
Memory Management
[ ] Set parameters to enable automatic and dynamic sizing of SQL working areas
[ ] Use new columns and views to gather information regarding SQL execution memory management
[ ] Describe the allocation and tracking of memory behind a dynamic SGA
Enterprise Manager Enhancements
[ ] Describe the new look and feel of the Console
[ ] Use the Console in Standalone mode
[ ] Explain Enterprise Manager functionality that supports Oracle9i Database features
[ ] Generate HTML Reports
[ ] Create User defined events
SQL Enhancements
[ ] Use ISO/ANSI standard SQL syntax, such as: Joins, CASE expressions, NULLIF, COALESCE, scalar subqueries, MERGE, analytical functions
[ ] Identify other SQL enhancements, such as: constraint enhancements, FOR UPDATE WAIT
[ ] Use the enhancements to LOBs and PL/SQL
Globalization Support
[ ] Describe the new date and time data types
[ ] Describe the Unicode enhancements
[ ] Describe the enhanced sorting functionality
[ ] Use the Character Set Scanner
[ ] Explain the new byte and character semantics
[ ] Use the Locale Builder
Database Workspaces
[ ] Identify the Workspace Manager role
[ ] Version-enable a table
[ ] Disable workspace participation for a table
[ ] Create and assign a workspace
[ ] Explain Import and Export considerations
Oracle Certification Program Fraudulent Activity Policy
Oracle reserves the right to take action against any candidate involved in fraudulent activities, including, but not limited to, fraudulent use of vouchers, promotional codes, reselling exam discounts and vouchers, cheating on an exam, alteration of score reports, alteration of completion certificates, violation of exam retake policies or other activities deemed fraudulent by Oracle.
If Oracle determines, in its sole discretion, that fraudulent activity has taken place, it reserves the right to take action up to and including, but not limited to, decertification of a candidate’s Oracle Certified Associate, Oracle Certified Professional and/or OCM credentials, temporary, indefinite or permanent ban of a candidate from Oracle certification programs, notification to a candidate’s employer, and notification to law enforcement agencies. Candidates found committing fraudulent activities forfeit all fees previously paid to Oracle, or to Oracle’s authorized vendors, and may be required to pay additional fees for services rendered.
View the Oracle Certification Program Candidate Agreement which requires your agreement before the start of each exam.
Recommended Training about 1z0-030 exam PDF
The following courses are the recommended training for 1z0-030 exam PDF.
1z0-030 Q & A with Explanations
1z0-030 Audio Exam
1z0-030 Study Guide
1z0-030 Preparation Lab
1z0-030 Exam: Freetestking’s orcacle9i database:new features for administrators PDF
The orcacle9i database:new features for administrators PDF for preparing for the 1z0-030 exam – Freetestking’s orcacle9i database:new features for administrators. Freetestking is your premier source for practice tests, and true testing environment. Nothing will prepare you for your next exam like a Freetestking. You find it all here at certbible.org.
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
TK
1Z0-030
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. B. The statement will fail because no values are supplied for REGION_SOUTH_EAST partition keys.
C. The REGION_SOUTH_EAST partition will contain only rows with a NULL
value in the current REGION_EAST partition.
D. The REGION_SOUTH_EAST partition will be created with storage characteristics inherited from the LOCATIONS table.
E. Rows with partitioning keys in the current REGION_EAST partition not included
in the VALUES clause will be stored in the REGION_SOUTH_EAST partition. Answer: E
Explanation:
If you are splitting a partition, the list of values in the VALUES clause applies to the first partition defined. All the remaining states not included in the VALUES clause will be included in a new partition called REGION_SOUTH_EAST.
Incorrect Answers
A: The REGION_SOUTH_EAST partition will stay in the same tablespace where REGION_EAST partition is located. Only the REGION_NORTH_EAST partition will be created in the TBS2 tablespace.
B: The statement will not fail. The REGION_SOUTH_EAST partition will keep all values of REGION_EAST partition not included into the REGION_NORTH_EAST partition.
C: The REGION_SOUTH_EAST partition will keep all values of REGION_EAST
TK
1Z0-030
partition not included into the REGION_NORTH_EAST partition, but it will not
store rows with a NULL value in the current REGION_EAST partition..
D: The REGION_SOUTH_EAST partition will not use the storage characteristics inherited from the LOCATIONS table.
OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 134-136
Chapter 3: Manageability Enhancements
Oracle 9i New Features, Robert Freeman, p. 102-108
Chapter 4: New Oracle9i Database DDS and Data-Warehouse Features
QUESTION 3:
What criterion does Oracle9i use to determine whether a database file is an Oracle
Managed File?
A. The filename format
B. Information stored inside a data dictionary table
C. Information stored in the ALERT.LOG file for the corresponding instance
D. Information stored inside the corresponding initialization parameter file for the instance
Answer: A Explanation:
Oracle will use naming conventions when it creates the OMF files. In this naming convention, %t represents the tablespace name, %u is a unique 8-character string, and %g stands for the redo log group number.
Incorrect Answers
B: Oracle will create a locally managed tablespaces, so information about a datafile will not be stored inside a data dictionary table.
C: Oracle does not use ALERT.LOG file to store information about datafiles. It just keep log of database events and database structure changes.
D: Initialization parameter file will not be used to store this information. Oracle reads this file to set initialization parameters to start the instance. The structure of the
database is stored inside control files. Oracle uses them to mount and open the database.
OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 153-160
Chapter 3: Manageability Enhancements
Oracle 9i New Features, Robert Freeman, p. 2-12
Chapter 1: Oracle9i Database Administration and Management Features
QUESTION 4:
Oracle9i extends the cursor sharing functionality with the new value of SIMILAR
for the CURSOR_SHARING parameter. With CURSOR_SHARING = SIMILAR, cursors are shared for safe literals only. What is meant by ’safe literals only’?
Interactive Testing 1z0-030 Engine Included!
134 Questions
Updated : 09/18/2008
Price : $87.99 $79.99
Exam Number/Code:1z0-030
Exam Name: orcacle9i database:new features for administrators
Testking 1z0-030 Exam will provide you with exam simulation questions and actual answers that reflect the actual exam
Preparing for the Testking 1z0-030 exam?Searching 1z0-030 Test Questions,
1z0-030 Practice Exam,1z0-030 Braindumps ? 1z0-030 practice exam covers all the practice test objectives to pass 1z0-030 exam.
Pass your exam at first attempt with our Testking 1z0-030 study guide,1z0-030 Braindumps, As well Audio exam, Realistic Practice Labs, and Interactive Testing Engine.
Our Testking practice test covers the information associated with each 1z0-030 exam topics in details and includes information found in no other practice test sites on the web.
Our challenging questions with Correct Answers built to simulate the actual exam. Unlimited, FREE auto-updates so you’re never behind on any topic. The whole package comes as an automatic download so there’s no waiting or shipping. Our most questions and answers along with explanations. Our practice test will determine you to take your 1z0-030 certification exam and pass the official exam on your first try, guaranteed
Now guaranteed Testking 1z0-030 exam training is available in various formats to best suit your needs and learning style. Whether you are a hands-on tactile learner, visually or even a textbook training veteran, Real-Exams has the 1z0-030 pdf vce format resources that will enable you to pass your 1z0-030 test with flying colors.
Comprehensive questions with complete explanations about actualtests 1z0-030 exam
download 1z0-030 exam questions accompanied by exhibits
Verified Answers Researched by Industry Experts and almost 100% correct
1z0-030 exam questions updated on regular basis
Oracle 1z0-030 Transcender Torrent
Oracle 1z0-030 P4S
Oracle 1z0-030 Study Guide
Oracle 1z0-030 Exams
Oracle 1z0-030 Braindumps
Oracle 1z0-030 Pass4sure
Oracle 1z0-030 Real Exams
Oracle 1z0-030 Exam
Oracle 1z0-030 Actual Tests
Oracle 1z0-030 Pdf
1z0-030 also gives new editions of Real Exams 1z0-030 for enhancing professional skills and knowledge. These Testking Real Practice Questions 000-710 are useful for understanding 1z0-030 exam terminologies and these brain dumps also very useful for enhancing people brain power. These Testking Real Practice Questions 1z0-030 are prepare by highly qualified and 1z0-030 professionals. 1z0-030 Certification experts’ teams always try to give you real exam environment in these 4shared training materials links.
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
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.
B. The statement will fail because no values are supplied for
REGION_SOUTH_EAST partition keys.
C. The REGION_SOUTH_EAST partition will contain only rows with a NULL
value in the current REGION_EAST partition.
D. The REGION_SOUTH_EAST partition will be created with storage
characteristics inherited from the LOCATIONS table.
E. Rows with partitioning keys in the current REGION_EAST partition not included
in the VALUES clause will be stored in the REGION_SOUTH_EAST partition.
Answer: E
Explanation:
If you are splitting a partition, the list of values in the VALUES clause applies to the first
partition defined. All the remaining states not included in the VALUES clause will be
included in a new partition called REGION_SOUTH_EAST.
Incorrect Answers
A: The REGION_SOUTH_EAST partition will stay in the same tablespace where
REGION_EAST partition is located. Only the REGION_NORTH_EAST partition
will be created in the TBS2 tablespace.
B: The statement will not fail. The REGION_SOUTH_EAST partition will keep all
values of REGION_EAST partition not included into the REGION_NORTH_EAST
partition.
C: The REGION_SOUTH_EAST partition will keep all values of REGION_EAST
partition not included into the REGION_NORTH_EAST partition, but it will not
store rows with a NULL value in the current REGION_EAST partition..
D: The REGION_SOUTH_EAST partition will not use the storage characteristics
inherited from the LOCATIONS table.
OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 134-136
Chapter 3: Manageability Enhancements
Oracle 9i New Features, Robert Freeman, p. 102-108
Chapter 4: New Oracle9i Database DDS and Data-Warehouse Features
QUESTION 3:
What criterion does Oracle9i use to determine whether a database file is an Oracle
Managed File?
A. The filename format
B. Information stored inside a data dictionary table
C. Information stored in the ALERT.LOG file for the corresponding instance
D. Information stored inside the corresponding initialization parameter file for the
instance
Answer: A
Testking 1z0-030
TK Questions&Answers(Q & As with Expert Explanations): 138 Q&A
Update:13/11/2008
Free Down: Testking 1z0-030
Free Down: Pass4sure 1z0-030
Dowload PassGuide Practice Test Questions
6 Comments on “testking oracle 9i 1z0-030”