更多"The following statements: CREATE TA"的相关试题:
[单项选择] 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. 3
B. 2
C. 1
D. 0
[多项选择]管理员在执行create database benet usebenet create table benet01(column1int,column2int)语句时,发生了错误,如何修改()
A. 分别执行每一句
B. 将各个语句使用go分开再执行
C. 不能将表格命名为benet01
D. 不能将数据库命名为benet
[单项选择] Scott issues the SQL statements: CREATE TABLE dept (deptno NUMBER(2), dname VARCHAR2(14), loc VARCHAR2(13)}; GRANT SELECT ON DEPT T0 SUE; If Sue needs to select from Scott's DEPT table, which command should she use?()
A. SELECT*FROMDEPT;
B. SELECT*FROMSCOTT.DEPT;
C. SELECT*FROMDBASCOTTDEPT;
D. SELECT*FROMALL_USERSWHEREUSER_NAME=';SCOTT';ANDTABLENAME=';DEPT';;
[单项选择]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));
[多项选择] 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.
[单项选择] Evaluate the set of SQL statements: CREATE TABLE dept (deptno NUMBER(2), dname VARCHAR2(14), loc VARCHAR2(13)); ROLLBACK; DESCRIBE DEPT What is true about the set?()
A. The DESCRIBE DEPT statement displays the structure of the DEPT table.
B. The ROLLBACK statement frees the storage space occupied by the DEPT table.
C. The DESCRIBE DEPT statement returns an error ORA-04043: object DEPT does not exist.
D. The DESCRIBE DEPT statement displays the structure of the DEPT table only if there is a COMMIT statement introduced before the ROLLBACK statement.
[单项选择]SQL语言中的CREATE TABLE语句实现哪种功能
A. 数据查询
B. 数据操纵
C. 数据定义
D. 数据控制
[单项选择]在下列SQL语句中,( )包含了不正确的定义语句。 Ⅰ、CREATE TABLE CREATE VIEW CREATE INDEX Ⅱ、DROP TABLE DROP VIEW DROP INDEX Ⅲ、ALTER TABLE ALTER VIEW ALTER INDEX
A. Ⅰ和Ⅱ
B. 只有Ⅱ
C. 只有Ⅲ
D. Ⅱ和Ⅲ
[单项选择] CREATE TABLE dept (deptno NUMBER(2), dname VARCNAR2(14), 1oc VARCNAR2 (13)); ROLLBACK; DESCRIBE DEPT What is true about the set? ()
A. The DESCRIBE DEPT statement displays the structure of the DEPT table.
B. The ROLLBACK statement frees the storage space occupies by the DEPT table.
C. The DESCRIBE DEPT statement returns an error ORA-04043: object DEPT does not exist.
D. The DESCRIBE DEPT statement displays the structure of the DEPT table only if there is a COMMIT statement introduced before the ROLLBACK statement.
[单项选择]用CREATE TABLE建立表时,用来定义域完整性的短语是
A. PRLMARY KEY
B. CHECK
C. ERROR
D. DEFAULT
[单项选择]若用如下的SQL语句创建一个student表:
CREATE TABLE student(NO C(4) NOT NULL,NAME C(8)NOT NULL.SEX C(2),AGEN(2) )
可以插入到student表中的是( )。