单项选择题

A.DEFAULT STORAGE B.EXTENT MANAGEMENT C.AUTOEXTEND D.DA……

You are creating tablespaces in Oracle. Which of the following keywords or clauses permits the datafiles of a database to grow automatically in order to accommodate data growth?（）

A.DEFAULT STORAGE
B.EXTENT MANAGEMENT
C.AUTOEXTEND
D.DATAFILE

<上一题目录下一题>

热门试题

单项选择题YouhaveimplementedOMFforredologmanagement.WhichofthefollowingchoicesreflectsalogfilenamethatmightbeemployedwhenOMFisenabled?（）

A.log01.log
B.logORCL01.log
C.1_2.logALTER ROLLBACK SEGMENT
D.ora_1_asdf1234.log

单项选择题WhichofthefollowingoperationsdoesnotrequireOracletostoreinformationinanUNDOsegmentsaspartofthetransaction?（）

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