testking oracle 9i 1z0-023
Visited 702 times, 1 so far today
orcacle9l database:fundamentals ii : 1z0-023 Exam
Pass-Guaranteed is the leader in IT Certifications that will Guarantee you will pass your 1Z0-023 exam on Your First Try. We have provided a free 1Z0-023 free exam where you will be able to see the quality that goes into our 1Z0-023 test questions. Our 1Z0-023 practice test questions are designed by highly experienced and certified trainer’s that have put together the best 1Z0-023 exam questions that will Guarantee success on your 1Z0-023 exam. Please feel free to download our 1Z0-023 free practice exam. You will notice that our 1Z0-023 test questions are very well written and is the key in Passing Your 1Z0-023 exam on Your First Try, or Your Money Back!!! Pass-Guaranteed offers 24/7 live chat support to our customer’s along with free live chat tutoring with the purchase of our 1Z0-023 exam. Pass-Guaranteed 1Z0-023 study guide will introduce you to the core logic of various subjects so that you not only learn, but you also understand various technologies and subjects. We guarantee that using our 1Z0-023 practice test will adequately prepare you for your 1Z0-023 exam, and set you up to pass your 1Z0-023 exam the First Time. Pass-Guaranteed 1Z0-023 exam questions are comprehensive, yet affordable. We are aware that a major problem in the IT industry is a lack of quality 1Z0-023 study guides. Pass-Guaranteed 1Z0-023 exam test questions provides you everything you will need to take the 1Z0-023 exam. Pass-Guaranteed 1Z0-023 test questions have comprehensive questions, with verified answers researched by industry experts!!! Still not convinced? Try our 1Z0-023 free exam sample or choose to buy the 1Z0-023 practice exam Now!!! Pass-Guaranteed Or Your Money Back!!! Pass-Guaranteed.com’s 1Z0-023 Practice Test Questions will help you prepare for your 1Z0-023 exam. Pass-Guaranteed.com Guarantee’s this, or Your Money Back!!!
Product Description
Exam Number/Code: 1z0-023
Exam Name:orcacle9l database:fundamentals ii
“orcacle9l database:fundamentals ii”, also known as 1z0-023 exam, is a Oracle certification. With the complete collection of questions and answers, Pass4sure has assembled to take you through 126 Q&A to your 1z0-023 Exam preparation. In the 1z0-023 exam resources, you will cover every field and category in 9i DBA helping to ready you for your successful Oracle Certification.
QUESTION 1:
What is one reason for using the package DBMS_TTS? DATA01 has
A. To verify that a tablespace is self-contained.
B. To drop indexes outside a transportable tablespace.
C. To create the metadata for a transportable tablespace.
D. To attach transportable tablespaces datafiles to the database.
Answer: A Explanation:
Answer A is correct. You need to use the package DBMS_TTS to check that a tablespace is self-contained.
Incorrect Answers:
B: You don’t need to drop indexes outside a transportable tablespace, the DBMS_TTS package
is not used for this purpose either.
C: To create metadata for a transportable tablespace use TRANSPORT_TABLESPACE export parameter.
D: This package is not used to attach transportable tablespaces datafiles to the database. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 1146
Chapter 24: Oracle8i New Features Topics
QUESTION 2:
Which export option will generate code to create an initial extent that is equal to the sum of the sizes of all the extents currently allocated to an object?
A. FULL
B. DIRECT
C. COMPACT D. COMPRESS
Answer: D Explanation:
Answer D is correct because parameter COMPRESS=Y indicates whether EXPORT will place
all rows of the table into one initial extent in the export file. This is useful for reducing fragmentation, but you may allocate too much space if your table has a lots of deleted rows. It is important to note here that Oracle does not actually reduce space use; it merely recalculates the existing data so that it fits into one big initial segment, which can still cause space problems
later.
Incorrect Answers:
TK
1Z0-023
A: Parameter FULL=Y indicates whether EXPORT should export the entire database.
B. Parameter DIRECT=Y allows user to run faster exports using the direct path. This is similar
in function to direct-path loading in SQL*Loader. C: Parameter COMPACT does not exist.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 534-536
Chapter 1: Selecting Data from Oracle
QUESTION 3:
What are two reasons for changing user quotas on a tablespace? (Choose two) A. A datafile becomes full.
B. A user encounters slow response time from the application.
C. Tables owned by a user exhibit rapid and anticipated growth.
D. Database objects are reorganized and placed in different tablespace. Answer: C, D
Explanation:
Answers A and C are correct because a quota is a limit on the amount of space the user’s
database objects can occupy within the tablespace. If a user attempts to create a database object that exceeds that user’s quota for that tablespace, then the object creation script will fail. A quota
clause should be issued separately for every tablespace other than the temporary tablespace on which the user will have access to create database objects. Users need quotas on tablespaces to create database objects only. They do not need a quota on a tablespace to UPDATE, INSERT, or DELETE data in an existing object in the tablespace, so long as they do have the appropriate privilege on the object for data being inserted, updated or deleted.
Incorrect Answers:
A: User quota on a tablespace have nothing to do with a datafile which becomes full, because tablespace is a logical object, but datafile is physical object and you can not control datafile growth with tablespace quota.
B: Slow response time from the application is not related with user quotas on a tablespace, it depends on performance problems.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 466
Chapter 10: Managing Database Use
QUESTION 4:
A DBA performs the query:
SELECT tablespace_name, max_blocksFROM dba_tablespace_quotasWHERE username=
“SCOTT;
That returns the result: TABLESPACE_NAME MAX_BLOCKS
—————————— ——————
TK
1Z0-023
DATA01 -1
What does -1 indicate?
A. Tablespace DATA01 has been dropped. B. Tablespace DATA01 has no free space.
C. The user has no quotas on tablespace DATA01.
D. The user has an unlimited quota on tablespace DATA01.
E. The user has exceeded his or her quota on the tablespace DATA01. Answer: D
Explanation:
Answer D is correct. A value -1 in the MAX_BLOCKS column of the DBA_TABLESPACE_QUOTAS view means that the user has unlimited space quota for that tablespace. View DBA_TABLESPACE_QUOTAS names all users and any tablespace quotas that have been created for them.
Incorrect Answers:
A: If tablespace DATA01 has been dropped it will not be shown in
DBA_TABLESPACES_QUOTAS view.
B: To check free space inside tablespace use DBA_FREE_SPACE view. This view identifies the location and amount of free space, by tablespace name, file ID, starting block ID, bytes, and
blocks. Or DBA_FREE_SPACE_COALESCED can be used to identify the location of free
space in a tablespace that has been coalesced, by tablespace name and some other information.
C: If user has no quota on tablespace MAX_BLOCKS will be equal 0. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 471
Chapter 10: Managing Database Use
QUESTION 5:
Consider the following command to create the user ‘peter’. CREATE USER peter
IDENTIFIED by panTEMPORARY TABLESPACE temp
PASSWORD EXPIRE;
Since no default tablespace was specified, what will happen if this command executed?
A. The user will not have a home directory.
B. The user peter will be created using the TEMP tablespace as the default.
C. The user peter will be created using the SYSTEM tablespace as the default. D.the code will produce an error message; the user peter will not be created.
Answer: C Explanation:
Answer C is correct. Tablespace management is a crucial task in Oracle. The DEFAULT TABLESPACE names the location where the user’s database objects are created by default. This
TK
1Z0-023
clause plays an important role in protecting the integrity of the SYSTEM tablespace. If no
DEFAULT TABLESPACE is named for a user, objects that the user creates may be placed in
the SYSTEM tablespace. Recall that SYSTEM contains many database objects, such as the data dictionary and the SYSTEM rollback segment, that are critical to database use. Users should not
be allowed to create their database objects in the SYSTEM tablespace. Incorrect Answers:
A: There is no home directory for users in Oracle.
B: The user peter will be created with SYSTEM tablespace as the default and TEMP tablespace
as the temporary tablespace.
D: The code above is correct, user peter will be successfully created. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 466
Chapter 10: Managing Database Use
QUESTION 6:
An oracle user receives the following error: ORA-01555 SNAPSHOP TOO OLD
What are two possible solutions? (Choose two)
A. Increase the extent size of the rollback segments. B. Perform media recovery.
C. Increase the number of rollback segments.
D. Increase the size of the rollback segment tablespace. E. Increase he value of OPTIMAL storage parameter.
Answer: A, E Explanation:
Answers A and E are correct. Recall that rollback segments allow transaction-level read
consistency for all statements running on the database. A long-running query in one session that starts before a change on that data is committed by another session will see the data as it existed pre-commit. I Oracle can not provide a read-consistent view of data, the following error will
ensure “ORA-01555 – snapshot too old (rollback segment too small)” error. The solution to this problem is to recreate the rollback segment with a higher minimum number of extents, larger extents, or a higher OPTIMAL rollback segment size. You cannot simply increase MAXEXTENTS to resolve this problem.
Incorrect Answers:
B: Media recovery does not need to be performed because there is no media failure when this error happened.
C: Problem with this error can be fixed with a higher minimum number of extents for the rollback segment, not with a higher number of rollback segments.
D: Problem with this error can be fixed with larger extents for the rollback segment, not with larger size of rollback segments tablespace.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 381
Chapter 8: Managing Database Objects
Interactive Testing 1z0-023 Engine Included!
151 Questions
Updated : 09/18/2008
Price : $87.99 $79.99
Free download?testking oracle 9i 1z0-023
Free download?pass4sure oracle 9i 1z0-023
Dowload PassGuide Practice Test Questions
5 Comments on “testking oracle 9i 1z0-023”