1Z0-023 考试回忆 11.20

>　　WHERE username= 慗ERRY?
　　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 憄eter?
　　
　　CREATE USER peter
　　IDENTIFIED by pan
　　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 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.
　　
　　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. fi

上一页  [1] [2] [3] [4] [5] 下一页