你定义了一个对象类型myOBJ，要基于该类型来创建表tab1，语句为（）。A、CREATE TABLE tab1 OF myOBJB、CREATE TABLE myOBJ OF tab1C、CREATE TABLE tab1 AS myOBJD、CREATE TABLE tab1 TYPE OF myOBJ
你定义了一个对象类型myOBJ，要基于该类型来创建表tab1，语句为（）。
- A、CREATE TABLE tab1 OF myOBJ
- B、CREATE TABLE myOBJ OF tab1
- C、CREATE TABLE tab1 AS myOBJ
- D、CREATE TABLE tab1 TYPE OF myOBJ
相关考题：
（32）下列 SQL 的数据定义语句组中，（ ）包含了不正确的数据定义语句。Ⅰ．CREATE TABLE? CREATE VIEW? CREATE INDEX?Ⅱ．DROP TABLE? DROP VIEW? DROP INDEX?Ⅲ．ALTER TABLE? ALTER VIEW? ALTER INDEX?A）仅ⅠB）仅ⅡC）仅ⅢD）都包含
下列SQL语句中，包含了不正确定义语句的组是（ ）。Ⅰ. CREATE TABLE CREATE VIEW CREATE INDEXⅡ. DROP TABLE DROP VIEW DROP INDEXⅢ. ALTER TABLE ALTER VIEW ALTER INDEXA)只有IB)只有ⅡC)只有ⅢD)Ⅰ和Ⅱ
SQL语言定义完整性约束条件的功能主要体现在( )。A．CREATE TABLE 语句B．ALTER TABLE 语句C．CREATE TABLE 语句或 ALTER TABLE语句D．CREATE TABLE 语句和 ALTER TABLE语句
Which of the following statements is used to grant user TOM and Application team APPGRP the ability to add data to table TAB1?() A.GRANT ADD DATA ON TABLE tab1 TO GROUP tom appgrpB.GRANT INSERT TO USER tom, GROUP appgrp ON TABLE tab1C.GRANT INSERT ON TABLE tab1 TO USER tom, GROUP appgrpD.GRANT ADD DATA ON TABLE tab1 TO USER appgrp, GROUP tom
Given the following statements:CREATE TABLE tab1 (col1 INT); CREATE TABLE tab2 (col1 INT); CREATE TRIGGER trig1 AFTER UPDATE ON tab1 REFERENCING NEW AS new1 FOR EACH ROW MODE DB2SQL INSERT INTO tab2 VALUES(new1.col1); INSERT INTO tab1 VALUES(2),(3);What is the result of the following query? SELECT count(*) FROM tab2;（）A.3B.2C.1D.0
The following triggers were defined for table TAB1 in the order shown:CREATE TRIGGER trig_a AFTER UPDATE ON tab1 FOR EACH ROW UPDATE sale_tab SET sale_date = CURRENT DATE; CREATE TRIGGER trig_b AFTER UPDATE ON tab1 FOR EACH STATEMENT UPDATE invoice_tab SET invoice_date = CURRENT DATE; CREATE TRIGGER trig_c AFTER UPDATE ON tab1 FOR EACH ROW UPDATE shipping_tab SET ship_date = CURRENT DATE; CREATE TRIGGER trig_d AFTER UPDATE ON tab1 FOR EACH STATEMENT UPDATE billing_tab SETbilling_date = CURRENT DATE;If an event occurs that causes all of them to activate, which trigger will be activated first?（）A.TRIG_AB.TRIG_BC.TRIG_CD.TRIG_D
下列哪种方法不能用于创建索引?_______A.使用CREATE INDEX语句B.使用CREATE TABLE语句C.使用ALTER TABLE语句D.使用CREATE DATABASE语句
你定义了一个对象类型myOBJ,要基于该类型来创建表tab1,语句为()。 A.CREATE TABLE tab1 OF myOBJB.CREATE TABLE myOBJ OF tab1C.CREATE TABLE tab1 AS myOBJD.CREATE TABLE tab1 TYPE OF myOBJ
假设需要回收为用户test授予的CREATE ANY TABLE系统权限,可以使用如下()语句。 A.TAKE BACK CREATE ANY TABLE FROM testB.REVOKE CREATE ANY TABLE FROM testC.REVOKE CREATE ANY TABLE testD.TAKE BACK CREATE ANY TABLE test
假设在数据库中创建了用户test,需要为其授予CREATE ANY TABLE系统权限,可以使用如下()语句。 A.GRANT CREATE ANY TABLE testB.GRANT CREATE ANY TABLE TO testC.TAKE CREATE ANY TABLE TO testD.ALTER CREATE ANY TABLE TO test
在下列SQL语句中，（ ）包含了不正确的定义语句。Ⅰ、CREATE TABLE CREATE VIEW CREATE INDEXⅡ、DROP TABLE DROP VIEW DROP INDEXⅢ、ALTER TABLE ALTER VIEW ALTER INDEXA）Ⅰ和ⅡB）只有ⅡC）只有ⅢD）Ⅱ和Ⅲ
向“仓库”表中新增一个“人数”字段，数据类型为数值型，宽度为2，正确的命令语句是（ ）。A)CREATE TABLE 仓库 ALTER 人数 N(2)B)CREATE TABLE 仓库 ADD FIELDS 人数 N(2)C)ALTER TABLE 仓库 ALTER 人数 N(2)D)ALTER TABLE 仓库 ADD 人数 N(2)
下列哪个语句将赋予用户John向表tab1中插入数据的权限？（）A、GRANT ADD ON TABLE tab1 TO JohnB、GRANT INSERT ON tab1 TO JohnC、GRANT ADD ON TABLE tab1 TO USER JohnD、GRANT INSERT ON TABLE tab1 TO USER John
Table TAB1 was created using the following statement: CREATE TABLE tab1 (c1 INT, c2 INT, c3 INT, c4 INT, c5 INT); If column C1 is unique and queries typically access columns C1, C2 and C3 together, which statement(s) will createindex(es) that will provide optimal query performance?（）A、CREATE UNIQUE INDEX xtab1 ON tab1 (c1); CREATE INDEX xtab2 ON tab1 (c2) INCLUDE (c3) B、CREATE UNIQUE INDEX xtab1 ON tab1 (c1) INCLUDE (c2, c3) C、CREATE UNIQUE INDEX xtab1 ON tab1 (c3, c2, c1) D、CREATE UNIQUE INDEX xtab1 ON tab1 (c2) INCLUDE (c1, c3)
Which of the following statements is used to grant user TOM and Application team APPGRP the ability to add data to table TAB1?（）A、GRANT ADD DATA ON TABLE tab1 TO GROUP tom appgrpB、GRANT INSERT TO USER tom, GROUP appgrp ON TABLE tab1C、GRANT INSERT ON TABLE tab1 TO USER tom, GROUP appgrpD、GRANT ADD DATA ON TABLE tab1 TO USER appgrp, GROUP tom
Table TAB1 was created using the following statement: CREATE TABLE tab1 (c1 INT, c2 INT, c3 INT, c4 INT, c5 INT); If column C1 is unique and queries typically access columns C1 and C2 together, which statement(s) will create index(es) that will provide optimal query performance? （）A、 CREATE UNIQUE INDEX xtab1 ON tab1 (c1) include (c2)B、 CREATE UNIQUE INDEX xtab1 ON tab1 (c1); CREATE INDEX xtab2 ON tab1 (c3) INCLUDE (c2) C、 CREATE UNIQUE INDEX xtab1 ON tab1 (c2, c1)D、 CREATE UNIQUE INDEX xtab1 ON tab1 (c2) INCLUDE (c1）
如果要创建一张仅包含一个字段的表rb，其字段名为rb，字段类型为字符型，字段宽度为20，则可以用下列的（）命令创建。A、CREATE TABLE rb rb C（20）B、CREATE TABLE rb（rbC（20））C、CREATE TABLE rb FIELD rb C（20）D、CREATE TABLE rb FIELD（rb C（20））
Which of the following statements is used to prevent user TOM from adding and deleting data in table TAB1?（）A、REVOKE ADD, DELETE FROM USER tom ON TABLE tab1B、REVOKE ADD, DELETE ON TABLE tab1 FROM USER tomC、REVOKE INSERT, DELETE FROM USER tom ON TABLE tab1D、REVOKE INSERT, DELETE ON TABLE tab1 FROM USER tom
Given the following statements: CREATE TABLE tab1 (col1 INT); CREATE TABLE tab2 (col1 INT); CREATE TRIGGER trig1 AFTER UPDATE ON tab1 REFERENCING NEW AS new1 FOR EACH ROW MODE DB2SQL INSERT INTO tab2 VALUES(new1.col1); INSERT INTO tab1 VALUES(2),(3); What is the result of the following query? SELECT count(*) FROM tab2;（）A、3B、2C、1D、0
Which is a valid CREATE TABLE statement? （）A、CREATE TABLE EMP9$# AS (empid number(2));B、CREATE TABLE EMP*123 AS (empid number(2));C、CREATE TABLE PACKAGE AS (packid number(2));D、CREATE TABLE 1EMP_TEST AS (empid number(2));
假设在数据库中创建了用户test，需要为其授予CREATE ANY TABLE系统权限，可以使用如下（）语句。A、GRANT CREATE ANY TABLE testB、GRANT CREATE ANY TABLE TO testC、TAKE CREATE ANY TABLE TO testD、ALTER CREATE ANY TABLE TO test
假设需要回收为用户test授予的CREATE ANY TABLE系统权限，可以使用如下（）语句。A、TAKE BACK CREATE ANY TABLE FROM testB、REVOKE CREATE ANY TABLE FROM testC、REVOKE CREATE ANY TABLE testD、TAKE BACK CREATE ANY TABLE test
单选题Table TAB1 was created using the following statement: CREATE TABLE tab1 (c1 INT, c2 INT, c3 INT, c4 INT, c5 INT); If column C1 is unique and queries typically access columns C1, C2 and C3 together, which statement(s) will createindex(es) that will provide optimal query performance?（）ACREATE UNIQUE INDEX xtab1 ON tab1 (c1); CREATE INDEX xtab2 ON tab1 (c2) INCLUDE (c3) BCREATE UNIQUE INDEX xtab1 ON tab1 (c1) INCLUDE (c2, c3) CCREATE UNIQUE INDEX xtab1 ON tab1 (c3, c2, c1) DCREATE UNIQUE INDEX xtab1 ON tab1 (c2) INCLUDE (c1, c3)
单选题Which of the following statements is used to grant user TOM and Application team APPGRP the ability to add data to table TAB1?（）AGRANT ADD DATA ON TABLE tab1 TO GROUP tom appgrpBGRANT INSERT TO USER tom, GROUP appgrp ON TABLE tab1CGRANT INSERT ON TABLE tab1 TO USER tom, GROUP appgrpDGRANT ADD DATA ON TABLE tab1 TO USER appgrp, GROUP tom
单选题你定义了一个对象类型myOBJ，要基于该类型来创建表tab1，语句为（）。ACREATE TABLE tab1 OF myOBJBCREATE TABLE myOBJ OF tab1CCREATE TABLE tab1 AS myOBJDCREATE TABLE tab1 TYPE OF myOBJ