Oracle ATA认证题库 下载本文

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)