6
7
8
9
第1题:
下列SQL语句中,包含了不正确定义语句的组是( )。
Ⅰ. CREATE TABLE CREATE VIEW CREATE INDEX
Ⅱ. DROP TABLE DROP VIEW DROP INDEX
Ⅲ. ALTER TABLE ALTER VIEW ALTER INDEX
A)只有I
B)只有Ⅱ
C)只有Ⅲ
D)Ⅰ和Ⅱ
第2题:
A. CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE = SYSDATE);
B. CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE DEFAULT SYSDATE);
C. CREATE OR REPLACE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE DEFAULT SYSDATE);
D. CREATE OR REPLACE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status NUMBER (10), date_ordered DATE = SYSDATE);
E. CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status NUMBER (10), date_ordered DATE = SYSDATE);
F. CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status NUMBER (10), date_ordered DATE DEFAULT SYSDATE);
第3题:
( 31 )下列 SQL 语句中,哪一(些)组包含了不正确的定义语句?
I . CREATE TABLE … CREATE VIEW … CREATE INDEX …
II . DROP TABLE … DROP VIEW … DROP INDEX …
III . ALTER TABLE … ALTER VIEW … ALTER INDEX …
A )只有 I
B )只有 II
C )只有 III
D ) I 和 II
第4题:
下列SQL语言的定义语句组中,哪一(些)组包含了不正确的定义语句?
I . CREATE TABLE...CREATE VIEW... CREATE INDEX...
Ⅱ. DROP TABLE... DROP VIEW... DROP INDEX...
Ⅲ. ALTER TABLE...ALTER VIEW...ALTER INDEX...
第5题:
下列SQL的数据定义语句组中,哪一(些)组包含了不正确的数据定义语句?
Ⅰ.CREATE TABLE… CREATE VIEW… CREATE INDEX…
Ⅱ.DROP TABLE… DROP VIEW… DROP INDEX…
Ⅲ.ALTER TABLE… ALTER VIEW… ALTER INDEX…
A.仅Ⅰ
B.仅Ⅱ
C.仅Ⅲ
D.都包含
第6题:
create table 语句中有定义主键的选项。 ()
第7题:
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));
第8题:
(32)下列 SQL 的数据定义语句组中,( )包含了不正确的数据定义语句。
Ⅰ.CREATE TABLE? CREATE VIEW? CREATE INDEX?
Ⅱ.DROP TABLE? DROP VIEW? DROP INDEX?
Ⅲ.ALTER TABLE? ALTER VIEW? ALTER INDEX?
A)仅Ⅰ
B)仅Ⅱ
C)仅Ⅲ
D)都包含
第9题:
SQL语言定义完整性约束条件的功能主要体现在( )。
A.CREATE TABLE 语句
B.ALTER TABLE 语句
C.CREATE TABLE 语句或 ALTER TABLE语句
D.CREATE TABLE 语句和 ALTER TABLE语句
第10题:
Given the following DDL for the PARTS table:CREATE TABLE parts (part_no INT(9) NOT NULL, part_name VARCHAR(24), part_remain INT(9));All part numbers entered will be different and all rows should be displayed in order of increasing part numbers whenever the table is queried. Which of the following create index statements will meet this criteria and require the least amount of storage for the index object?()
A.CREATE UNIQUE INDEX idx_partno ON parts(part_no)
B.CREATE UNIQUE INDEX idx_partno ON parts(part_name ASC)
C.CREATE UNIQUE INDEX idx_partno ON parts(part_name, part_no ASC)
D.CREATE UNIQUE INDEX idx_partno ON parts(part_no, part_name ASC)