单项选择题
Two database users, Jack and Bill, are accessing the SupportCenter STAFF table of the SupportCenter DB database. When Jack modifies a value in the table, the new value is invisible to Bill. Which is the modified value invisible to Bill?()
A.The modified data are not available on disk.
B.The modified data have been flushed out from memory.
C.The modified rows of the SupportCenter STAFF table have been locked.
D.Jack has not committed the changes after modifying the value.
E.Both users are accessing the database from two different machines.
相关考题
-
多项选择题
YouworkasadatabaseadministratorforSupportcenter.cn.YouhavesettheretentionperiodforAutomaticRepository(AWR)statisticstofourdaysandcollectionintervalto15minutes.YouwanttoviewthestatisticscollectedandstoredinAWRsnapshot.WhichtwomethodswouldyouusetoviewtheAWRstatistics?()
A.use enterprise manager
B.use DBMS_SQL package
C.use DBMS_AWR package
D.use PRVT_WORKLOAD package
E.query the AWR snapshot repository objects
F.use DBMS_WORKLOAD_REPOSITORY package -
单项选择题
YouworkasadatabaseadministratorforSupportcenter.cn.Inaproductionenvironment,userscomplainabouttheslowresponsetimewhenaccessingthedatabase.YouhavenotoptimizedthememoryusageoftheOracleinstanceandyoususpecttheproblemtobewiththememory.Towhichtypeofobjectwouldyourefertodeterminethecauseoftheslowresponse?()
A.The trace file
B.The fixed views
C.The data dictionary views
D.The operating system log fields
E.The dynamic performance views. -
单项选择题
YouworkasadatabaseadministratorforSupportcenter.cn.Thedatabaseisopen.Amediafailurehasoccurred,resultinginlossofallthecontrolfilesinyourdatabase.Whichstatementregardingthedatabaseinstanceistrueinthisscenario?()
A.The instance would hang.
B.The instance needs to be shut down.
C.The instance would be in the open state.
D.The instance would abort in such cases.
E.The instance would be in the open and invalid state.
F.The instance would in the open state, but all the background processes will be restarted.
