Examine the following command:CREATE TABLE (prod_id number(4),Prod_name varchar2 (20),Category_id number(30),Quantity_on_hand number (3) INVISIBLE);Which three statements are true about using an invisible column in the PRODUCTS table?（）A. The %ROWTYPE attribute declarations in PL/SQL to access a row will not display the invisible column in the output.B. The DESCRIBE commands in SQL *Plus will not display the invisible column in the output.C. Referential integrity constraint cannot be set on the invisible column.D. The invisible column cannot be made visible and can only be marked as unused.E. A primary key constraint can be added on the invisible column.
Examine the following command:CREATE TABLE (prod_id number(4),Prod_name varchar2 (20),Category_id number(30),Quantity_on_hand number (3) INVISIBLE);Which three statements are true about using an invisible column in the PRODUCTS table?（）
A. The %ROWTYPE attribute declarations in PL/SQL to access a row will not display the invisible column in the output.
B. The DESCRIBE commands in SQL *Plus will not display the invisible column in the output.
C. Referential integrity constraint cannot be set on the invisible column.
D. The invisible column cannot be made visible and can only be marked as unused.
E. A primary key constraint can be added on the invisible column.
相关考题：
You’re going to have a quiz ( )by another two in the ( )month. A. followed,followedB. followed,followingC. following,followedD. following,following
After __________ (examine) the lady, the doctor suggested that his back was badly hurt in the accident.
定义如下枚举类型：enum Number{one=l，tow=2，four=4，eight=8}，则下列语句正确的是( )。A．Number num=1；B．Number num=Number(20)；C．Number num=Number(eight|0xFF)；D．枚举类型Number的取值范围是0～15
定义如下枚举类型：enum Number{one=1,two=2,four=4,eight=8)，则下列语句正确的是( )。A．Number num=1；B．Numbernum=Number(20)；C．Number num=Number(eight│OxFF)；D．枚举类型Number的取值范围是0～15
找出"作者"库表中没有出现在"获奖名单"库表中的所有作者信息的SQL语句,(提示:使用NOT IN,NOT EXISTS,以及外部连接(+)三种方法),并说明那种方法是不优化的出版社: 出版社代码 char(2),出版社名称 varchar2(32)图书: 图书编号 char(8),图书名称 varchar2(128),出版社代码 char(2),作者代号char(4),图书简介 varchar2(128)作者: 作者代号 char(4),作者名称 varchar2(10),性别 char(1),年龄 number(3),文学方向 varchar2(64)获奖名单: 获奖日期 date,获奖人员 char(4)
定义如下枚举类型：enum Number{one=1，tow=2，four=4，eight=8}，则下列语句正确的是( )。A．Number num=1；B．Number num=Number(20)；C．Number num=Number(eight|OxFF)；D．枚举类型Number的取值范围是0～15
tonywouldliketomakeiteasierforusersofthevideoapplicationtoenternewdocusingthe“videoform”,he’dlikeuserstobeabletocreatenew“video”docformwithintheview.Whichoneofthefollowingshouldtonysotobuildthisinterface?（）A.createaviewactionthathasthefollowingformula：@command（[create]；”video”）B.createaformactionthathasthefollowingformula：@command（[compose]；”video”）C.createaviewactionthathasthefollowingformula：@command（[compose]；”video”）D.createadatabaseactionthathasthefollowingformula：@command（[compose]；”video”）
【单选题】对于建立在数据库上的DDL触发器，常用的激活DDL触发器的事件不包括（）A．Create_Table，Alter_Table，Drop_TableB．Create_View，Alter_View，Drop_ViewC．Create_Procedure，Alter_Procedure，Drop_ProcedureD．Rollback
23、假定 number=4，下面哪个语句不会出错？A．print(format(number, "2d"), format(number ** 1.5, "4d"))B．print(format(number, "2d"), format(number ** 1.5, "4.2d"))C．print(format(number, "2d"), format(number ** 1.5, "4.2f"))D．print(format(number, "2f"), format(number ** 1.5, "4.2d"))
如果要让某个用户能够在所有模式下建表应该授予此用户哪个权限？A．create tableB．create any tableC．create all tableD．create * table