ORACLE表达式NVL（phone，’0000-0000’）的含义是（）。A、当phone为字符串0000-0000时显示空值B、当phone为空值时显示0000-0000C、判断phone和字符串0000-0000是否相等D、将phone的全部内容替换为0000-0000
ORACLE表达式NVL（phone，’0000-0000’）的含义是（）。
- A、当phone为字符串0000-0000时显示空值
- B、当phone为空值时显示0000-0000
- C、判断phone和字符串0000-0000是否相等
- D、将phone的全部内容替换为0000-0000
相关考题：
Oracle针对Internet/Intranet的产品是A．Oracle WebServerB．Oracle WebListenerC．Oracle WebAgentD．Oracle 7服务器
The last paragraph is about how to teach a teenagerA．to use the phone in a sensible wayB．to pay for his own telephoneC．to share the phone with friendsD．to answer the phone quickly
网络电话大体可以分成三种:PC－to－PC、PC－to－Phone、()。 A、Phone-to-PhoneB、Phone-to-PCC、Phone-to-InternetD、PC-to-Internet
在Oracle中,下面哪条语句当COMM字段为空时显示0,不为空时显示COMM的值()。 A.select ename,nvl（comm.,0）from empB.select ename,null（comm.,0）from empC.SELECT ename,NULLIF（comm,0）FROM empD.SELECT ename,DECODE（comm.,NULL,0）FROM emp
你试图用下面句子查询数据:()SELECT100／NVL(quantity,0)FROMinventory;为何QUANTITY为null空值时,将导致出错? A.表达式企图被空值除.B.换函数参数数据类型不一致.C.空值不能被转成实际值D.表达式企图被零除.
使用哪些函数可以执行显式数据类型转换？（）A、ROUND、TRUNC、ADD_MONTHSB、LENGTH、SUBSTR、LPAD、TRIMC、TO_CHAR、TO_DATE、TO_NUMBERD、NVL、NVL2、NULLIF
你试图用下面句子查询数据：（）SELECT100/NVL（quantity，0）FROMinventory；为何QUANTITY为null空值时，将导致出错？A、表达式企图被空值除.B、换函数参数数据类型不一致.C、空值不能被转成实际值D、表达式企图被零除.
下列有关组函数的表述中哪个是正确的？（）A、NVL和NVL2可以与组函数一起使用来替换null值，而COALESCE则不能。B、NVL和COALESCE可以与组函数一起使用来替换null值，而NVL2则不能。C、NVL、NVL2和COALESCE都可以与组函数一起使用来替换null值。D、COALESCE可以与组函数一起使用来替换null值，而NVL和NVL2则不能。
Which three actions are required to access the network statistics on a remote Cisco Unified Wireless IP Phone 7921G via a web browser?（）A、Browse to the phone using the MAC address of the phone.B、Use HTTPS:// preceding the address of the phone.C、Change web access to read/write for the MAC address of the phone on Cisco Unified Communications Manager.D、Enter the username and password of the phone.E、Ensure that the host is on the same subnet as the remote phone.
What two situations prevent the supervisor from silently monitoring the phone conversation of an agent in IPCC Express Enhanced?（）A、The agent is logged in and is on the phone. B、The agent is logged in but is not on the phone. C、The supervisor is a participant in a phone call. D、The supervisor is not a participant in a phone call. E、The supervisor has barged in.
A customer has a question about the repairs needed for their desktop computer. While asking their question to a technician, the technician receives a personal phone call on their cell phone. Which of the following should the technician do NEXT?（）A、Ask the customer to wait and answer the phone call.B、Talk on the phone while listening to the customer.C、Hand the phone to a coworker to answer the call.D、Silence the phone and then listen to the customer.
Integration between （） multidata sources and （） is defined as the Grid Link for RAC.A、Oracle WebLogic Server; Oracle DatabaseB、Oracle WebLogic Server clusters; Oracle DatabaseC、Oracle WebLogic Server clusters; Oracle Database RACD、Oracle OC4J; Oracle Database RACE、Oracle WebLogic Server; Oracle OC4J
单选题查询出EMP表中COMM字段为空的记录（）Aselect * from emp where comm='';Bselect * from emp where comm=null;Cselect * from emp where nvl(comm)=0;Dselect * from emp where comm is null;Eselect * from emp where nvl(comm,0)=0;
多选题What two situations prevent the supervisor from silently monitoring the phone conversation of an agent in IPCC Express Enhanced?（）AThe agent is logged in and is on the phone.BThe agent is logged in but is not on the phone.CThe supervisor is a participant in a phone call.DThe supervisor is not a participant in a phone call.EThe supervisor has barged in.
单选题在Oracle中，下面哪条语句当COMM字段为空时显示0，不为空时显示COMM的值（）。Aselect ename,nvl（comm.,0）from empBselect ename,null（comm.,0）from empCSELECT ename,NULLIF（comm,0）FROM empDSELECT ename,DECODE（comm.,NULL,0）FROM emp
单选题使用PC+HONE模式签入的座席，当首个电话接入时，是按照下面流程来接通的假设直接路由到座席（）。AUAP分配呼叫-CTI外呼PHONE-PHONE振铃-PHONE摘机-CTI呼座席-座席振铃-座席摘机-通话BUAP分配呼叫-CTI呼座席-座席振铃-座席摘机-CTI外呼-PHONE振铃-PHONE摘机-通话CUAP分配呼叫-CTI同时呼叫PHONE和座席-PHONE振铃和座席同时振铃-PHONE和座席摘机-通话D以上都不正确
单选题查找authors表中的所有电话号码的首位为4，第二位为0或1的电话号码（）。ASELECT phone FROM authors WHERE phone LIKE’4[1，0]%’BSELECT phone FROM authors WHERE phonein’4[^10]%’CSELECT phone FROM authors WHERE phone LIKE’4_[1，0]%’DSELECT phone FROM authors WHERE phone between’41%’and’40%’
单选题Which of the following is an appropriate title for this passage?ACell Phone Radiation: Is It Harmful?BCell Phone Radiation: Is It Useful?CCell Phone Radiation: Is It Healthy?DCell Phone Radiation: Is It Weak?