|
Home > Archive > Oracle certifications > October 2001 > 1z0-023
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
|
| Free demo-questions for 1z0-023
(these questions are free, no problems
with copyrights, this is not a braindump,
these questions are not actual questions)
6. An Oracle user receives the following error: ORA-01555 SNAPSHOP TOO OLD
What are two possible solutions?
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 the value of the OPTIMAL storage parameter.
7. When creating rollback segments, what is the recommended value for the MINEXTENT minimize dynamic extension?
A. 15
B. 20
C. five
D. ten per transaction
E. number_of_users*25
8. MINEXTENTS must be at least _____ when a rollback segment is created.
A. 1
B. 2
C. 3
D. 5
1. Which of the following is one reason for using the package, DBMS_TTS?
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.
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
3. What are two reasons for changing user quotas on a tablespace?
A. A datafile becomes full.
B. A user encounters slow response time from the application.
C. Tables owned by a user exhibit rapid and unanticipated growth.
D. Database objects are reorganized and placed in different tablespace.
4. A DBA performs the query:
SELECT tablespace_name, max_blocks
FROM dba_tablespace_quotas
WHERE username = monster
That returns the result:
TABLESPACE_NAME MAX_BYTES
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.
5. Consider the following command to create the user cookie?
CREATE USER cookie
IDENTIFIED by monster
TEMPORARY TABLESPACE temp
PASSWORD EXPIRE;
Since no default tablespace was specified, what will happen if this command is executed?
A. The user will not own a home directory.
B. The user cookie will be created using the TEMP tablespace as the default.
C. The user cookie will be created using the SYSTEM tablespace as the default.
D. The code will produce an error message, the user cookie will not be created.
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 director location of the NLS support files?
A. NLS_LANG
B. ORA_NLS33
C. ORACLE_SID
D. ORACLE_BASE
E. ORACLE_HOME
10. Given the statement:
CREATE DATABASE orc1
LOGFILE GROUP 1 /Oracle/dba/logla.rdo?SITE DM
GROUP 2 /Oracle/dba/logla.rdo?SITE DM
DATAFILE /Oracle/dbs/sys_01.dbf?REUSE;
Which statement is true?
A. The online redo logs will be multiplexed.
B. The file /Oracle/dbs/sys_01.dbf?already exists.
C. File /Oracle/dbs/sys_01.dbf?as a parameter file.
D. The control file name is /Oracle/dbs/sys_01.dbf?
E. Oracle will determine the optimum size for /Oracle/dba/sys_01.dbf?
11. What is a default role?
A. A role that requires a password.
B. A role that requires no password.
C. A role automatically enabled when the user logs on.
D. A role automatically assigned when the user is created.
12. Who is the owner of a role?
A. SYS
B. Nobody
C. SYSTEM
D. The creator
13. Which class of segments is most likely to cause fragmentation in permanent tablespace?
A. Index segments.
B. Rollback segments.
C. User data segments.
D. Temporary segments.
E. Data dictionary segments.
14. Which data dictionary view shows the available free space in a certain tablespace?
A. DBA_EXTENTS
B. V$FREESPACE
C. DBA_FREE_SPACE
D. DBA_TABLESPACE
E. DBA_FREE_EXTENTS
15. Which statement about using PCTFREE and PCTUSED is true?
A. Block space utilization can be specified only at the segment level.
B. Block space utilization can be specified only in the data dictionary.
C. Block space utilization parameters can only be specified at the tablespace.
D. Block space utilization can be specified both at the tablespace level and segment level. | |
| The Maverick 2001-10-24, 7:22 am |
| 6. A & E
7. B
8. B
1. A
2. D
3. C (not sure)
4. C.
5. C
9. B
10. B
11. D
12. B
13. D
14. C
15. D
Good luck to you! too bad most people here just wanna get study materials instead of learning something.
The Maverick |
|
|
|
|