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
