单选题Which of the following database objects is considered executable using SQL?（）A ViewB TableC RoutineD Package

题目
单选题
Which of the following database objects is considered executable using SQL?（）
A

View

B

Table

C

Routine

D

Package

相似考题

1.下列( )对象不是SQL Server数据库对象。A、ViewB、TableC、RuleD、Wps

2.Which of the following DB2 objects are publicly referenced names that require no special authority or privilege to use them?()A.ViewB.AliasC.TableD.Package

3.A trigger can be created on which of the following objects?()A.ViewB.Catalog TableC.Stored ProcedureD.Global Temporary Table

4.Which of the following database objects is considered executable using SQL?()A.ViewB.TableC.RoutineD.Package

更多“单选题Which of the following database objects is considered executable using SQL?（）A ViewB TableC RoutineD Package”相关问题

  • 第1题：

    Which of the following are types of routine objects?()

    A.Package and function

    B.Function and userexit

    C.Procedure and package

    D.Function and procedure


    参考答案：D

  • 第2题：

    Which of the following provides a logical grouping of database objects?()

    A.View

    B.Table

    C.Schema

    D.Buffer pool


    参考答案：C

  • 第3题：

    A trigger can be created on which of the following objects?（）

    • A、View
    • B、Catalog Table
    • C、Stored Procedure
    • D、Global Temporary Table

    正确答案:A

  • 第4题：

    Which of the following database objects is considered executable using SQL?（）

    • A、View
    • B、Table
    • C、Routine
    • D、Package

    正确答案:C

  • 第5题：

    Which of the following DB2 objects are publicly referenced names that require no special authority or privilege to use them?（）

    • A、View
    • B、Alias
    • C、Table
    • D、Package

    正确答案:B

  • 第6题：

    A number of applications issue the following SQL statement:SELECT d.deptno, e.empno, e.salary FROM department d INNER JOIN employee e ON d.deptno = e.deptnoA database administrator wishes to store this query within the database. Which of the following database objects can be used to accomplish this?（）

    • A、Alias
    • B、View
    • C、Schema
    • D、Trigger

    正确答案:B

  • 第7题：

    Which of the following cannot be used as input to the SQL Tuning Advisor？（）

    • A、 A single SQL statement provided by a user
    • B、 An existing SQL Tuning Set （STS）
    • C、 A preprocessed Database Replay workload
    • D、 A schema name
    • E、 SQL statement identified in EM as using excessive resources

    正确答案:C,D

  • 第8题：

    You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work a database administrator for your company. There is a Data Transformation Services （DTS） package， and the DTS package is stored in SQL Server 2000. And you plans to have the SQL Server 2000 migrated into SQL Server 2005. The DTS package dynamically configures precedence constraints by utilizing complex Microsoft Visual Basic Scripting Edition （VBScript）. The SQL Server 2005 Package Migration Wizard is run by you， but the wizard cannot convert the package from SQL Server 2000 to SQL Server 2005. You are required to make sure that the DTS package runs in SQL Server 2005. And the package should be run in the shortest time.  Which action should be utilized？（）

    • A、The SQL Server 2000 Data Transformation Services （DTS） package should be wrapped in an Execute DTS 2000 Package task.
    • B、The SQL Server 2000 Data Transformation Services （DTS） package should be manually recreated as a SQL Server Integration Services （SSIS） package.
    • C、The SQL Server 2000 Data Transformation Services （DTS） task should be configured to not utilize precedence constraints. Then， the SQL Server 2005 Package Migration Wizard should be run again.
    • D、The SQL Server 2005 Package Migration Wizard should be run. And when the upgrade fails， a Transfer SQL Server Objects task should be run.

    正确答案:A

  • 第9题：

    单选题
    Which of the following database objects is considered executable using SQL?（）
    A

    View

    B

    Table

    C

    Routine

    D

    Package


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

  • 第10题：

    单选题
    On which of the following database objects may the SELECT privilege be controlled?（）
    A

    Sequence

    B

    Schema

    C

    Group

    D

    View


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

  • 第11题：

    单选题
    These are points that describe the contents of different memory components:  1: Descriptive information or metadata about schema objects that are queried by using SQL statements  2: The run-time area for data manipulation language (DML) or data definition language (DDL) statements  3: Results of SQL queries and PL/SQL functions  4: Executable forms of SQL cursors, PL/SQL programs, and Java classes  5: The information necessary to reconstruct changes made to the database by a transaction  Which of these will be stored in theShared Poolif the necessary configurations are done（）
    A

    1 and 2

    B

    2 and 5

    C

    1，3，and 4

    D

    3，4，and 5

    E

    1，2，3，and 4


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

  • 第12题：

    多选题
    Which of the following cannot be used as input to the SQL Tuning Advisor？（）
    A

    A single SQL statement provided by a user

    B

    An existing SQL Tuning Set （STS）

    C

    A preprocessed Database Replay workload

    D

    A schema name

    E

    SQL statement identified in EM as using excessive resources


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

  • 第13题：

    Which of the following objects contains control structures that are considered the bound form of SQL statements?()

    A.UDT

    B.Trigger

    C.Package

    D.Access plan


    参考答案：C

  • 第14题：

    Which of the following objects contains control structures that are considered the bound form of SQL statements?（）

    • A、UDT
    • B、Trigger
    • C、Package
    • D、Access plan

    正确答案:C

  • 第15题：

    Which of the following provides a logical grouping of database objects?（）

    • A、View
    • B、Table
    • C、Schema
    • D、Buffer pool

    正确答案:C

  • 第16题：

    On which of the following database objects may the SELECT privilege be controlled?（）

    • A、Sequence
    • B、Schema
    • C、Group
    • D、View

    正确答案:D

  • 第17题：

    Which of the following are types of routine objects?（）

    • A、Package and function
    • B、Function and userexit
    • C、Procedure and package
    • D、Function and procedure

    正确答案:D

  • 第18题：

    Which of the following cannot be used as input to the SQL Tuning Advisor?（） (Choose all that apply.)

    • A、A single SQL statement provided by a user
    • B、An existing SQL Tuning Set (STS)
    • C、A preprocessed Database Replay workload
    • D、A schema name
    • E、SQL statement identified in EM as using excessive resources

    正确答案:C,D

  • 第19题：

    You want to analyze a SQL Tuning Set (STS) using SQL Performance Analyzer in a test database. Which two statements are true regarding the activities performed during the test execution of SQLs in a SQL Tuning Set?（）

    • A、Every SQL statement in the STS is considered only once for execution
    • B、The SQL statements in the STS are executed concurrently to produce the execution plan and execution statistics
    • C、The execution plan and execution statistics are computed for each SQL statement in the STS
    • D、The effects of DDL and DML are considered to produce the execution plan and execution statistics

    正确答案:A,C

  • 第20题：

    单选题
    Which of the following describes the objects of a DB2 database and their relationships?（）
    A

    Instance

    B

    Table space

    C

    System catalog

    D

    Schema repository


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

  • 第21题：

    单选题
    You are identifying dictionary objects in the Oracle database. Which of the following is a view in the data dictionary?（）
    A

    V$DATABASE 

    B

    DBA_TABLES 

    C

    SYSAUD$ 

    D

    EMP


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

  • 第22题：

    单选题
    A number of applications issue the following SQL statement:SELECT d.deptno, e.empno, e.salary FROM department d INNER JOIN employee e ON d.deptno = e.deptnoA database administrator wishes to store this query within the database. Which of the following database objects can be used to accomplish this?（）
    A

    Alias

    B

    View

    C

    Schema

    D

    Trigger


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

  • 第23题：

    单选题
    You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work a database administrator for your company. There is a Data Transformation Services （DTS） package， and the DTS package is stored in SQL Server 2000. And you plans to have the SQL Server 2000 migrated into SQL Server 2005. The DTS package dynamically configures precedence constraints by utilizing complex Microsoft Visual Basic Scripting Edition （VBScript）. The SQL Server 2005 Package Migration Wizard is run by you， but the wizard cannot convert the package from SQL Server 2000 to SQL Server 2005. You are required to make sure that the DTS package runs in SQL Server 2005. And the package should be run in the shortest time.  Which action should be utilized？（）
    A

    The SQL Server 2000 Data Transformation Services （DTS） package should be wrapped in an Execute DTS 2000 Package task.

    B

    The SQL Server 2000 Data Transformation Services （DTS） package should be manually recreated as a SQL Server Integration Services （SSIS） package.

    C

    The SQL Server 2000 Data Transformation Services （DTS） task should be configured to not utilize precedence constraints. Then， the SQL Server 2005 Package Migration Wizard should be run again.

    D

    The SQL Server 2005 Package Migration Wizard should be run. And when the upgrade fails， a Transfer SQL Server Objects task should be run.


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

  • 第24题：

    单选题
    Which of the following objects contains control structures that are considered the bound form of SQL statements?（）
    A

    UDT

    B

    Trigger

    C

    Package

    D

    Access plan


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

相关内容