Inyourdatabase，theRESULT_CACHE_MODEparameterhasbeensettoMANUALintheinitializationparameterfile.Youissuedthefollowingcommand：SQL>SELECT/*+RESULT_CACHE*/sale_category，sum（sale_amt）FROMsalesGROUPBYsale_category；Wherewouldtheresultofthisquerybestored（）？A.data

题目

Inyourdatabase，theRESULT_CACHE_MODEparameterhasbeensettoMANUALintheinitializationparameterfile.Youissuedthefollowingcommand：SQL>SELECT/*+RESULT_CACHE*/sale_category，sum（sale_amt）FROMsalesGROUPBYsale_category；Wherewouldtheresultofthisquerybestored（）？

A.databasebuffercache

B.sharedpool

C.PGA

D.largepool

相似考题

1.In your database, the flash recovery area (FRA) is configured as the default for RMAN backups. You executed the following commands to configure the settings in RMAN:Which statement is true about the outcome?（）A. Only one channel is allocated and the backup is created in the flash recovery areaB. Only one channel is allocated and the backup is created in the destination specified for channelC. Two channels are allocated and backup sets are created in the destinations specified for channels 1 and 2D. Three channels are allocated and backup sets are created in the destinations specified for channels 1, 2, and FRA

2.In your database, the LDAP_DIRECTORY_SYSAUTH initialization parameter has been set to YES and the users who need to access the database as DBAs have been granted SYSDBA enterprise role in Oracle Internet Directory (OID). SSL and the password file have been configured. A user SCOTT with the SYSDBA privilege tries to connect to the database instance from a remote machine using the command:Which authentication method would be used first?（）A. authentication by password fileB. authentication by using certificates over SSLC. authentication by using the Oracle Internet DirectoryD. authentication by using the local OS of the database server

3.Inyourdatabase，allthetablespacesarelocallymanaged.YoustartedRecoveryManager（RMAN）usingrecoverycatalogandrestoredthecontrolfilebyusingthefollowingcommand：RMAN>RESTORECONTROLFILEWhichtwooperationsdoyouneedtoperformafterrestoringthecontrolfilefrombackup？（）A.shutdownandrestarttheinstanceB.addnewtempfilestothetemporarytablespacesafterrecoveryC.performamediarecoveryandopenthedatabasewiththeRESETLOGSoptionD.performamediarecoveryandbringthedatabasetoNOARCHIVELOGmode

4.You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature. Which statement should you use to enable the block change tracking feature?（）A. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING;B. ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE <path>;C. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE <path>;D. ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING;

参考答案和解析
参考答案：B
更多“Inyourdatabase,theRESULT_CACHE_MODEparameterhasbeensettoMANUALintheinitializationparameter ”相关问题

  • 第1题：

    Inyourdatabase,onlineredologfilesaremultiplexedandoneofthemembersinagroupislostduetomediafailure.Howwouldyourecoverthelostredologmember?()

    A.importthedatabasefromthelastexport

    B.restoreallthemembersinthegroupfromthelastbackup

    C.dropthelostmemberfromthedatabase，andthenaddanewmembertothegroup

    D.restoreallthedatabasefilesfromthebackup，andthenperformacompleterecovery

    E.restoreallthedatabasefilesfromthebackup，andthenperformanincompleterecovery


    参考答案：C

  • 第2题：

    WhatistheimplicationofsettingtheinitializationparameterFAST_START_MTTR_TARGETto0inyourdatabase?()

    A.MTTRAdvisorwouldbedisabled.

    B.RedoLogAdvisorwouldbedisabled.

    C.Automatictuningofcheckpointwouldbedisabled.

    D.Checkpointinformationwouldnotbewrittentothealertlogfile.


    参考答案：C

  • 第3题：

    Inyourdatabase,youdiscoveredthatatempfileinalocallymanagedtemporarytablespacehasbeendeletedattheoperatingsystemlevel.Howwouldyourecoverthetablespace?()

    A.flashbackthedatabase

    B.performpoint-in-timerecovery

    C.performafulldatabaserecovery

    D.dropandre-createthetablespace

    E.useRecoveryManager（RMAN）torecoverthedatabase


    参考答案：D

  • 第4题：

    Inyourdatabase,theLogWriter(LGWR)processisunabletowritetoamemberofacurrentredologgroupduetoread／writefailure.Whichtwoeffectswouldyouseeinyourdatabase?()

    A.Thedatabaseinstanceaborts.

    B.Thedatabaseoperationtemporarilyhaltstillthememberbecomesavailable.

    C.Writingproceedsasnormal.LGWRwritestotheavailablemembersofagroupandignorestheunavailablemembers.

    D.ThememberwouldbemarkedasSTALEandanerrormessagewouldbewrittentothealertlogfileandLGWRtracefile.

    E.ThestatusofthegroupchangestoINACTIVEandanerrormessagewouldbewrittentothealertlogfileandLGWRtracefile.


    参考答案：C, D

  • 第5题：

    In your database, you want to ensure that idle sessions that are blocking active are automatically terminated after a specified period of time.How would you accomplish this?()

    A. Setting a metric threshold

    B. Implementing Database Resource Manager

    C. Enabling resumable timeout for user sessions

    D. Decreasing the value of the IDLE_TIME resource limit in the default profile


    参考答案：D

  • 第6题：

    Inyourdatabase,onlineredologfilesaremultiplexedandoneofthemembersinagroupislostduetomediafailure?Howwouldyourecoverthelostredologmember?()

    A.importthedatabasefromthelastexport

    B.restoreallthemembersinthegroupfromthelastbackup

    C.dropthelostmemberfromthedatabaseandthenaddanewmembertothegroup

    D.restoreallthedatabasefilesfromthebackupandthenperformacompleterecovery

    E.restoreallthedatabasefilesfromthebackupandthenperformanincompleterecovery


    参考答案：C

相关内容