ALTER DATABASE FLASHBACK ON;
GRANT SELECT any transaction TO scott;
GRANT EXECUTE ON dbms_flashback TO scott;
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
ALTER TABLESPACE undots1 RETENTION GUARANTEE;
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;
第1题：
A. All the objects of scott are moved to the Recycle Bin.
B. Any objects in the Recycle Bin belonging to scott are purged.
C. All the objects owned by scott are permanently dropped from the database.
D. All the objects of scott in the Recycle Bin must be purged before executing the DROP command.
E. Any objects in the Recycle Bin belonging to scott will not be affected by the above DROP command.
第2题：
在Oracle中，用ALTER将scott的口令改为hello，下列哪个是正确的？（ ）
A.ALTER USER scott IDENTIFIED BY hello
B.ALTER scott USER IDENTIFIED BY hello
C.ALTER USER scott IDENTIFIED AS hello
D.ALTER USER hello IDENTIFIED BY scott
第3题：
在Oracle中，将scott的资源文件改为otherprofile，下列哪个是正确的？（ ）
A.ALTER PROFILE USER scott otherprofile
B.ALTER otherprofile USER scottPROFILE
C.ALTER USER scott PROFILE otherprofile
D.ALTER scott USER PROFILE otherprofile
第4题：
kristin wants to build an action which exits the video form. the action will be avaiable only when the user is reading the document ,which one of the following accomplish this ? （）
第5题：
Your boss at Certkiller .com wants you to clarify Oracle 10g. Which statement regarding the usage of redo log files during instance recovery is true？（）
第6题：
A. no privileges
B. only the SELECT privilege
C. only the CONNECT privilege
D. all the privileges of a default user
第7题：
在Oracle中，将当前系统所有角色都授予scott，除Payroll外，下列哪个是正确的?()
A、ALTER DEFAULT ROLLE USER scott ALL EXCEPT Payroll
B、ALTER USER DEFAULT ROLLE ALL EXCEPT Payroll
C、ALTER DEFAULT ROLLE ALL EXCEPT USER scott
D、ALTER USER scott DEFAULT ROLLE ALL EXCEPT Payroll
第8题：
A. ALTER DATABASE FLASHBACK ON;
B. GRANT SELECT any transaction TO scott;
C. GRANT EXECUTE ON dbms_flashback TO scott;
D. ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
E. ALTER TABLESPACE undots1 RETENTION GUARANTEE;
F. ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;
第9题：
在Oracle中，将scott的缺省表空间改为data2_ts，下列哪个是正确的？（）
第10题：
An administrator received a call from a user whose PC crashed while using vi to edit a file. The user wants the edited file back. Where should the administrator look for the file（）