A.Comparethecontentsoftheinstall.logfilewiththeresponsefile.
B.RefertothecontentsoftheoraInst.locfiletoverifythestepsperformedbyOUI.
C.ComparethecontentsoftheinstallActions.logfilewiththatoftheresponsefile.
D.RefertothealertlogfileforinformationregardingtheactionsperformedbyOUIduringinstallation.
第1题
EMPLOYEEtableintheScottschematoanemptystring.Youarethesystemadministrator,andyouwanttoreturntheoriginalvaluesinthetable.Todoso,youdecidedtoflashbackthetable.Whichtwooptionscanyouusetoflashbackatable?()
A.byusingOracleEnterpriseManager
B.byissuingtheFLASHBACKTABLEstatementattheRMANprompt
C.byissuingtheFLASHBACKTABLEstatementattheSQLprompt
D.byissuingtheFLASHBACKTABLEstatementattheLSNRCTLprompt
第2题
A.Thedatabaseautomaticallydeterminestheextent-sizingpolicyforthetablespace.
B.Thesegmentsareautomaticallyshrunkwhenthecontentsareremovedfromthem.
C.Theallocationofextentswithinthetablespaceismanagedthroughthedictionarytables.
D.Thespaceutilizationdescriptionofthedatablocksinsegmentsisrecordedinbitmapblocks.
E.Thespaceutilizationdescriptionofthedatablocksinsegmentsismanagedthroughfreelists.MANUAL
第3题
A.CONFIGUREDEFAULTDEVICETYPETOTAPEMEDIA
B.CONFIGUREDEFAULTDEVICETYPETOTAPE
C.CONFIGUREDEFAULTDEVICETYPETOSBT
D.CONFIGUREDEFAULTDEVICETYPETOSBT_TAPE
第4题
elistenerbyusingthefollowingcommand:LSNRCTL>STOPWhatwouldhappentothesessionsthatarepresentlyconnectedtothedatabaseinstance?()
A.Thesessionsareabletoperformonlyqueries.
B.Thesessionsarenotaffectedandcontinuetofunctionnormally.
C.Theactivetransactionsarerolledbackandthesessionsgetterminated.
D.Thesessionsarenotallowedtoperformanyoperationstillthelistenerisstarted.
第5题
:unabletoextendtableHR.TTKby128intablespaceSMDUponinvestigation,youfindthatSMDisasmallfiletablespace.Whichthreeactionwouldallowtheusertoinsertdata()
A.AddadatafiletotheSMDtablespace.
B.AddadatafiletothetemporarytablespaceassociatedwiththeuserHR.
C.ResizethedatafileassociatedwiththeSMDtablespacetomakeitlarger.
D.AlterthedatafileassociatedwiththeSMDtablespacetogrowautomatically.
E.ChangethesegmentspacemanagementfortheSMDtablespacetoautomatic.nsegmentsismanagedthroughfreelists.
第6题
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
第7题
rroneouslydroppedanimportanttablenamedWAREHOUSE_DETAILS.Thetableresidesinanon-SYSTEMtablespace.Thefollowingdependentobjectshavebeendefinedonthedroppedtable:
Duetolimitedspace,someoftheindexesandtriggershavebeenremovedfromtheRecycleBin.YoudecidetorecoverthetablebyusingFlashbackDrop.Youexecutethefollowingstatement:SQL>FLASHBACKTABLEwarehouse_detailsTOBEFOREDROP;
Whatwillbetheimplicationofexecutingthisstatement?()
第8题
iondatabaseserverandsubmitareportonthesettingsdonebythepreviousDBA.Whileobservingtheserversettings,youfindthatthefollowingparameterhasbeensetintheparameterfileofthedatabase:REMOTE_OS_AUTHENT=TRUEWhatcouldhavebeenthereasontosetthisparameterasTRUE?()
A.toenableoperatingsystemauthenticationforaremoteclient
B.torestrictthescopeofadministrationtoidenticaloperatingsystems
C.toallowthestartupandshutdownofthedatabasefromaremoteclient
D.toenabletheadministrationoftheoperatingsystemfromaremoteclient
E.todisabletheadministrationoftheoperatingsystemfromaremoteclient
第9题
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
第10题
A. Selection, projection, join
B. Difference, projection, join
C. Selection, intersection, join
D. Intersection, projection, join
E. Difference, projection, product
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!