A.Clone B.Copy C.Template D.Terminal
单项选择题YouissuethefollowingcommandinOracle:CREATETABLESPACEDAT_TBSDATAFILE dat_tbs.dbf SIZE2M;.Laterqueriesagainstthedatabaserevealthatthetablespaceislocatedinthe u01 oradata oracledirectory.WhichofthefollowingchoicesidentifieshowOraclelikelydeterminedwhatdirectorytoplacedat_tbs.dbffilein?()
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