A.SYSTEM B.OUTLN C.INTERNAL D.SYS
单项选择题YouareusingtheDatabaseConfigurationAssistanttoconfigureyourOracledatabase.Whichofthefollowingtermspertainstothecreationofanobjectfromwhichcreationoftheotherdatabasecanbebased?()
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