单项选择题

A.Temporary tables B.Index-organized tables C.Cluster t……

The rows inside three Oracle tables supporting a customer order entry system are frequently accessed together by means of a table join. Because data is always being added to the tables, you leave a lot of extra space inside each block to accommodate growth. Which of the following types of tables would be useful for storing the data in this context?（）

A.Temporary tables
B.Index-organized tables
C.Cluster tables
D.Standard Oracle tables

<上一题目录下一题>

热门试题

单项选择题AtablewasjustcreatedonyourOracledatabasewithsixextentsallocatedtoit.Whichofthefollowingfactorsmostlikelycausedthetabletohavesomanyextentsallocated?（）

A.The value for MINEXTENTS setting
B.The value for PCTINCREASE setting
C.The value for MAXEXTENTS setting
D.By default, Oracle allocates six extents to all database objects

单项选择题YouarecreatingtablespacesinOracle.Whichofthefollowingkeywordsorclausespermitsthedatafilesofadatabasetogrowautomaticallyinordertoaccommodatedatagrowth?（）

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