|
|
Oracle 1z0-023: Developer/2000: Build Reports
|
#1. What is one reason for using the package DBMS_TTS?
DATA01 has
|
|
#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?
|
|
#3. What are two reasons for changing user quotas on a tablespace? (Choose two)
|
|
#4. A DBA performs the query: SELECT tablespace_name, max_blocks FROM dba_tablespace_quotas WHERE username= ''SCOTT;
That returns the result:
What does -1 indicate?
|
|
#5. Consider the following command to create the user 'peter'. CREATE USER peter IDENTIFIED BY pan TEMPORARY TABLESPACE temp PASSWORD EXPIRE;
Since no default tablespace was specified, what will happen if this command executed?
|
|
#6. An oracle user receives the following error:
ORA-01555 SNAPSHOP TOO OLD
What are two possible solutions? (Choose two)
|
|
#7. When creating rollback segments, what is the recommended value for MINEXTENT minimize dynamic extension?
|
|
#8. MINEXTENT must be at least _____ when a rollback segment is 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 directory location of the NLS support files?
|
|
#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 DATAFILE 'u01/oracle/dbs/sys_01.dbf' REUSE;
Which statement is true?
|
|
|
|
 gen. 0.222
|
Server date 18:56 13-03-2010
|
Developed by Zip © 2006
|
|
|
|
|
1z0-023 certification
1z0-023 master dump