单项选择题

A.INSERT B.SELECT C.UPDATE D.DELETEWhichofthefollowingo……

Which of the following operations does not require Oracle to store information in an UNDO segments as part of the transaction?（）

A.INSERT
B.SELECT
C.UPDATE
D.DELETE

<上一题目录下一题>

热门试题

单项选择题Toallocateanotherroletoauser,whichcommandismostappropriate?（）

A.ALTER USER
B.ALTER DATABASE
C.ALTER SYSTEM
D.GRANT

单项选择题Youareattemptingtoclearanunarchivedredologfile.Inordertomanuallyenactalogswitch,whichofthefollowingstatementsisappropriate?（）

A.ALTER DATABASE
B.ALTER SYSTEM
C.ALTER USER
D.ALTER REDO LOG

单项选择题YouareanalyzingthecomponentsoftheredologmechanismsinyourOracledatabase.WhichofthefollowingpurposesdoestheCKPTprocessserve?（）

A.Writes buffers to disk
B.Writes current redo log number to datafile headers
C.Writes redo log information to disk
D.Reads information into memory for users

单项选择题TheDBAisdefiningroleforusers.Whichofthefollowingisnotanacceptablemethodfordefiningadefaultrole?（）

A.ALTER USER DEFAULT ROLE ALL
B.ALTER USER DEFAULT ROLE ALL EXCEPT ROLE_1
C.ALTER USER DEFAULT ROLE NONE
D.ALTER USER DEFAULT ROLE NONE EXCEPT ROLE_1

单项选择题YouaredefiningareasonyourOracledatabase.Whichofthefollowingprofileareascanbeusedtocontroltheresourceusagefortheotherfour?（）

A.LOGICAL_READS_PER_SESSION
B.CONNECT_TIME
C.COMPOSITE_LIMIT
D.CPU_PER_SESSION
E.PRIVATE_SGA