WhatcommandwouldyouusetosetapersistentsettinginRMANsothatbackupsareallwrittentoatapedevice?()
A.CONFIGUREDEFAULTDEVICETYPETOTAPEMEDIA
B.CONFIGUREDEFAULTDEVICETYPETOTAPE
C.CONFIGUREDEFAULTDEVICETYPETOSBT
D.CONFIGUREDEFAULTDEVICETYPETOSBT_TAPE
A.CONFIGUREDEFAULTDEVICETYPETOTAPEMEDIA
B.CONFIGUREDEFAULTDEVICETYPETOTAPE
C.CONFIGUREDEFAULTDEVICETYPETOSBT
D.CONFIGUREDEFAULTDEVICETYPETOSBT_TAPE
第1题
elistenerbyusingthefollowingcommand:LSNRCTL>STOPWhatwouldhappentothesessionsthatarepresentlyconnectedtothedatabaseinstance?()
A.Thesessionsareabletoperformonlyqueries.
B.Thesessionsarenotaffectedandcontinuetofunctionnormally.
C.Theactivetransactionsarerolledbackandthesessionsgetterminated.
D.Thesessionsarenotallowedtoperformanyoperationstillthelistenerisstarted.
第2题
:unabletoextendtableHR.TTKby128intablespaceSMDUponinvestigation,youfindthatSMDisasmallfiletablespace.Whichthreeactionwouldallowtheusertoinsertdata()
A.AddadatafiletotheSMDtablespace.
B.AddadatafiletothetemporarytablespaceassociatedwiththeuserHR.
C.ResizethedatafileassociatedwiththeSMDtablespacetomakeitlarger.
D.AlterthedatafileassociatedwiththeSMDtablespacetogrowautomatically.
E.ChangethesegmentspacemanagementfortheSMDtablespacetoautomatic.nsegmentsismanagedthroughfreelists.
第3题
A. Building the SQL profile
B. Recommending optimization of materialized views
C. Checking query objects for missing and stale statistics
D. Recommending bitmap, function-based, and B-tree indexes
E. Recommending restructuring SQL queries that are using bad plans
第4题
rroneouslydroppedanimportanttablenamedWAREHOUSE_DETAILS.Thetableresidesinanon-SYSTEMtablespace.Thefollowingdependentobjectshavebeendefinedonthedroppedtable:
Duetolimitedspace,someoftheindexesandtriggershavebeenremovedfromtheRecycleBin.YoudecidetorecoverthetablebyusingFlashbackDrop.Youexecutethefollowingstatement:SQL>FLASHBACKTABLEwarehouse_detailsTOBEFOREDROP;
Whatwillbetheimplicationofexecutingthisstatement?()
第5题
iondatabaseserverandsubmitareportonthesettingsdonebythepreviousDBA.Whileobservingtheserversettings,youfindthatthefollowingparameterhasbeensetintheparameterfileofthedatabase:REMOTE_OS_AUTHENT=TRUEWhatcouldhavebeenthereasontosetthisparameterasTRUE?()
A.toenableoperatingsystemauthenticationforaremoteclient
B.torestrictthescopeofadministrationtoidenticaloperatingsystems
C.toallowthestartupandshutdownofthedatabasefromaremoteclient
D.toenabletheadministrationoftheoperatingsystemfromaremoteclient
E.todisabletheadministrationoftheoperatingsystemfromaremoteclient
第6题
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
第7题
A. Selection, projection, join
B. Difference, projection, join
C. Selection, intersection, join
D. Intersection, projection, join
E. Difference, projection, product
第8题
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
第9题
A.createrecoverycatalog
B.createcatalog
C.buildcatalog
D.catalogcreate
E.mountcatalog
第10题
A.anycontrolfile
B.anyarchivelogfile
C.oneoftheredologmembers
D.lossoftheinitializationparameterfile
E.anydatafilebelongingtothedefaultpermanenttablespac
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!