ve
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
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 憉1/Oracle/dba/logla.rdo?SITE DM
GROUP 2 憉01/Oracle/dba/logla.rdo?SITE DM
DATAFILE 憉01/Oracle/dbs/sys_01.dbf?REUSE;
Which statement is true?
A. The online redo logs will be multiplexed.
B. The file 憉01/Oracle/dbs/sys_01.dbf?already exists.
C. File 憉01/Oracle/dbs/sys_01.dbf?as a parameter file.
D. The control file name is 憉01/Oracle/dbs/sys_01.dbf?
E. Oracle will determine the optimum size for 憉01/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. Rollb
上一页 [1] [2] [3] [4] [5] 下一页