内容发布更新时间 : 2024/11/18 14:45:04星期一 下面是文章的全部内容请认真阅读。

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)