题目内容（请给出正确答案）

[主观题]

YouareworkingasaDatabaseAdministrator.Youe

rroneouslydroppedanimportanttablenamedWAREHOUSE_DETAILS.Thetableresidesinanon-SYSTEMtablespace.Thefollowingdependentobjectshavebeendefinedonthedroppedtable：

YouareworkingasaDatabaseAdministrator.Youerroneous

Duetolimitedspace，someoftheindexesandtriggershavebeenremovedfromtheRecycleBin.YoudecidetorecoverthetablebyusingFlashbackDrop.Youexecutethefollowingstatement：SQL＞FLASHBACKTABLEwarehouse_detailsTOBEFOREDROP；

Whatwillbetheimplicationofexecutingthisstatement？（）

查看答案

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

您可能会需要：

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

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

更多“YouareworkingasaDatabaseAdmini…”相关的问题

第1题

Youhavebeenrecentlyhiredasadatabaseadministrator.Yourseniormanagerasksyoutostudytheproduct

iondatabaseserverandsubmitareportonthesettingsdonebythepreviousDBA.Whileobservingtheserversettings，youfindthatthefollowingparameterhasbeensetintheparameterfileofthedatabase：REMOTE_OS_AUTHENT=TRUEWhatcouldhavebeenthereasontosetthisparameterasTRUE？（）

A.toenableoperatingsystemauthenticationforaremoteclient

B.torestrictthescopeofadministrationtoidenticaloperatingsystems

C.toallowthestartupandshutdownofthedatabasefromaremoteclient

D.toenabletheadministrationoftheoperatingsystemfromaremoteclient

E.todisabletheadministrationoftheoperatingsystemfromaremoteclient

点击查看答案

第2题

You have forgotten the root user account password. You decide to reset the password and ex

ecute the following:Shell＞ /etc/init.d/mysql stopShell＞ /etc/init.d/mysql start – skip-grant tablesWhich additional argument makes this operation safer?（）

A.–skip-networking, to prohibit access from remote locations

B.–reset-grant-tables, to start the server with only the mysql database accessible

C.–read-only,to set all data to read-only except for super users

D.–old-passwords, to start Mysql to use the old password format while running without the grant tables

点击查看答案

第3题

Evaluate this SQL statement:In the statement, which capabilities of a SELECT statement are performed?（）

A. Selection, projection, join

B. Difference, projection, join

C. Selection, intersection, join

D. Intersection, projection, join

E. Difference, projection, product

点击查看答案

第4题

Which two statements are true about a job chain? （）(Choose two.)

A. A job chain can contain a nested chain of jobs.

B. The jobs in a job chain cannot have more than one dependency.

C. A job of the CHAIN type can be run using event-based or time-based schedules.

D. The jobs in a job chain can be executed only by using the events generated by the Scheduler

点击查看答案

第5题

Whichcommanddoyouusetocreatearecovery-catalogschema?（）

A.createrecoverycatalog

B.createcatalog

C.buildcatalog

D.catalogcreate

E.mountcatalog

点击查看答案

第6题

Yourdatabaseishavingtwocontrolfiles，threeredologfilegroupswithtwomembersineachgroup.Failureofwhichfilewouldcauseaninstancetoshutdown？（）

A.anycontrolfile

B.anyarchivelogfile

C.oneoftheredologmembers

D.lossoftheinitializationparameterfile

E.anydatafilebelongingtothedefaultpermanenttablespac

点击查看答案

第7题

Which two requirements would lead towards a high availability solution?（）

A.When uptime is critical

B.When data must be refactored

C.When application concurrency is static

D.When data loss is unacceptable

E.When application is a single point of failure

点击查看答案

第8题

WhichtwooperationscanbeflashedbackusingtheFlashbacktechnology？（）

A.DROPUSERSMITH；

B.DROPTABLEEMPLOYEES；

C.DROPTABLESPACEUSERS；

D.ALTERTABLESALES_REPDROPPARTITIONP1；

E.ALTERTABLEEMPLOYEESDROPCOLUMNDESIG_ID；

点击查看答案

第9题

ViewtheExhibit1，whichshowstheoptionsthatareselectedtocreatetheuserSL_REP.Whichtwostatementsaretrueregardingthisuser（）

A.Theuserisauthenticatedbytheoperatingsystem.

B.TheobjectscreatedbytheuserareplacedintheUSERStablespace.

C.TheuserdoesnotrequirequotaontheTEMPtablespacetoperformsortoperations.

D.Theuserisforcedtochangethepasswordatthefirstlogintothedatabaseinstance.

E.Theobjectscreatedbytheuserinfutureareunlockedtobeaccessedbyalltheusersinthedatabasebydefa

点击查看答案

第10题

WhichtwostatementsregardingtheLOGGINGclauseoftheCREATETABLESPACE...statementarecorrect？（）

A.Thisclauseisnotvalidforatemporaryorundotablespace.

B.IfthetablespaceisintheNOLOGGINGmode，nooperationonthetablespacewillgenerateredo.

C.ThetablespacewillbeintheNOLOGGINGmodebydefault，ifnotspecifiedwhilecreatingatablespace.

D.Thetablespace-levelloggingattributecanbeoverriddenbyloggingspecificationsatthetable，index，materializedview，materializedviewlog，andpartitionlevels.

点击查看答案

谢谢您的反馈

您认为本题答案有误，我们将认真、仔细核查，
如果您知道正确答案，欢迎您来纠错

开始纠错>>>

警告：系统检测到您的账号存在安全风险

为了保护您的账号安全，请在“上学吧”公众号进行验证，点击“官网服务”-“账号验证”后输入验证码“”完成验证，验证成功后方可继续查看答案！

微信搜一搜

上学吧

点击打开微信

警告：系统检测到您的账号存在安全风险

抱歉，您的账号因涉嫌违反上学吧购买须知被冻结。您可在“上学吧”微信公众号中的“官网服务”-“账号解封申请”申请解封，或联系客服。

微信搜一搜

上学吧

点击打开微信