单选题Which of the following DB2 tools allows a user to execute an SQL statement and view a graphical representation of the access plan?（）A Task CenterB Command EditorC Developer WorkbenchD Command Line Processor

题目
单选题
Which of the following DB2 tools allows a user to execute an SQL statement and view a graphical representation of the access plan?（）
A

Task Center

B

Command Editor

C

Developer Workbench

D

Command Line Processor

相似考题

1.Which of the following command line utilities allows a technician to create a new directory?()A.RDB.CDC.DIRD.MD

2.Which of the following tools can be used to schedule a backup operation that is to be run every Sunday evening?()A.JournalB.Task CenterC.Activity MonitorD.Command Line Processor

3.Which of the following command line utilities allows a technician to create a new directory?（）A、RDB、CDC、DIRD、MD

4.Which of the following is a secure method of remote access via command line?()A.RCPB.TelnetC.RSHD.SSH

参考答案和解析
正确答案： A
解析： 暂无解析
更多“单选题Which of the following DB2 tools allows a user to execute an SQL statement and view a graphical representation of the access plan?（）A Task CenterB Command EditorC Developer WorkbenchD Command Line Processor”相关问题

  • 第1题：

    To make audit information more productive， the DBA executes the following command before startingan audit operation：  SQL> ALTER SYSTEM SET AUDIT_TRAIL=DB，EXTENDED SCOPE=SPFILE；  Which statement is true regarding the audit record generated when auditing starts after restarting thedatabase（）

    • A、It contains only the plan for the SQL statement executed by the user.
    • B、It contains the SQL text executed by the user and the bind variables used with it.
    • C、It contains the plan and statistics associated with the SQL statement executed by the user.
    • D、It contains the plan for the SQL statement executed by the user and the bind variables used with it.

    正确答案:B

  • 第2题：

    Which of the following switches for the FORMAT command line utility allows Bob, a technician, toformat a floppy disk the FASTEST?（）

    • A、/c
    • B、/q
    • C、/x
    • D、/v

    正确答案:B

  • 第3题：

    Which of the following tools for DB2 V9 allows a user to create and debug a SQL stored procedure?（）

    • A、Control Center
    • B、Development Center
    • C、Developer Workbench
    • D、Stored Procedure Builder

    正确答案:C

  • 第4题：

    Which statement is true about a DB2 user that is to be used as the database user for IBM Tivoli Access Manager for Enterprise Single Sign-On IMS Server？（）

    • A、The database user must be created using DB2 Control Center.
    • B、The database user must be created using the DB2 Command Line Processor.
    • C、The database user may be created using DB2 Control Center or DB2 Command Line Processor.
    • D、The database user must be created by IBM Tivoli Access Manager for Enterprise Single Sign-On V8.0.1 IMS Installer.

    正确答案:C

  • 第5题：

    Which of the following tools can be used to schedule a backup operation that is to be run every Sunday evening?（）

    • A、Journal
    • B、Task Center
    • C、Activity Monitor
    • D、Command Line Processor

    正确答案:B

  • 第6题：

    单选题
    Which of the following switches for the FORMAT command line utility allows Bob, a technician, toformat a floppy disk the FASTEST?（）
    A

    /c

    B

    /q

    C

    /x

    D

    /v


    正确答案： C
    解析： 暂无解析

  • 第7题：

    单选题
    Which of the following DB2 tools allows a user to execute an SQL statement and view a graphical representation of the access plan?（）
    A

    Task Center

    B

    Command Editor

    C

    Developer Workbench

    D

    Command Line Processor


    正确答案： C
    解析： 暂无解析

  • 第8题：

    单选题
    A user issues a SELECT command against the Oracle database. Which of the following choices describes a step that Oracle will execute in support of this statement?（）
    A

    Acquire locks on table queried 

    B

    Generate redo for statement 

    C

    Fetch data from disk into memory 

    D

    Write changes to disk


    正确答案： C
    解析： 暂无解析

  • 第9题：

    单选题
    Which operational command allows a user to view the exhaust temperatures of a Juniper device?（）
    A

    show chassis state

    B

    file list alarm

    C

    show chassis alarms

    D

    show chassis environment


    正确答案： C
    解析： 暂无解析

  • 第10题：

    多选题
    When executing the massload command to load catalog data into a WebSphere Commerce database on a remote DB2 server，which of the following can be used as valid values for the -method command line parameter？（）
    A

    create

    B

    import

    C

    load

    D

    sqlimport

    E

    update


    正确答案： E,A
    解析： 暂无解析

  • 第11题：

    单选题
    To make audit information more productive， the DBA executes the following command before starting an auditoperation： SQL> ALTER SYSTEM SET AUDIT_TRAIL=DB，EXTENDED SCOPE=SPFILE； Which statement is true regarding the audit record generated when auditing starts after restarting Thedatabase（）
    A

    It contains only the plan for the SQL statement executed by the user.

    B

    It contains the SQL text executed by the user and the bind variables used with it.

    C

    It contains the plan and statistics associated with the SQL statement executed by the user.

    D

    It contains the plan for the SQL statement executed by the user and the bind variables used with it


    正确答案： C
    解析： 暂无解析

  • 第12题：

    单选题
    Which statement is true about a DB2 user that is to be used as the database user for IBM Tivoli Access Manager for Enterprise Single Sign-On IMS Server？（）
    A

    The database user must be created using DB2 Control Center.

    B

    The database user must be created using the DB2 Command Line Processor.

    C

    The database user may be created using DB2 Control Center or DB2 Command Line Processor.

    D

    The database user must be created by IBM Tivoli Access Manager for Enterprise Single Sign-On V8.0.1 IMS Installer.


    正确答案： D
    解析： 暂无解析

  • 第13题：

    Which of the following command allows you to view the UDI information for a Cisco device?（）

    • A、show environment
    • B、show status
    • C、show inventory
    • D、show hardware

    正确答案:C

  • 第14题：

    Which of the following is a secure method of remote access via command line?（）

    • A、RCP
    • B、Telnet
    • C、RSH
    • D、SSH

    正确答案:D

  • 第15题：

    When executing the massload command to load catalog data into a WebSphere Commerce database on a remote DB2 server，which of the following can be used as valid values for the -method command line parameter？（）

    • A、create
    • B、import
    • C、load
    • D、sqlimport
    • E、update

    正确答案:B,D

  • 第16题：

    Which of the following DB2 tools allows a user to execute an SQL statement and view a graphical representation of the access plan?（）

    • A、Task Center
    • B、Command Editor
    • C、Developer Workbench
    • D、Command Line Processor

    正确答案:B

  • 第17题：

     A user issues a SELECT command against the Oracle database. Which of the following choices describes a step that Oracle will execute in support of this statement?（）

    • A、Acquire locks on table queried 
    • B、Generate redo for statement 
    • C、Fetch data from disk into memory 
    • D、Write changes to disk

    正确答案:C

  • 第18题：

    单选题
    You execute the following commands to audit database activities: SQL > ALTER SYSTEM SET AUDIT_TRIAL=DB, EXTENDED SCOPE=SPFILE; SQL > AUDIT SELECT TABLE, INSERT TABLE, DELETE TABLE BY JOHN By SESSION WHENEVER SUCCESSFUL; Which statement is true about the audit record that generated when auditing after instance restarts?（）
    A

    One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command on a table, and contains the SQL text for the SQL Statements.

    B

    One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command, and contains the execution plan for the SQL statements.

    C

    One audit record is created for the whole session if john successfully executes a SELECT, INSERT, or DELETE command, and contains the execution plan for the SQL statements.

    D

    One audit record is created for the whole session if JOHN successfully executes a select command, and contains the SQL text and bind variables used.

    E

    One audit record is created for the whole session if john successfully executes a SELECT, INSERT,or DELETE command on a table, and contains the execution plan, SQL text, and bind variables used.


    正确答案： C
    解析： 暂无解析

  • 第19题：

    单选题
    Which of the following is a secure method of remote access via command line?（）
    A

    RCP

    B

    Telnet

    C

    RSH

    D

    SSH


    正确答案： B
    解析： 暂无解析

  • 第20题：

    单选题
    Which of the following command allows you to view the UDI information for a Cisco device?（）
    A

    show environment

    B

    show status

    C

    show inventory

    D

    show hardware


    正确答案： D
    解析： 暂无解析

  • 第21题：

    单选题
    Which of the following tools for DB2 V9 allows a user to create and debug a SQL stored procedure?（）
    A

    Control Center

    B

    Development Center

    C

    Developer Workbench

    D

    Stored Procedure Builder


    正确答案： D
    解析： 暂无解析

  • 第22题：

    单选题
    The ORDERS table belongs to the user OE. OE has granted the SELECT privilege on the ORDERS table to the user HR.Which statement would create a synonym ORD so that HR can execute the following query successfully?（）
    A

    CREATE SYNONYM ord FOR orders; This command is issued by OE 

    B

    CREATE PUBLIC SYNONYM ord FOR orders; This command is issued by OE 

    C

    CREATE SYNONYM ord FOR oe.orders; This command is issued by the database administrator 

    D

    CREATE PUBLIC SYNONYM ord FOR oe.orders; This command is issued by the database administrator 


    正确答案： A
    解析： 暂无解析

  • 第23题：

    单选题
    To make audit information more productive， the DBA executes the following command before startingan audit operation：  SQL> ALTER SYSTEM SET AUDIT_TRAIL=DB，EXTENDED SCOPE=SPFILE；  Which statement is true regarding the audit record generated when auditing starts after restarting thedatabase（）
    A

    It contains only the plan for the SQL statement executed by the user.

    B

    It contains the SQL text executed by the user and the bind variables used with it.

    C

    It contains the plan and statistics associated with the SQL statement executed by the user.

    D

    It contains the plan for the SQL statement executed by the user and the bind variables used with it.


    正确答案： B
    解析： 暂无解析

  • 第24题：

    单选题
    Which of the following command line utilities allows a technician to create a new directory?（）
    A

    RD

    B

    CD

    C

    DIR

    D

    MD


    正确答案： A
    解析： 暂无解析

相关内容