YouareaDatabaseAdministratorwithTXGlobal.Youuseapasswordfiletoestablishremoteconnectionsto

theHRdatabaseontheserverlocatedatthehomeoffice.Currently，twoactiveremotesessionsexisttothisdatabase.ThesesessionswereestablishedusingtheSYSDBAprivilegefromtheremotemachines.Youaccidentallydeletedthepasswordfile.Whatwillbetheconsequenceofthisaction？（）

A.Boththesessionswillbekilled，andnonewsessionswillbecreatedusingtheSYSDBAorSYSOPERprivilege.

B.Boththesessionswillremainactive，butnonewsessionswillbecreatedusingtheSYSDBAorSYSOPERprivilege.

C.Boththesessionswillbekilled，butnewsessionswillbecreatedusingtheSYSDBAorSYSOPERprivilegewhenthedatabaserestarts.

D.Thedatabasewillcrash，andnonewsessionswillbecreatedusingtheSYSDBAorSYSOPERprivilegewhenthedatabaserestarts.

查看答案

如搜索结果不匹配，请联系老师获取答案

您可能会需要：

重置密码查看订单联系客服

安装上学吧APP，拍照搜题省时又省心！

更多“YouareaDatabaseAdministratorwi…”相关的问题

第1题

ForwhichdatabaseoperationwouldyouneedthedatabasetobeintheMOUNTstate（）

A.renamingthecontrolfiles

B.re-creatingthecontrolfiles

C.droppingauserinyourdatabase

D.droppingatablespaceinyourdatabase

E.configuringthedatabaseinstancetooperateintheARCHIVELOGorNOARCHIVELOGmodes

点击查看答案

第2题

Whatarethetwodifferenttypesofdatabaseduplication？（）

A.Active

B.Passive

C.Online

D.Backup-based

E.Failuredriven

点击查看答案

第3题

You want to start monitoring statistics on the distribution of storage engines that are being used and the average sizes of tables in the various databases.Some details are as follows:The Mysql instance has 400 databases. Each database on an average consists of 25-50 tables. You use the query:SELECT TABLE_SCHEMA, ‘ENGINE‘, COUNT (*), SUM(data_length) total_size FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE= ‘BASE TABLE‘ GROUP BY TABLE_SCHEMA, ‘ENGINE‘ ;Why is this query slow to execute?（）

A.Collecting information requires large numbers of locks on various INFORMATION_SCHEMA tables

B.Aggregating details from various storage engine caches for the final output is time consuming

C.Collecting information requires various disk-level operations and is time consuming

D.Counting and summarizing all table pages in the InnoDB shared tablespace is time consuming

点击查看答案

第4题

WhenyourSolarissystemisbooted，astartupscriptinitializestherpcbindservice.Whichscriptisit？（）

A./lib/svc/method/net-physical

B./etc/rcS.d/S30network

C.svc：/network/rpc/bind：default

D./lib/svc/method/rpc-bind

点击查看答案