What is true of using group functions on columns that contain NULL values?（）A、Group functions on columns ignore NULL values.B、Group functions on columns returning dates include NULL values.C、Group functions on columns returning numbers include NULL values.D、Group functions on columns cannot be accurately used on columns that contain NULL values.E、Group functions on columns include NULL values in calculations if you use the keyword INC_NULLS.
What is true of using group functions on columns that contain NULL values?（）
- A、Group functions on columns ignore NULL values.
- B、Group functions on columns returning dates include NULL values.
- C、Group functions on columns returning numbers include NULL values.
- D、Group functions on columns cannot be accurately used on columns that contain NULL values.
- E、Group functions on columns include NULL values in calculations if you use the keyword INC_NULLS.
相关考题：
有如下程序include using namespace std;class A{public:virtual void func1 (){ cou 有如下程序#include ＜iostream＞using namespace std;class A{public:virtual void func1 (){ cout＜＜"A1"; }void func2(){ cout＜＜"A2"; }};class B: public A{public:void func l(){ cout＜＜"B1"; }void func2(){ cout＜＜"B2"; }};int main() {A *p=new B;p-＞func1();p-＞func2();return 0;}运行此程序，屏幕上将显示输出( )。A．B1B2B．A1A2C．B1A2D．A1B2
What is true about updates through a view? () A. You cannot update a view with group functions.B. When you update a view group functions are automatically computed.C. When you update a view only the constraints on the underlying table will be in effect.D. When you update a view the constraints on the views always override the constraints on the underlying tables.
下面程序执行后的结果是()。includeusing namespace std;void func1(int i);void func 下面程序执行后的结果是( )。 #include＜iostream＞ using namespace std； void func1(int i); void func2(int i); char st[]="hello, friend!"; void func1(int i) { cout＜＜st[i]; if(i＜3){i+=2;func2(i);} } void func2(int i) { cout＜＜st[i]； if(i＜3){i+=2;func1(i);} } void main() { int i=0;func1(i);cout＜＜endl；}A．elloB．helC．hloD．him
Which three statements about bidirectional PIM are true？（）A、Traffic for a bidirectional group flows along the one shared tree and simultaneously utilizes multiple paths in a redundant network topologyB、It does not require any traffic signaling in the protocolC、Membership to a bidirectional group is signaled using explicit Join messagesD、It maintains source-specific forwarding stateE、It reduces memory， bandwidth， and CPU requirements
A cluster administrator is concerned about using the forced varyon resource group function. Although the function provides increased data availability if it is enabled for a cluster resource group， management is concerned about data integrity. If a varyonvg command fails， an HACMP forced varyon will only occur if which of the following is true？（） A、 A loss of quorum has occurred on one of the disks in the failed volume group.B、 Selective fallover caused by an application moves a resource group to a takeover node.C、 A check is made to ensure at least one complete copy of all data is available in the volume group.D、 The MISSING_PV=TRUE environment variable has been set causing the volume group to be forced online.
A Cluster Administrator is implementing a custom resource group for a new web application. The goal is to ensure the resource group is always active. Preference should be given to the priority node at startup time，but fallback to the priority node should be scheduled during a nonbusy time. Using custom resource group options， what combination best achieve the desired resource group behavior？（） A、 Online On All Available Nodes，using a setting timerB、 Online On Home Node Only，using a fallback timerC、 Online On Home Node Only，using both setting and fallback timersD、 Online On First Available Node，using both settling and fallback timers
Refer to the exhibit. What does the option secret 5 in the username global configuration mode commandindicate about the enable secret password？（）A、It is hashed using SHAB、It is encrypted using DH group 5C、It is hashed using MD5D、It is encrypted via the service password-encryption commandE、It is hashed using a proprietary Cisco hashing algorithmF、It is encrypted using a proprietary Cisco encryption algorithm
Which two of the following statements are true about HSRP load sharing?（） (Choose two)A、It is achieved by using more than one HSRP group.B、It is done in regards to either round robin or weight basis.C、It is used to offload the active router in a certain HSRP group.D、Single group HSRP is used to achieve more efficient link utilization.E、The return traffic is influenced by HSRP load sharing configuration.
Using splitvg to create a snapshot volume group of rootvg results in an error. What is the most likely cause of the error（）A、There is not an available disk to allocate to the snapshot volume groupB、One of the physical volumes associated with rootvg has a status of "missing"C、Rootvg is running in enhanced concurrent modeD、A snapshot volume group cannot be created for the rootvg
A Volume Group appvg has been converted to enhanced concurrent volume mode using C- SPOC. How should the Volume Group be brought online？（） A、 Using varyonvg appvg.B、 Using varyonvg -f appvg.C、 Under the control of resource group management.D、 Automatically at boot time using chvg -ay appvg.
Which statement is true while creating subplans using Resource Manager？（）A、 The subplan must belong to the consumer group， SYS_GROUP.B、 The total CPU usage at any given level must be less than 100%.C、 The subplans can be used to restrict the degree of parallelism for a user.D、 You can use a resource plan instead of a consumer group to implement a priority ranking within the plan.
Which statement about recovering from the loss of a redo log group is true?（）A、If the lost redo log group is ACTIVE, you should first attempt to clear the log file.B、If the lost redo log group is CURRENT, you must clear the log file.C、If the lost redo log group is ACTIVE, you must restore, perform cancel-based incomplete recovery, and open the database using the RESETLOGS option.D、If the lost redo log group is CURRENT, you must restore, perform cancel-based incomplete recovery, and open the database using the RESETLOGS option.
You need to recommend a solution for deploying and managing App2. What should you recommend？（） A、Publish App2 as a RemoteApp program.B、Deploy App2 by using a Group Policy logon script.C、Assign App2 by using Group Policy software distribution.D、Publish App2 by using Group Policy software distribution.
You need to recommend a solution for managing administrative rights for the branch office client computers. The solution must meet the companys technical requirements.What should you recommend configuring？（）A、Account Policies by using GPOsB、Local Users and Groups by using Group Policy preferencesC、Restricted Groups by using GPOsD、Security Options by using Group Policy preferences
单选题What’s not true according to the third paragraph?AGood teamwork means total agreement among members.BThe manager of a work group is the decision—maker.CResponsibility is shared among team members.DIn a group, members have separate assignments.
单选题A Cluster Administrator is implementing a custom resource group for a new web application. The goal is to ensure the resource group is always active. Preference should be given to the priority node at startup time，but fallback to the priority node should be scheduled during a nonbusy time. Using custom resource group options， what combination best achieve the desired resource group behavior？（）A Online On All Available Nodes，using a setting timerB Online On Home Node Only，using a fallback timerC Online On Home Node Only，using both setting and fallback timersD Online On First Available Node，using both settling and fallback timers
单选题Using splitvg to create a snapshot volume group of rootvg results in an error. What is the most likely cause of the error（）AThere is not an available disk to allocate to the snapshot volume groupBOne of the physical volumes associated with rootvg has a status of missingCRootvg is running in enhanced concurrent modeDA snapshot volume group cannot be created for the rootvg
单选题You need to recommend a deployment strategy for App1. What should you recommend？（）AAssign App1 to users by using a Group Policy.BPublish App1 to users by using a Group Policy.CDeploy App1 as a RemoteApp program by using an MSI file.DDeploy App1 as a RemoteApp program by using an RDP file.
多选题Which three statements about bidirectional PIM are true？（）ATraffic for a bidirectional group flows along the one shared tree and simultaneously utilizes multiple paths in a redundant network topologyBIt does not require any traffic signaling in the protocolCMembership to a bidirectional group is signaled using explicit Join messagesDIt maintains source-specific forwarding stateEIt reduces memory， bandwidth， and CPU requirements
单选题You manage Hyper-V host servers and virtual machines （VMs） by using Microsoft System Center Virtual Machine Manager （VMM） 2008 R2. Testers are members of an AD security group named Test. You need to ensure that members of the Test group can create VMs on a specific host server by using the VMM Self-Service Portal. What should you do？（）AIn VMM， specify a template for new VMs created by members of the Test group.BIn VMM， create a Delegated Administrator user role and add the Test group to this role.CIn VMM， assign the Test group the Local Administrator permission for the specific host server.DInstall Hyper-V Manager on the client computer of each member of the Test group， and grant the Test group administrative privileges on the specific host server.
单选题Refer to the exhibit. What does the option secret 5 in the username global configuration mode commandindicate about the enable secret password？（）AIt is hashed using SHABIt is encrypted using DH group 5CIt is hashed using MD5DIt is encrypted via the service password-encryption commandEIt is hashed using a proprietary Cisco hashing algorithmFIt is encrypted using a proprietary Cisco encryption algorithm
单选题Which statement is true while creating subplans using Resource Manager？（）A The subplan must belong to the consumer group， SYS_GROUP.B The total CPU usage at any given level must be less than 100%.C The subplans can be used to restrict the degree of parallelism for a user.D You can use a resource plan instead of a consumer group to implement a priority ranking within the plan.
单选题A Volume Group appvg has been converted to enhanced concurrent volume mode using C- SPOC. How should the Volume Group be brought online？（）A Using varyonvg appvg.B Using varyonvg -f appvg.C Under the control of resource group management.D Automatically at boot time using chvg -ay appvg.
单选题What is true about updates through a view? （）AYou cannot update a view with group functions.BWhen you update a view group functions are automatically computed.CWhen you update a view only the constraints on the underlying table will be in effect.DWhen you update a view the constraints on the views always override the constraints on the underlying tables.
单选题What is true of using group functions on columns that contain NULL values?（）AGroup functions on columns ignore NULL values.BGroup functions on columns returning dates include NULL values.CGroup functions on columns returning numbers include NULL values.DGroup functions on columns cannot be accurately used on columns that contain NULL values.EGroup functions on columns include NULL values in calculations if you use the keyword INC_NULLS.
单选题Which statement about recovering from the loss of a redo log group is true？（）A If the lost redo log group is ACTIVE， you should first attempt to clear the log file.B If the lost redo log group is CURRENT， you must clear the log file.C If the lost redo log group is ACTIVE， you must restore，perform cancel-based incomplete recovery，and open the database using the RESETLOGS option.D If the lost redo log group is CURRENT， you must restore，perform cancel-based incomplete recovery，and open the database using the RESETLOGS option.
多选题Which two of the following statements are true about HSRP load sharing?（） (Choose two)AIt is achieved by using more than one HSRP group.BIt is done in regards to either round robin or weight basis.CIt is used to offload the active router in a certain HSRP group.DSingle group HSRP is used to achieve more efficient link utilization.EThe return traffic is influenced by HSRP load sharing configuration.