移动端

  • 题王微信公众号

    微信搜“题王网”真题密题、最新资讯、考试攻略、轻松拿下考试

计算机考试 | IBM认证考试

模式切换

0 0 0
我的错题 我的收藏 学习笔记

章节目录

单选题 Which of the following is TRUE for the DB2 isolation level Cursor Stability (CS)?()

A

An application process acquires at least a share lock on the current row of every cursor.

B

Any row that is read during a unit of work cannot be changed by other application processes until the unit of work is complete.

C

Any row changed by another application process can be read, even if the change has not been committed by that application process.

D

An application process that issues the same query more than once in a unit of work will not see additional rows caused by other application processes appending new information to the database.

单选题 Given the following ALTER SEQUENCE statement: ALTER SEQUENCE myseq RESTART WITH 0 INCREMENT BY 1 NO MAXVALUE CACHE 5 ORDER Assuming that the sequence had reached a value of 100 prior to the RESTART, which of the following is true?()

A

The next value will be 0 and the sequence will never use the values 101 to 105.

B

The next value will be 101 to ensure uniqueness between existing and newly generated sequence values.

C

Previously cached values are retained by DB2, and after the restart, will be used for values 101 to 105.

D

The next value will be 0 and DB2 will not ensure uniqueness between existing and newly generated values.

单选题 Which of the following statements allows USER1 to take away read access on the table ORG.TAB1 from USER2?()

A

REVOKE SELECT FROM user2 ON TABLE org.tab1

B

REVOKE SELECT ON TABLE org.tab1 FROM user2

C

REVOKE READ ACCESS FROM user2 ON TABLE org.tab1

D

REVOKE READ ACCESS ON TABLE org.tab1 FROM user2

单选题 Given the following requirements: Create a table to contain employee data, with a unique numeric identifier automatically assigned when a row is added, has an EDLEVEL column that permits only the values 'C', 'H' and 'N', and permits inserts only when a corresponding value for the employee's department exists in the DEPARTMENT table. Which of the following CREATE statements will successfully create this table?()

A

CREATE TABLE emp ( empno SMALLINT NEXTVAL GENERATED ALWAYS AS IDENTITY, firstname VARCHAR(30) NOT NULL, lastname VARCHAR(30) NOT NULL, workdept CHAR(3) NOT NULL, edlevel CHAR(1), PRIMARY KEY emp_pk (empno), FOREIGN KEY emp_workdept_fk ON (workdept) REFERENCES department (deptno), CHECK edlevel_ck VALUES (edlevel IN ('C','H','N')), );

B

CREATE TABLE emp ( empno SMALLINT NOT NULL GENERATED BY DEFAULT AS IDENTITY, firstname VARCHAR(30) NOT NULL, lastname VARCHAR(30) NOT NULL, workdept CHAR(3), edlevel CHAR(1), CONSTRAINT emp_pk PRIMARY KEY (empno), CONSTRAINT emp_workdept_fk FOREIGN KEY (workdept) REFERENCES department (deptno), CONSTRAINT edlevel_ck CHECK edlevel VALUES ('C','H','N') );

C

CREATE TABLE emp ( empno SMALLINT NEXTVAL GENERATED BY DEFAULT AS IDENTITY, firstname VARCHAR(30) NOT NULL, lastname VARCHAR(30) NOT NULL, workdept CHAR(3) NOT NULL, edlevel CHAR(1) CHECK IN ('C','H','N')), CONSTRAINT emp_pk PRIMARY KEY (empno), CONSTRAINT emp_workdept_fk FOREIGN KEY department (deptno) REFERENCES (workdept) );

D

CREATE TABLE emp ( empno SMALLINT NOT NULL GENERATED BY DEFAULT AS IDENTITY, firstname VARCHAR(30) NOT NULL, lastname VARCHAR(30) NOT NULL, workdept CHAR(3), edlevel CHAR(1), CONSTRAINT emp_pk PRIMARY KEY (empno), CONSTRAINT emp_workdept_fk FOREIGN KEY (workdept) REFERENCES department (deptno), CONSTRAINT edlevel_ck CHECK (edlevel IN ('C','H','N')) );

单选题 Which of the following describes the model used by the Geodetic Extender?()

A

Flat earth

B

3-D Square

C

Trapezoidal

D

Round earth

1 2 3 4 5 下一页 尾页 /

到第