C. 索引。
D. 触发器。 答案. A
60. 当需要查询某个序列seq_customer_id的初始值,可以使用如下()方式。(第五章) A.
SELECT seq_customer_id.NEXTVALUE from sysdate; B.
SELECT seq_customer_id.NEXTVALUE from dual; C.
SELECT seq_customer_id.NEXTVALUE from DBA.$V_Sequence D.
SELECT seq_customer_id.CURRRENTVALUE from dual;
答案. B
61. 当需要创建一个序列seq_Customer_id,初始值为7,每次增长1,序列最大值为20000,可以使用如下()方式。(第五章) A.
CREATE SEQUENCE seq_customer_id START 7
INCREMENT 1
MAXVALUE 20000; B.
CREATE SEQUENCE seq_customer_id
START WITH 7
INCREMENT BY 1
MAXVALUE 20000; C.
CREATE SEQUENCE seq_customer_id
START WITH 7
INCREMENT BY 1
MAXVALUE WITH 20000; D.
CREATE SEQUENCE seq_customer_id
START WITH 7
INCREMENT 1
MAXVALUE 20000; 答案. B
62. 假设向某个Customer表插入数据,使得Customer_ID列的值引用序列seq_customer_id的下一个值,可以使用()方式。(第五章) A.
INSERT INTO CUSTOMER
(CUSTOMER_ID, CUSTOMER_NAME, \
TRUE_NAME, EMAIL_ADDRESS,PASSWORD_QUESTION,
PASSWORD_ANSWER)
VALUES(SEQ_CUSTOMER_ID.CURVAL,'杨善', 'ys', 'ata','yangsan@ata.net.cn','your name?','yangsan'); B.
INSERT INTO CUSTOMER
(CUSTOMER_ID, CUSTOMER_NAME, \
TRUE_NAME, EMAIL_ADDRESS,PASSWORD_QUESTION,
PASSWORD_ANSWER)
VALUES(SEQ_CUSTOMER_ID.CURRENTVAL,'杨善', 'ys', 'ata','yangsan@ata.net.cn','your name?','yangsan'); C.
INSERT INTO CUSTOMER
(CUSTOMER_ID, CUSTOMER_NAME, \
TRUE_NAME, EMAIL_ADDRESS,PASSWORD_QUESTION,
PASSWORD_ANSWER)
VALUES(SEQ_CUSTOMER_ID.NEXTVAL,'杨善', 'ys', 'ata','yangsan@ata.net.cn','your name?','yangsan'); D.
INSERT INTO CUSTOMER
(CUSTOMER_ID, CUSTOMER_NAME, \
TRUE_NAME, EMAIL_ADDRESS,PASSWORD_QUESTION,
PASSWORD_ANSWER)