Which clause should you use to exclude group results?（）A、WHEREB、HAVINGC、RESTRICTD、GROUP BYE、ORDER BY

题目

Which clause should you use to exclude group results?（）

  • A、WHERE
  • B、HAVING
  • C、RESTRICT
  • D、GROUP BY
  • E、ORDER BY
相似考题

1.Which clause should you use to exclude group results? ()A. WHEREB. HAVINGC. RESTRICTD. GROUP BYE. ORDER BY

2.Which two are true about aggregate functions?（）A、You can use aggregate functions in any clause of a SELECT statement.B、You can use aggregate functions only in the column list of the select clause and in the WHERE clause of a SELECT statement.C、You can mix single row columns with aggregate functions in the column list of a SELECT statement by grouping on the single row columns.D、You can pass column names, expressions, constants, or functions as parameter to an aggregate function.E、You can use aggregate functions on a table, only by grouping the whole table as one single group.F、You cannot group the rows of a table by more than one column while using aggregate functions.

3.You want the size of the tablespace to increase when it is full. Which option would you use？（）A、use automatic extent allocationB、disable threshold for the tablespaceC、use freelists to manage the free spaceD、use automatic segment space managementE、create the tablespace as a bigfile tablespaceF、use the RESIZE clause while creating the tablespaceG、enable AUTOEXTEND for at least one of the data files in the tablespace

4.The EMP table contains these columns:You need to display the employees who have not been assigned to any department.You write the SELECT statement:What is true about this SQL statement?()A. The SQL statement displays the desired results.B. The column in the WHERE clause should be changed to display the desired results.C. The operator in the WHERE clause should be changed to display the desired results.D. The WHERE clause should be changed to use an outer join to display the desired results.

更多“Which clause should you use to e”相关问题

  • 第1题：

    You work as a Web Developer at Certkiller.com. You are in the process of creating a Webapplication using Microsoft ASP.NET 3.5.  You create a folder named Dark in the App_Themes folder of the Web application. You also addfour skin files to this folder. You have to make sure that the controls on a page have their appearances overridden by the control definitions defined in the skin files. What should you do？  Which Page directive should you use？（）

    • A、You should use the page directive: <%@ Page StyleSheetTheme="App_Themes.Dark"/>
    • B、You should use the page directive: <%@ Page Theme="App_Themes.Dark"/>
    • C、You should use the page directive: <%@ Page Theme="Dark"/>
    • D、You should use the page directive: <%@ Page StyleSheetTheme="Dark"/>

    正确答案:C

  • 第2题：

    When shrinking a table segment， you choose to shrink all the indexes for that table using the SHRINK SPACE command. Which clause should you use？（）

    • A、 INCLUDING DEPENDENCIES
    • B、 INCLUDING DEPENDENCIES CASCADE
    • C、 COMPACT
    • D、 CASCADE
    • E、 None of the above

    正确答案:D

  • 第3题：

    You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. A user reports that when he runs a query, it takes a quite long time and it is still unfinished. As the IT support, you have to verify whether the query is blocked.  Which tool should you use? （） 

    • A、You should use the Database Engine Tuning Advisor tool 
    • B、You should use the Windows System Monitor tool 
    • C、You should use the Job Activity Monitor tool in Microsoft SQL Server Management Studio 
    • D、You should use the Activity Monitor tool in Microsoft SQL Server Management Studio

    正确答案:D

  • 第4题：

    You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. The instance contains a database named DB1. An application which is continuously connected uses DB1. The application extensively uses the INSERT command and triggers the population of multiple tables. Now you notice that the application has a poor performance. You doubt that this problem has something to do with blocking. You have to monitor the state of the instance at regular intervals while not affecting the application performance further.  Which tool should you use? （） 

    • A、You should use Dynamic Management Views 
    • B、You should use SQL Server Resource Governor 
    • C、You should use SQL Server Profiler 
    • D、You should use Windows System Monitor

    正确答案:A

  • 第5题：

    You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a n On-Line Analytical Processing （OLAP） database named in the instance. The database contains a dimension table named Clients. Ever hour backup of data of the Clients table is performed. But the Clinets table contains redundant data. You must keep the disk space used to store the Clients table.  In the options below， which compression technology should you use？（）

    • A、You should use row compression 
    • B、You should use page compression 
    • C、You should use backup compression 
    • D、You should use windows NTFS file system compression

    正确答案:B

  • 第6题：

    You work as the IT professional in an international company which is named wiikigo. You are experienced in implementing and administering a network operating system. You are specialized in configuring IP addressing and services. Configuring name resolution and network access and so on.Your company is desigiing its network. The network will use an IPv6 prefix of 2001:DB8: BBCC:0000::/53. You have to identify an IPv6 addressing scheme that will support 2000 subnets. Which network mask should you use?（）

    • A、You should use /63.
    • B、You should use /64.
    • C、You should use /61.
    • D、You should use /62.

    正确答案:B

  • 第7题：

    单选题
    You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. Today you notice that applications that run on the server have poor performances. You doubt that this has something to do with table scans. You have to capture the appropriate information by using an appropriate Windows System Monitor object. In the options below, which performance object should you use? （）
    A

    You should use SQLServer:Buffer Manager

    B

    You should use SQLServer:Memory Manager 

    C

    You should use SQLServer:Databases 

    D

    You should use SQLServer:Access Methods


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

  • 第8题：

    多选题
    You are creating a destination NAT rule-set. Which two are valid for use with the from clause？（）
    A

    security policy

    B

    interface

    C

    routing-instance

    D

    IP address


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

  • 第9题：

    单选题
    Which clause should you use to exclude group results?（）
    A

    WHERE

    B

    HAVING

    C

    RESTRICT

    D

    GROUP BY

    E

    ORDER BY


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

  • 第10题：

    单选题
    You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. The instance contains a database named DB1. An application which is continuously connected uses DB1. The application extensively uses the INSERT command and triggers the population of multiple tables. Now you notice that the application has a poor performance. You doubt that this problem has something to do with blocking. You have to monitor the state of the instance at regular intervals while not affecting the application performance further.  Which tool should you use? （）
    A

    You should use Dynamic Management Views 

    B

    You should use SQL Server Resource Governor 

    C

    You should use SQL Server Profiler 

    D

    You should use Windows System Monitor


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

  • 第11题：

    单选题
    You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. In the database, a small percentage of data is modified everyday. Ever day in the morning, you have to create a read-only copy of the database for reporting purposes and make sure that you use as little disk space as possible.  In the options below, which strategy should you use? （）
    A

    You should use database snapshots 

    B

    You should use database backup and restore 

    C

    You should use database backup and restore along with compression 

    D

    You should use schema-bound views in a read-only database. The database resides on the same instance.


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

  • 第12题：

    单选题
    You need to recommend which protocol to use for the planned App-V deployment. Which protocol should you recommend？（）
    A

    SMB

    B

    RTSPS

    C

    CIFS

    D

    HTTPS


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

  • 第13题：

    You are creating a locally managed tablespace to meet the following requirements： All the extents should be of the same size.  The data should be spread across two data files.  A bitmap should be used to record the free space within the allocated extents. Which three options would you choose？（）

    • A、set PCTFREE and PCTUSED to 50
    • B、specify extent allocation as Uniform
    • C、specify extent allocation as Automatic
    • D、create the tablespace as bigfile tablespace
    • E、create the tablespace as smallfile tablespace
    • F、set segment space management to Automatic
    • G、use the RESIZE clause while creating the tablespace

    正确答案:B,E,F

  • 第14题：

    You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a computer which hosts several applications in your company. The instance runs on the computer. A job named DiliveryList is created by you. This job requires a file to be written to a file server. But because the job cannot access the file server, it fails to run. You intend to configure the SQL Server Agent service so that only the SQL Server Agent service has read and write access to the file server. Which account type should you use? （） 

    • A、You should use local Service account
    • B、You should use network Service account
    • C、You should use domain account
    • D、You should use local System account

    正确答案:C

  • 第15题：

    You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. In the database, a small percentage of data is modified everyday. Ever day in the morning, you have to create a read-only copy of the database for reporting purposes and make sure that you use as little disk space as possible.  In the options below, which strategy should you use? （） 

    • A、You should use database snapshots 
    • B、You should use database backup and restore 
    • C、You should use database backup and restore along with compression 
    • D、You should use schema-bound views in a read-only database. The database resides on the same instance.

    正确答案:A

  • 第16题：

    You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. Today you notice that applications that run on the server have poor performances. You doubt that this has something to do with table scans. You have to capture the appropriate information by using an appropriate Windows System Monitor object. In the options below, which performance object should you use? （） 

    • A、You should use SQLServer:Buffer Manager
    • B、You should use SQLServer:Memory Manager 
    • C、You should use SQLServer:Databases 
    • D、You should use SQLServer:Access Methods

    正确答案:D

  • 第17题：

    You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named Dworks in the instance. The Dworks database has a table named Orderthings. The Orderthings table is partitioned on the OrderId column. The first partition contains integer values greater than 100,000, while the second partition contains integer values between 1 and 100,000. You have to add a new partition. The new partition should contain integer values greater than 200,000. What should you do? （）

    • A、A new partition function should be created 
    • B、You should change the existing partition scheme 
    • C、You should use a Merge clause to change the existing partition function 
    • D、You should use a Split clause to change the existing partition function 

    正确答案:D

  • 第18题：

    单选题
    You work as the IT professional in an international company which is named wiikigo. You are experienced in implementing and administering a network operating system. You are specialized in configuring IP addressing and services. Configuring name resolution and network access and so on.Your company is desigiing its network. The network will use an IPv6 prefix of 2001:DB8: BBCC:0000::/53. You have to identify an IPv6 addressing scheme that will support 2000 subnets. Which network mask should you use?（）
    A

    You should use /63.

    B

    You should use /64.

    C

    You should use /61.

    D

    You should use /62.


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

  • 第19题：

    单选题
    When shrinking a table segment， you choose to shrink all the indexes for that table using the SHRINK SPACE command. Which clause should you use？（）
    A

     INCLUDING DEPENDENCIES

    B

     INCLUDING DEPENDENCIES CASCADE

    C

     COMPACT

    D

     CASCADE

    E

     None of the above


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

  • 第20题：

    单选题
    You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a n On-Line Analytical Processing （OLAP） database named in the instance. The database contains a dimension table named Clients. Ever hour backup of data of the Clients table is performed. But the Clinets table contains redundant data. You must keep the disk space used to store the Clients table.  In the options below， which compression technology should you use？（）
    A

    You should use row compression 

    B

    You should use page compression 

    C

    You should use backup compression 

    D

    You should use windows NTFS file system compression


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

  • 第21题：

    单选题
    You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named Dworks in the instance. The Dworks database has a table named Orderthings. The Orderthings table is partitioned on the OrderId column. The first partition contains integer values greater than 100,000, while the second partition contains integer values between 1 and 100,000. You have to add a new partition. The new partition should contain integer values greater than 200,000. What should you do? （）
    A

    A new partition function should be created 

    B

    You should change the existing partition scheme 

    C

    You should use a Merge clause to change the existing partition function 

    D

    You should use a Split clause to change the existing partition function 


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

  • 第22题：

    单选题
    You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. A user reports that when he runs a query, it takes a quite long time and it is still unfinished. As the IT support, you have to verify whether the query is blocked.  Which tool should you use? （）
    A

    You should use the Database Engine Tuning Advisor tool 

    B

    You should use the Windows System Monitor tool 

    C

    You should use the Job Activity Monitor tool in Microsoft SQL Server Management Studio 

    D

    You should use the Activity Monitor tool in Microsoft SQL Server Management Studio


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

  • 第23题：

    单选题
    You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a computer which hosts several applications in your company. The instance runs on the computer. A job named DiliveryList is created by you. This job requires a file to be written to a file server. But because the job cannot access the file server, it fails to run. You intend to configure the SQL Server Agent service so that only the SQL Server Agent service has read and write access to the file server. Which account type should you use? （）
    A

    You should use local Service account

    B

    You should use network Service account

    C

    You should use domain account

    D

    You should use local System account


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

相关内容