单选题Your application regularly issues the following statement: SELECT * FROM BANK_ACCT WHERE ACCT_BALANCE BETWEEN 1000 and 10000; Which of the following database objects would be inappropriate for use with this statement?（）A Materialized views B Indexes C

题目
单选题
Your application regularly issues the following statement: SELECT * FROM BANK_ACCT WHERE ACCT_BALANCE BETWEEN 1000 and 10000; Which of the following database objects would be inappropriate for use with this statement?（）
A

Materialized views 

B

Indexes 

C

Index-organized tables 

D

Hash clusters

相似考题

1.Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query:SQL> SELECT * FROM sales;Which process would retrieve the result from the database and return it to the client program?（）A. User processB. Server processC. System Monitor (SMON)D. Process Monitor (PMON)E. Checkpoint process (CKPT)

2.Your database supports an online transaction processing (OLTP) application.The application is undergoing some major schema changes, such as addition of new indexes and materialized views.You want to check the impact of these changes on workload performance.What should you use to achieve this?（）A. Database replayB. SQL Tuning AdvisorC. SQL Access AdvisorD. SQL Performance AnalyzerE. Automatic Workload Repository compare reports

3. You are creating a Web-based application to manage data aggregation for reports. The application connects to a SQL Server 2005 database named DataManager. One page in the application has controls that execute stored procedures in a database named ReportingDatabase. There is an existing Service Broker connection between the DataManager database and ReportingDatabase.You want to add two new message types to the existing service. In each database， you create message types named ProcessReport and SendResult. You need to add the two new message types to the existing service. What should you do first？（）A、Create a queue on each database with the ACTIVATION argument set to DataManager dbo processReport.B、Create a conversation between the databases by using the following Statement BEGIN DIALOG FROM SERVICE ’ProcessReport’ TO SERVICE ’SendResult’C、Create a contract between the services by using the following statement.CREATE CONTRACT processData （ProcessReport SENT BY INITIATOR，SendResult SENT BY TARGET）D、Create services for each database by using the following statement.CREATE SERVICE DataManager on QUEUE ProcessReport

4.Which of the following is a potential performance tuning recommendation from the SQL Access Advisor?()A. Create new indexes.B. Modify existing indexes.C. Implement partitioning on a nonpartitioned table.D. Create materialized views.E. All of the above

