12.5
13
14
14.5
第1题:
There used to be an old city here, which was ()under the river about 2000 years ago.
A、insulted
B、insulated
C、buried
D、interrupted
第2题:
The manager is 40 years old,(用how old对划线部分提问)
第3题:
YousettheundopoolresourceplandirectivefortheconsumergroupnamedDSS_USERSthatisassignedtotheDAY_SHIFTplan.Thedatabaseusers,SCOTTandBLAKE,belongtotheDSS_USERSresourcegroup.Theuser,SCOTT,initiatesadatabasesessionandexecutesabatchoperationthatinsertsmillionsofrowsintotheHISTORYtable.WhichtwooptionsaretrueifthetotalundospaceallocatedtotheDSS_USERSgroupexceedsthevaluespecifiedintheundopoolresourceplandirective?()
A.Thebatchoperationstartedbytheuser,SCOTT,terminateswithanerror.
B.Thebatchoperationstartedbytheuser,SCOTT,hangsandyouarerequiredtoincreasetheundopoolresourceplandirective.
C.Thebatchoperationstartedbytheuser,SCOTT,runsuninterruptedbecausethedatabaseusestheSYSTEMtablespacefortheundooperation.
D.Theuser,BLAKE,cannotstartatransactionthatusesanyDMLoperationsuntilyouincreasethevalueoftheundopoolresourceplandirective.
E.TheuserBLAKEcanstartatransactionthatusesanyDMLoperationsafterthebatchoperationstartedbytheuser,SCOTT,terminateswithanerror.
第4题:
No one can expect to fully enjoy the adulthood privileges until he is ________.
[A] eleven years old
[B] sixteen years old
[C] twenty-one years old
[D] between twelve and twenty-one years old
第5题:
授予sa用户在SCOTT.EMP表中SAL列的更新权限的语句是()。
第6题:
The user SCOTT executes the following command successfully to increase the salary values in one of his sessions: SQL> UPDATE emp SET sal=sal*1.15 WHERE deptno=20; Before SCOTT ends the transaction, user HR who has the privileges on EMP table executes a query to fetch the salary details but finds the old salary values instead of the increased values. Why does HR still see the old data?()
第7题:
spend
spending
spent
spends
第8题:
The user, Scott, is dropped, all the objects in Scott’s schema are placed in the Recycle Bin, and the objects that are already in the Recycle Bin are dropped.
The user, Scott, is dropped, all the objects in Scott’s schema are placed in the Recycle Bin, and all the objects in the Recycle Bin, belonging to the user Scott, are not dropped.
The user, Scott, is dropped, all the objects in the Scott’s schema are not placed in the Recycle Bin, and the objects in the Recycle Bin, belonging to the user, Scott, are not dropped.
The user, Scott, is dropped, all the objects in Scott’s schema are not placed in the Recycle Bin, and the objects in the Recycle Bin are dropped.
第9题:
第10题:
GRANT CHANGE ON SCOTT.EMP TO SA
GRANT UPDATE ON SCOTT.EMP(SAL) TO SA
GRANT UPDATE (SAL) ON SCOTT.EMP TO SA
GRANT MODIFY ON SCOTT.EMP(SAL) TO SA
第11题:
12.5
13
14
14.5
第12题:
because of redo data from redo log file
because of data from database buffer cache
because of data from a temporary tablespace
because of undo data from the undo tablespace
第13题:
A.Right
B.Wrong
第14题:
He is_______ than I.
A.elder three years
B.old three years
C.three years elder
D.three years older
第15题:
A.GRANT CHANGE ON SCOTT.EMP TO SA
B.GRANT UPDATE ON SCOTT.EMP(SAL) TO SA
C.GRANT UPDATE (SAL) ON SCOTT.EMP TO SA
D.GRANT MODIFY ON SCOTT.EMP(SAL) TO SA
第16题:
Our factory is much more productive now. This year’s production is five times as much () it was ten years ago.
第17题:
What will be the result of using the SQL> DROP USER SCOTT CASCADE; command?()
第18题:
第19题:
第20题:
by using the DBMS_SESSION package
by granting the DBA role
by using the DBMS_RESOURCE_MANAGER package
by using the DBMS_RESOURCE_MANAGER_PRIVS package
第21题:
All the objects of scott are moved to the Recycle Bin.
Any objects in the Recycle Bin belonging to scott are purged.
All the objects owned by scott are permanently dropped from the database.
All the objects of scott in the Recycle Bin must be purged before executing the DROP command.
Any objects in the Recycle Bin belonging to scott will not be affected by the above DROP command.
第22题:
第23题:
第24题: