Which clause would you use in a SELECT statement to limit the display to those employees whose salary is greater then 5000?（）
A、ORDER BY SALARY > 5000
B、GROUP BY SALARY > 5000
C、HAVING SALARY > 5000
D、WHERE SALARY > 5000
有疑问？点此联系我们
收藏该题
查看答案
Which clause would you use in a SELECT statement to limit the display to those employees whose salary is greater then 5000?（）
A、ORDER BY SALARY > 5000
B、GROUP BY SALARY > 5000
C、HAVING SALARY > 5000
D、WHERE SALARY > 5000
Which interconnect topology is supported for pSeries cluster solutions with Cluster Systems Manager？（）
A、ATM
B、Ethernet
C、SP Switch2
D、Fibre Channel
使用两种编码方案对比特流01100111进行编码的结果如下图所示，编码1和编码2分别是（ ）。
A、NRZ和曼彻斯特编码
B、NRZ和差分曼彻斯特编码
C、NRZI和曼彻斯特编码
D、NRZI和差分曼彻斯特编码
In the customer’s environment， a group of five employees work within a room that has three PCs. The PCs have excellent hardware configurations， with considerable RAM and a fast CPU. The employees use these PCs only when they need to access an application， which is for a short duration of time. For the rest of the time， they work with their tools on their desks. Which IBM Tivoli Access Manager for Enterprise Single Sign-On session management configuration should be used for these three PCs for optimum performance？（）
A、Citrix workstation
B、personal workstation
C、shared workstation， private desktop
D、shared workstation， shared desktop
A customer with p615， p630 and p650 pSeries servers installed and running AIX is considering Linux as an additional environment. Which Linux capabilities can the pSeries Sales Specialist present as choices that are available to enhance the existing systems？（）
A、Linux will be restricted to the p650 system， as it is not supported on the p630.
B、The customer can run Linux on all the existing systems with or without the presence of AIX.
C、Linux can run in LPARs on the existing systems but Linux will require the presence of AIX in at least one LPAR.
D、Linux can be installed on all existing systems but will require the AIX Linux Affinity libraries to boot the systems and run Linux.
Which three statements correctly describe the functions and use of constraints? （）
AConstraints provide data independence.
BConstraints make complex queries easy.
CConstraints enforce rules at the view level.
DConstraints enforce rules at the table level.
EConstraints prevent the deletion of a table if there are dependencies.
FConstraints prevent the deletion of an index if there are dependencies.