更多“单选题Your application regularly issues the following statement: SELECT * FROM BANK_ACCT WHERE ACCT_BALANCE BETWEEN 1000 and 10000; Which of the following database objects would be inappropriate for use with this statement?（）A Materialized views B Indexes C ”相关问题

  • 第1题：

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

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

    正确答案:D

  • 第2题：

    Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query: SQL> SELECT * FROM sales; Which process would retrieve the result from the database and return it to the client program?（）

    • A、User process
    • B、Server process
    • C、System Monitor (SMON)
    • D、Process Monitor (PMON)
    • E、Checkpoint process (CKPT)

    正确答案:B

  • 第3题：

    Your database supports an online transaction processing (OLTP) application. The application is undergoing some major schema changes, such as addition of new indexes and materialized views. You want to check the impact of these changes on workload performance. What should you use to achieve this?（）

    • A、Database replay
    • B、SQL Tuning Advisor
    • C、SQL Access Advisor
    • D、SQL Performance Analyzer
    • E、Automatic Workload Repository compare reports

    正确答案:E

  • 第4题：

    The user Sue issues this SQL statement: GRANT SELECT ON sue. EMP TO alice WITH GRANT OPTION; The user Alice issues this SQL statement: GRANT SELECT ON sue. EMP TO reena WITH GRANT OPTION; The user Reena issues this SQL statement: GRANT SELECT ON sue. EMP TO timber; The user Sue issues this SQL statement: REVOKE select on sue. EMP FROM alice; For which users does the revoke command revoke SELECT privileges on the SUE.EMP table?（）

    • A、Alice only
    • B、Alice and Reena
    • C、Alice, Reena, and Timber
    • D、Sue, Alice, Reena, and Timber

    正确答案:C

  • 第5题：

     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

  • 第6题：

    单选题
    Your database supports an online transaction processing (OLTP) application. The application is undergoing some major schema changes, such as addition of new indexes and materialized views. You want to check the impact of these changes on workload performance. What should you use to achieve this?（）
    A

    Database replay

    B

    SQL Tuning Advisor

    C

    SQL Access Advisor

    D

    SQL Performance Analyzer

    E

    Automatic Workload Repository compare reports


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

  • 第7题：

    单选题
    In a SELECT statement that includes a WHERE clause, where is the GROUP BY clause placed in the SELECT statement?（）
    A

    Immediately after the SELECT clause

    B

    Before the WHERE clause

    C

    Before the FROM clause

    D

    After the ORDER BY clause

    E

    After the WHERE clause


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

  • 第8题：

    单选题
    The user Sue issues this SQL statement: GRANT SELECT ON sue. EMP TO alice WITH GRANT OPTION; The user Alice issues this SQL statement: GRANT SELECT ON sue. EMP TO reena WITH GRANT OPTION; The user Reena issues this SQL statement: GRANT SELECT ON sue. EMP TO timber; The user Sue issues this SQL statement: REVOKE select on sue. EMP FROM alice; For which users does the revoke command revoke SELECT privileges on the SUE.EMP table?（）
    A

    Alice only

    B

    Alice and Reena

    C

    Alice, Reena, and Timber

    D

    Sue, Alice, Reena, and Timber


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

  • 第9题：

    单选题
    Which of the following is a potential performance tuning recommendation from the SQL Access Advisor?（）
    A

    Create new indexes.

    B

    Modify existing indexes.

    C

    Implement partitioning on a nonpartitioned table.

    D

    Create materialized views.

    E

    All of the above


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

  • 第10题：

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

    Sequence

    B

    Schema

    C

    Group

    D

    View


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

  • 第11题：

    单选题
    You are creating a Web-based application to manage data aggregation for reports. The application connects to a SQL Server 2005 database named DataManager. One page in the application has controls that execute stored procedures in a database named ReportingDatabase. There is an existing Service Broker connection between the DataManager database and ReportingDatabase.You want to add two new message types to the existing service. In each database， you create message types named ProcessReport and SendResult. You need to add the two new message types to the existing service. What should you do first？（）
    A

    Create a queue on each database with the ACTIVATION argument set to DataManager dbo processReport.

    B

    Create a conversation between the databases by using the following Statement BEGIN DIALOG FROM SERVICE ’ProcessReport’ TO SERVICE ’SendResult’

    C

    Create a contract between the services by using the following statement.CREATE CONTRACT processData （ProcessReport SENT BY INITIATOR，SendResult SENT BY TARGET）

    D

    Create services for each database by using the following statement.CREATE SERVICE DataManager on QUEUE ProcessReport


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

  • 第12题：

    单选题
    Which of the following is a potential performance tuning recommendation from the SQL Access Advisor？（）
    A

     Create new indexes.

    B

     Modify existing indexes.

    C

     Implement partitioning on a nonpartitioned table.

    D

     Create materialized views.

    E

     All of the above


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

  • 第13题：

    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

  • 第14题：

    Which of the following is a potential performance tuning recommendation from the SQL Access Advisor?（）

    • A、Create new indexes.
    • B、Modify existing indexes.
    • C、Implement partitioning on a nonpartitioned table.
    • D、Create materialized views.
    • E、All of the above

    正确答案:E

  • 第15题：

    Your application regularly issues the following statement: SELECT * FROM BANK_ACCT WHERE ACCT_BALANCE BETWEEN 1000 and 10000; Which of the following database objects would be inappropriate for use with this statement?（）

    • A、Materialized views 
    • B、Indexes 
    • C、Index-organized tables 
    • D、Hash clusters

    正确答案:D

  • 第16题：

    Where can subqueries be used?（）

    • A、field names in the SELECT statement 
    • B、the FROM clause in the SELECT statement 
    • C、the HAVING clause in the SELECT statement
    • D、the GROUP BY clause in the SELECT statement 
    • E、the WHERE clause in only the SELECT statement 
    • F、the WHERE clause in SELECT as well as all DML statements

    正确答案:B,C,F

  • 第17题：

    You are a database administrator for your company. You are responsible for a SQL Server 2005 database that has several indexes. You need to write a stored procedure that checks the indexes for fragmentation. Which Transact-SQL statement should you use？（）

    • A、DBCC DBREINDEX
    • B、SELECT * FROM sys.dm_db_index_physical_stats
    • C、DBCC INDEXDEFRAG
    • D、SELECT * FROM sys.indexes

    正确答案:B

  • 第18题：

    单选题
    Your application regularly issues the following statement: SELECT * FROM BANK_ACCT WHERE ACCT_BALANCE BETWEEN 1000 and 10000; Which of the following database objects would be inappropriate for use with this statement?（）
    A

    Materialized views 

    B

    Indexes 

    C

    Index-organized tables 

    D

    Hash clusters


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

  • 第19题：

    单选题
    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
    解析： 暂无解析

  • 第20题：

    单选题
    View the Exhibit and examine the structure of the ORDERS and ORDERJTEMS tables.  Evaluate the following SQL statement：   SELECT oi.order_id， product_jd， order_date   FROM order_items oi JOIN orders o   USING （order_id）；   Which statement is true regarding the execution of this SQL statement？（）
    A

     The statement would not execute because table aliases are not allowed in the JOIN clause.

    B

     The statement would not execute because the table alias prefix is not used in the USING clause.

    C

     The statement would not execute because all the columns in the SELECT clause are not prefixed with table aliases.

    D

     The statement would not execute because the column part of the USING clause cannot have a qualifier in the SELECT list.


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

  • 第21题：

    单选题
    Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query: SQL> SELECT * FROM sales; Which process would retrieve the result from the database and return it to the client program?（）
    A

    User process

    B

    Server process

    C

    System Monitor (SMON)

    D

    Process Monitor (PMON)

    E

    Checkpoint process (CKPT)


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

  • 第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 database administrator for your company. You are responsible for a SQL Server 2005 database that has several indexes. You need to write a stored procedure that checks the indexes for fragmentation. Which Transact-SQL statement should you use？（）
    A

    DBCC DBREINDEX

    B

    SELECT * FROM sys.dm_db_index_physical_stats

    C

    DBCC INDEXDEFRAG

    D

    SELECT * FROM sys.indexes


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

  • 第24题：

    单选题
    Your database interface is running. A user SCOTT starts a SQL *Plus session， and issues the following query：   SQL> SELECT * FROM sales；   Which process would retrieve the result from the database and return it to the client program？（）
    A

     User process

    B

     Server process

    C

     System Monitor （SMON）

    D

     Process Monitor （PMON）

    E

     Checkpoint process （CKPT）


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

相关内容