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.