单项选择题

A.One tablespace has only one datafileB.Many tablespace……

You are designing the physical database layout on your host machine. What is the relationship between tablespaces and datafiles in the Oracle database?（）

A.One tablespace has only one datafile
B.Many tablespaces can share one datafile
C.One tablespace can have many datafiles
D.One datafile can contain many tablespaces

<上一题目录下一题>

热门试题

单项选择题Duringregulardatabaseoperation,whichbackgroundprocesswilltakesmallerblocksoffreespaceinadictionary-managedtablespaceandmovethingsaroundtomakebiggerpiecesoffreespace?（）

A.DBW0
B.LGWR
C.ARCH
D.SMON
E.PMON

单项选择题Youareconfiguringyourindextobestoredinatablespace.WhichofthefollowingstorageparametersareNOTappropriateforindexes?（）

A.OPTIMAL
B.INITIAL
C.PCTINCREASE
D.NEXT

单项选择题ouareimplementingcontrolfilemultiplexing.WhichofthefollowingchoicesidentifiesthemethodyoucanuseinordertogeneratethecontrolfilecopiesthatOraclewillmaintain?（）

A.Issue ALTER DATABASE BACKUP CONTROLFILE TO filename
B.Make a copy of the control file with the database shut down
C.Issue ALTER DATABASE BACKUP CONTROLFILE TO trace
D.Make a copy of the control file with the database still running

单项选择题YouareidentifyingdictionaryobjectsintheOracledatabase.Whichofthefollowingisaviewinthedatadictionary?（）

A.V$DATABASE
B.DBA_TABLES
C.SYSAUD$
D.EMP

单项选择题YouareabouttocreateyourOracledatadictionaryforusewiththedatabase.WhichofthefollowinguserswouldyouconnecttothedatabaseasforthispurposeinOracle9iandlaterreleases?（）

A.SYSTEM
B.OUTLN
C.INTERNAL
D.SYS