单项选择题

YouissuethefollowingcommandinOracle:CREATETABLESPACEDAT……

You issue the following command in Oracle: CREATE TABLESPACE DAT_TBS DATAFILE "dat_tbs.dbf" SIZE 2M;. Later queries against the database reveal that the tablespace is located in the /u01/oradata/oracle directory. Which of the following choices identifies how Oracle likely determined what directory to place dat_tbs.dbf file in?（）

A.DB_CREATE_FILE_DEST
B.DB_CREATE_ONLINE_LOG_1
C.DB_CREATE_ONLINE_LOG_2
D.The directory is an operating system-specific default value in Oracle that can neigher be specified manually nor changed

<上一题目录下一题>

热门试题

单项选择题YouaremanagingtheOracledatabase.WhichofthefollowingchoicescorrectlyidentifieswhenOraclereadsthecontentsoftheinit.orafile?（）

A.When the instance is started
B.When the database is mounted
C.When the database is opened
D.When the database is closed

单项选择题AuserissuesaSELECTcommandagainsttheOracledatabase.WhichofthefollowingchoicesdescribesastepthatOraclewillexecuteinsupportofthisstatement?（）

A.Acquire locks on table queried
B.Generate redo for statement
C.Fetch data from disk into memory
D.Write changes to disk

单项选择题Youhavealong-runningprocessyouwanttoassigntoaspecificUNDOsegmentbroughtonlineforthatexpresspurpose.YouarenotusingautomaticUNDOmanagement.Whatstatementcanbeusedforthistask?（）

A.ALTER DATABASE
B.SET TRANSACTION
C.ALTER ROLLBACK SEGMENT
D.ALTER TABLE

单项选择题Whichofthefollowingchoicescorrectlydescribesthedifferencebetweenadataloadviatheconventionalpathandthedirectpath?（）

A.One runs faster than the other
B.A conventional path data load bypasses most of the Oracle RDBMS, whereas a direct path load is a high-speed version of the SQL INSERT
C.A direct path data load bypasses most of the Oracle RDBMS, whereas a conventional path load is a high-speed version of the SQL INSERT
D.The conventional path runs when the CONVENTIONAL command-line parameter is set to TRUE

单项选择题Recordsfromthedatadictionaryinformationarestoredinwhichofthefollowingdatabasememoryareas?（）

A.Library cache
B.Row cache
C.Session UGA
D.Buffer cache