假设ABC中的所有列均为字符数据类型，A列的默认值为“VA”，同时还有B列和C列，则执行以下SQL语句：INSERT ABC（A，C）VALUES（‘V’，‘NULL’）后，下列的说法哪一项正确（）。 -题库考试答案搜索网

假设ABC中的所有列均为字符数据类型，A列的默认值为“VA”，同时还有B列和C列，则执行以下SQL语句：INSERT ABC（A，C）VALUES（‘V’，‘NULL’）后，下列的说法哪一项正确（）。

单选题

2022-02-24 03:28

A、插入B列的值为字符‘NULL’
B、插入A列的值为字符VA
C、插入B列的值空值
D、插入C列的值空值

查看答案

正确答案

C

试题解析

执行INSERTABC（A，C）VALUES（‘V’，‘NULL’）SQL语句后，插入B列的值则显示为空值。
NULL：代表声明了一个空对象，不是一个字符串，可以赋给任何对象。空字符：代表声明了一个对象实例，这个对象实例的值是一个长度为0的空字符串。

标签： CMS专题 Oracle认证考试 Oracle认证综合练习

感兴趣题目

假设ABC中的所有列均为字符数据类型，A列的默认值为“VA”，同时还有B列和C列，则执行以下SQL语句：INSERT ABC（A，C）VALUES（‘V’，‘NULL’）后，下列的说法哪一项正确（）。

安全3+1体系认证中的3+1指的是质量管理认证、环境管理认证、职业健康安全管理认证和（）认证。

一个Oracle Server包含一个Oracle Instance和一个Oracle Database。

Every deliberate act of wrongdoing by the master or any of the crew against the ship or cargo，without the authorization or privity of the Shipowner or his agent，is（）.

（）, or drum is used for hauling in or letting out the wires or ropes which will fasten the ship to the shore.

A salvor may be（）the whole or part of the payment due under Salvage Convention to the extent that the salvage operations have become necessary or more difficult because of fault or neglect on his part or if the salvor has been guilty of fraud or other dishonest conduct.

The （） is used for hauling in or letting out the wires or ropes.

Vessels must be（）valid certificate of nationality or certificated of registry or license.

逻辑运算符（AND、NOT、OR）的运算顺序是AND→OR→NOT。

表达式(8+3＞36.OR..T..AND.“A”-“B”$“ABC”)的运算顺序是______。

下面（）不是oracle程序设计中的循环语句。

逻辑运算符（AND、NOT、OR）的运算顺序是AND→OR→NOT。

相关题目: boost的意思是:help or encourage to increase or improve; eloquent的意思是:fluent or persuasive in speaking or writing; A campus emergency ______ occur at any time of the day or night, weekend, or holiday, with little or no warning.; Oracle中的三种系统文件分别是（）。; our database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.Which tool or utility would you use to start the listener?（）; Your database instance is running.You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.Which tool or utility would you use to start the listener?（）; You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference.
Which method or feature should you use?（）; （）any case or suspected case of quarantinable disease，or any case of eruptive disease or any death be discovered，the local quarantine officer must be notified immediately．; 假设(AL)=12H，执行OR AL，AL指令后，ZF和OF的—状态分别为( )。; Oracle提供了多种身份认证方式，包括（）。; 对所有网上银行高风险账户操作使用双重身份认证。双重身份认证由基本身份认证和（）身份认证组成。; Masters are（）solely responsible for all damages or accidents of whatever kind resulting from the navigating or handling of their vessels by day or by night.; 系统中雷达状态包括Unknown、Operational（or ON）、Failed（or OFF）、Detached。; The carrier is liable for loss of or damage to the goods or delay in delivery caused by fire，（）the claimant proves that the fire arose from fault or neglect on the part of the carrier，his servants or agents.; 以下ORACLE认证的级别由低到高排列正确的是（）; Shutdown price（or point，or rule）停业价格（或停业点、停业原则）; Which task would you perform before you run Oracle Universal Installer （OUI） in silent or suppressedmode for an installation（）; Which task would you perform before you run Oracle Universal Installer （OUI） in silent or suppressed mode foran installation？（）; 翻译：With Average or With Particular Average（WA or WPA）（）; 设有以下一综合型表达式，该表达式的运算结果为______。 200＜100+15 AND"AB"+"EFG"＞"ABC" OR NOT"Pro "$" FoxPro"

广告位招租WX:84302438

题库考试答案搜索网

免费的网站请分享给朋友吧