He can only blame himself for failing the exam. He ______ harder during the year, but he s
A.would have worked
B.should have worked
C.must work
D.ought to work
A.would have worked
B.should have worked
C.must work
D.ought to work
第1题
A.ThisoperationresetstheSCNforthedatabase.
B.Thisoperationcreatesanewincarnationofthedatabase.
C.Thisoperationmovesalltheredologfilestoadifferentlocation.
D.Thisoperationdeletestheoldredologfilesandcreatesnewredologfiles.
E.ThisoperationupdatesallcurrentdatafilesandonlineredologsandallsubsequentarchivedredologswithanewRESETLOGSSCNandtimestamp.
第2题
A. selection of SQL plan baselines
B. partitioning of tables and indexes
C. creation of index-organized tables
D. creation of bitmap, function-based, and B-tree indexes
E. optimization of materialized views for maximum query usage and fast refresh
第3题
A. Both SQL and /SQL*plus allow manipulation of values in the database.
B. /SQL* Plus recognizes SQL satement and sends them to the server; SQL is the Oracle proprietary interface for executing SQL statements.
C. /SQL* Plus language for communicating with the Oracle server to access data; SQL recognizes SQL statements and sends them to the server.
D. /SQL manipulates data and table definition in the database; /SQL* Plus does not allow manipulation of values in the database.
第4题
A.Nomoredatafilescanbeaddedtothetablespace.
B.Segmentspaceismanagedbyfreelistsinthetablespace.
C.Ausercreatedwithoutbeingassignedadefaulttablespaceusesthistablespace.
D.Thetablespacecanbedroppedwiththecurrentsettingwithsegmentspresentinit
第5题
A.backupthecontrolfiletotrace
B.bringdatabasetotheMOUNTstate
C.openaconnectiontotheRMANrecoverycatalog,whichcontainstheRMANmetadataforthetargetdatabase
D.setthedatabaseID(DBID),butonlyiftheDB_NAMEparameterassociatedwiththetargetdatabaseisuniqueintherecoverycatalog
第6题
A.Multipletransactionscanusethesameundosegment.
B.Atransactionisassignedanundosegmentwhenitisstarted.
C.Morethanonetransactioncannotsharethesameextentintheundotablespace.
D.Thetransactionsusesystemundosegmenttostoreundodataifallthesegmentsintheundotablespaceareused.
第7题
A.FlashbackDrop
B.FlashbackQuery
C.FlashbackTransactionQuery
D.FlashbackVersionsQuery
E.FlashbackTable
第8题
A.Theuserisauthenticatedbytheoperatingsystem.
B.TheobjectscreatedbytheuserareplacedintheUSERStablespace.
C.TheuserdoesnotrequirequotaontheTEMPtablespacetoperformsortoperations.
D.Theuserisforcedtochangethepasswordatthefirstlogintothedatabaseinstance.
E.Theobjectscreatedbytheuserinfutureareunlockedtobeaccessedbyalltheusersinthedatabasebydefault.
第9题
A.ThedatabaseisinNOMOUNTstate.
B.ThedatabaseisinARCHIVELOGmodeandthetablespaceisonline.
C.ThedatabaseisinARCHIVELOGmodeandthetablespaceisoffline.
D.ThedatabaseisinNOARCHIVELOGmodeandthetablespaceisonline.
E.ThedatabaseisinNOARCHIVELOGmodeandthetablespaceisoffline.
第10题
A. CREATE ROLE manager; GRANT create table, create view TO manager; GRANT manager TO BLACK, CLARK;
B. CREATE ROLE manager; GRANT create table, create voew TO manager; GRANT manager ROLE TO BLACK, CLARK;
C. GRANT manager ROLE TO BLACK, CLARK; GRANT create table, create voew TO BLACK CLARK; ***MISSING***
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!