Please find below some questions that I encountered in my IZ0-023 exam. I didn't score highly so please
check the answers. I used Sybex and STS to prepare for the exam; these cover about 50% of real exam questions (only similar). Despite this, Sybex
book for IZ0-023 is indeed good for beginners like me. Anyway, a pass is a pass. Next : 024 or 025.

Good luck to you all,
Hoi -
HK
(CCNA/DA,CNE,MCSD/DBA/SE/SA)

P.S. BTW, dumps here for IZ0-001 are really good. Please be comfortable to use them for passing IZ0-001.

-------------------------------------------------


Which two data dictionary views show the number of extents of a certain segment? (Choose two.)
A. V$EXTENTS
B. DBA_EXTENTS
C.
DBA_SEGMENTS
D. DBA_TABLESPACES

ANS: B, C (not sure)

Which three things can the ALTER INDEX REBUILD command accomplish? (Choose three.)
A.
convert a bitmap index to a B-tree index
B. move the index to a different tablespace
C. change the storage parameters for the index
D. rebuild
a reverse index from an existing B-tree index

ANS: B, C, D

Which type of index should be created to spread the distribution of index updates
across the index tree?
A. B-tree indexes
B. bitmap indexes
C. reverse-key indexes
D. function-based indexes

ANS: C

Which view displays
the NLS initialization parameters that have been explicitly set?
A. NLS_SESSION_PARAMETERS
B. NLS_INSTANCE_PARAMETERS
C.
NLS_DATABASE_PARAMETERS
D. V$NLS_INSTANCE_PARAMETERS

ANS: B

How can you declare the national character set and the database character
set?
A. by creating the database
B. by installing the Oracle software
C. by setting the initialization parameter CHARACTER_SET
D. by setting
the environment variable DB_CHARACTER_SET

ANS: A

Which two conventions are defines by the initialization parameter NLS_LANGUAGE?
A. default
date format
B. local currency symbol
C. ISO week number calculation
D. default sorting sequence of character data
E. language used for day and
month names and their abbravations

ANS: D, E

How do you increse the number of entries in the password file?
A. grant SYSDBA or SYSOPER to
addtional users
B. overwrite the number of entries by using the orapwd utility
C. delete the existing password file and recreate it with the
desired number of entries
D. increase the value of REMOTE_LOGIN_PASSWORD_ENTRIES to the desired number of entries

ANS: C

You issue the
following command:
orapwd file=orapwORCL password=secure entries=5
What is the effect?
A. A new password file is created.
B. An existing
password file is updated.
C. All users are removed from the password file.
D. The passwords in the password file are reset.

ANS: A

A
transaction fails and returns an ORA-01562 indicating that there is insufficient space in the rollback segment. What are two possible causes?
(Choose two.)
A. There are no rollback segments online.
B. There is no room in the tablespace for the rollback segment to extend .
C. MAXEXTENTS
has been reached, preventing the segment from extending.
D. The maximum number of users per rollback segment has been exceeded.

ANS: B,
C

MINEXTENTS must be at least ___ when a rollback segment is created.
A. 1
B. 2
C. 3
D. 5

ANS: B

Acme Company has 32 employees who
routinely access an Oracle database. On the average, each user has one active transaction at any time of the day. The DBS is attemping to create the
ideal number of rollback segments for this OLTP environment. The users work in a typical OLTP environment. How many rollback segments should the DBA
create?
A. one per user
B. one per transaction
C. 16 rollback segments
D. four rollback segments
E. eight rollback segments

ANS: E (not
sure)

What is the primary function of the redo log?
A. to provide read consistency
B. to record all changes made to data
C. to roll back
uncommited transactions
D. to update datafiles of uncommitted transactions

ANS: B

Which SQL command forces a log switch and caused a
checkpoint to occur?
A. ALTER SYSTEM CHECKPOINT
B. ALTER DATABASE CHECKPOINT
C. ALTER SYSTEM SWITCH LOGFILE
D. ALTER DATABASE SWITCH
LOGFILE
ANS: C

A DBA enters the command:
ALTER DATABASE ADD LOGFILE MEMBER
'/u01/oracle/dbs/log1b.rdo' TO GROUP
1,
'/u02/oracle/dbs/log2b.rdo' TO GROUP 2;
How does Oracle size the new redo logs?
A. It sizes them at five times the database block size.
B.
It uses the size of the current members in group 1 and group 2.
C. It uses the default size specified during the CREATE DATABASE command.
D. It
uses the size of the files log1b.rdo and log2b.rdo, that already exist.

ANS: B

All members of the current online redo log group are not
available. Which action does Oracle take?
A. The instance crashes.
B. The instance writes to the next online redo log group.
C. The instance
hangs until the DBA switches the redo log file.
D. The instance hangs until the DBA restarts the archive process.

ANS: A (not sure)

Which two
dynamic performance viewa could you query to display the number of online redo log groups and the current log group? (Choose two.)
A. V$LOG
B.
V$THREAD
C. V$SESSION
D. V$ARCHIVE
E. V$INSTANCE
ANS: A, B (not sure)

Which two actions can be used to multiplex the control file? (Choose
two.)
A. copy the control file when the database is open
B. copy the control when the database is shut down
C. add a control file with the
CREATE CONTROLFILE command
D. list multiple control files in the parameter file during database creation

ANS: B, D

What are two
characteristics of the control file? (Choose two.)
A. It has a fixed size.
B. It should the multiplexed.
C. It can be edited by the DBA.
D. It
is required to start the instance.
E. It is required to open the database.
F. It is associated with multiple databases.

ANS: B, E

---