欢迎来到PP题库网 PP题库官网
logo
全部科目 > Oracle认证考试 > OCP 11G认证考试

单项选择题

Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework? ()

    A.SQL statements that are part of the AWR baseline only 
    B.SQL statements based on the AWR top SQL identification
    C.SQL statements that are part of the available SQL Tuning Set (STS) only 
    D.SQL statements that are available in the cursor cache and executed by a user other than SYS 

点击查看答案

相关考题

  • 多项选择题
    WhataretheadvantagesofvariableextentsizesupportforlargeASMfiles?()

    A.It improves resync operations when the disk comes online after being taken offline for maintenance purposes. 
    B.It improves performance in the extended cluster configuration by reading from a local copy of an extent. 
    C.Fewer extent pointers are needed to describe the file and less memory is required to manage the extent maps in the shared pool.
    D.This feature enables faster file opens because of the reduction in the amount of memory that is required to store file extents.

  • 单项选择题
    Whichstatementistrueregardingvirtualprivatecatalogs?()

    A.A virtual private catalog owner can create a local stored script, and have read/write access to a global stored script. 
    B.The virtual private catalog owner cannot create and modify the stored scripts. 
    C.The set of views and synonyms that make up the virtual private catalog is stored in the schema of the RMAN recovery catalog owner. 
    D.To perform most of the RMAN operations, the virtual catalog owner must have the SYSDBA or SYSOPER privilege on the target database. 

  • 单项选择题
    Whichstatementistrueregardingthissetting?()

    A.It drops the connection after the specified number of login attempts fail for any user.
    B.It is enforced only if the password profile is enabled for the user. 
    C.It locks the user account after the specified number of attempts. 
    D.It drops the connection after the specified number of login attempts fail only for users who have the SYSDBA privilege.

微信小程序免费搜题
微信扫一扫,加关注免费搜题

微信扫一扫,加关注免费搜题