题目内容

WhatwillbetheresultofusingtheSQL>DROPUSERSCOTTCASCADE；command？（）

A. Theuser，Scott，isdropped，alltheobjectsinScott’sschemaareplacedintheRecycleBin，andtheobjectsthatarealreadyintheRecycleBinaredropped.
B. Theuser，Scott，isdropped，alltheobjectsinScott’sschemaareplacedintheRecycleBin，andalltheobjectsintheRecycleBin，belongingtotheuserScott，arenotdropped.
C. Theuser，Scott，isdropped，alltheobjectsintheScott’sschemaarenotplacedintheRecycleBin，andtheobjectsintheRecycleBin，belongingtotheuser，Scott，arenotdropped.
D. Theuser，Scott，isdropped，alltheobjectsinScott’sschemaarenotplacedintheRecycleBin，andtheobjectsintheRecycleBinaredropped.

查看答案

搜索结果不匹配？点我反馈

更多问题

WhatcommandwouldyouusetosetapersistentsettinginRMANsothatbackupsareallwrittentoatapedevice？（）

A. CONFIGUREDEFAULTDEVICETYPETOTAPEMEDIA
B. CONFIGUREDEFAULTDEVICETYPETOTAPE
CONFIGUREDEFAULTDEVICETYPETOSBT
D. CONFIGUREDEFAULTDEVICETYPETOSBT_TAPE

查看答案

Yourdatabaseisconfiguredinsharedservermode.However，yourseniorDBAasksyoutomodifythevalueofthePRIVATE_SGAlimitintheprofileoftheusers.Whatcouldbethereasonforthis（）

A. tolimittheUserGlobalArea（UGA）memoryallocatedtoasessionfromtheSGA
B. tolimittheamountofmemorytobeusedforthedispatcherqueueofasessioninSGA
C. tolimittheamountofmemorytobeusedfortherequestpoolinSystemGlobalArea（SGA）
D. tocontroltheamountofmemoryallocatedinSGAforthelocalvariablesforeachsharedserverprocess

查看答案

Whichtwostatementsaretrueregardinglisteners（）

A. ListenersuseonlytheTCP/IPprotocol.
B. Multiplelistenerprocessescanrunsimultaneouslyonahost.
C. Multipledatabaseinstancescanberegisteredwithasinglelistener.
D. Thelistener-relatederrorscanbetracedonlyattheadministrativelevel.
E. Onlyonedatabaseinstancecanberegisteredwithasinglelisteneratanytime.

查看答案

Youareperformingadatabaserecoverybecauseauser’sschemaisdropped.Whileperformingtherecovery，youusetheUNTILSEQUENCEclause.Whichtypeofdatabaserecoveryareyouperforming？（）

A. usermanagedcompleterecovery
B. usermanagedincompleterecovery
C. RMAN-basedcompleterecovery
D. RMAN-basedincompleterecovery

查看答案