1Z0-023 Oracle8i: Architecture and Administration Part 1

Oracle8i: Architecture and Administration Part 1

Get Full Version on:http://www.getfreedumps.com


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.
Correct Answer: A
Section: (none)
Explanation
Explanation/Reference:
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
Correct Answer: D
Section: (none)
Explanation
Explanation/Reference:
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:
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.
Correct Answer: CD
Section: (none)
Explanation
Explanation/Reference:
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
------------------------------ ------------------
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.
Correct Answer: D
Section: (none)
Explanation
Explanation/Reference:
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.
Correct Answer: C
Section: (none)
Explanation
Explanation/Reference:
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 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

Get Full Version on:http://www.getfreedumps.com


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.
Correct Answer: AE
Section: (none)
Explanation
Explanation/Reference:
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

QUESTION 7

When creating rollback segments, what is the recommended value for MINEXTENT minimize dynamic
extension?
A. 15
B. 20
C. five
D. ten per transaction
E. number_of_users*25
Correct Answer: B
Section: (none)
Explanation
Explanation/Reference:
Explanation:
Answer B is correct. By using more extents in the initial rollback segment allocation - determined by the
MINEXTENTS storage option - you reduce the probability of your rollback segment extending. Oracle
recommends 20 (or more) extents as part of the initial rollback segment allocation.
Incorrect Answers:
A: To minimize the probability of your rollback segment extending Oracle recommends 20 or more extents for
the initial rollback segment, not 15.
C: To minimize the probability of your rollback segment extending Oracle recommends 20 or more extents for
the initial rollback segment, not 5.
D: Each transaction uses one rollback segment, not some, so this answer is completely incorrect.
E: There is the Rule of Four to plan rollback segment numbers for OLTP systems. It recommends to calculate
number of rollback segments by dividing the total number of concurrent transactions that will hit the database at
any given time by 4. This rule have nothing to do with number of users. Also question does not specify exactly
that we use OLTP system. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 373-374 Chapter
8: Managing Database Objects

QUESTION 8

MINEXTENT must be at least _____ when a rollback segment is created.
A. 1
B. 2
C. 3
D. 5
Correct Answer: B
Section: (none)
Explanation
Explanation/Reference:
Explanation:
Answer B is correct. The value for MINEXTENTS should be 2 or greater.
Incorrect Answers:
A: MINEXTENT parameter should be set to 2 or greater, not 1.
C: The question asks about MINIMUM amount of MINEXTENT, this number is 2, not 3.
D: The question asks about MINIMUM amount of MINEXTENT, this number is 2, not 5. Oracle 8, DBA
Certification Exam Guide, Jason S. Couchman, p. 375 Chapter 8: Managing Database Objects

QUESTION 9

You are creating a database with a character set other than US7ACII. Which operating system environmental
variable needs to be set to specify the directory location of the NLS support files?
A. NLS_LANG
B. ORA_NLS33
C. ORACLE_SID
D. ORACLE_BASE
E. ORACLE_HOME
Correct Answer: B
Section: (none)
Explanation
Explanation/Reference:
Explanation:
Answer B is correct. Parameter ORA_NLS33 specifies the directory location of the NLS support files.
Incorrect Answers:
A: NLS_LANG system variable indicates the language for error messages, the names of days and months, the
symbol for 12-hour time of day and calendar ara; this parameter also defines the sort mechanism Oracle will
use.
C: ORACLE_SID parameter specifies unique database name, not NLS support files directory location.
D: ORACLE_BASE parameter identifies base directory where all versions of Oracle software have been
installed.
E: ORACLE_HOME parameter identifies directory name where current version of Oracle software have been
installed.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 545-547 Chapter 11: Data Loads and
National Language Support

QUESTION 10

Given the statement:
CREATE DATABASE orc1 LOGFILE GROUP 1 'u01/oracle/dba/logla.rdo' SIZE 1M, GROUP 2 'u01/oracle/dba/
log2a.rdo' SIZE 1M
DARAFILE'u01/oracle/dbs/sys_01.dbf'REUSE;
Which statement is true?
A. The online redo logs will be multiplexed.
B. The file 'u01/oracle/dbs/sys_01.dbf' already exists.
C. File 'u01/oracle/dbs/sys_01.dbf' as a parameter file.
D. The control file name is 'u01/oracle/dbs/sys_01.dbf'.
E. Oracle will determine the optimum size for 'u01/oracle/dba/sys_01.dbf'.
Correct Answer: B
Section: (none)
Explanation
Explanation/Reference:
Explanation:
Answer B is correct. Because of using keyword REUSE the file 'u01/oracle/dbs/sys_01.dbf' have already to be
created.
Incorrect Answers:
A: This statement shows that there is one member of each group of a log files, it means there is no multiplexing
for online redo logs.
C: File 'u01/oracle/dbs/sys_01.dbf' is data file, not a parameter file.
D: File 'u01/oracle/dbs/sys_01.dbf' is data file, not a control file.
E: Oracle will not determine the optimum size for 'u01/oracle/dba/sys_01.dbf', because it will reuse existing file
without changing its size. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 293-296 Chapter 6:
Basics of the Oracle Database Architecture

Get Full Version on:http://www.getfreedumps.com

Comments

Popular posts from this blog

1z0-020 Oracle8i: New Features for Administrators Part 2

1Z0-023 Oracle8i: Architecture and Administration Part 2

1Z0-024 Oracle8i: Performance and Tuning Part 3