Free IBM 000-730 Exam Dumps Questions & Answers

Which of the following statements is used to prevent user TOM from adding and deleting data in table TAB1?

• A.  REVOKE ADD, DELETE ON TABLE tab1 FROM USER tom
• B.  REVOKE INSERT, DELETE FROM USER tom ON TABLE tab1
• C.  REVOKE ADD, DELETE FROM USER tom ON TABLE tab1
• D.  REVOKE INSERT, DELETE ON TABLE tab1 FROM USER tom

Given the following statements:
CREATE TABLE table1 (col1 INTEGER, col2 CHAR(3)); CREATE VIEW view1 AS
SELECT col1, col2 FROM table1 WHERE col1 < 100 WITH LOCAL CHECK OPTION;
Which of the following INSERT statements will execute successfully?

• A.  INSERT INTO view1VALUES(50, 'abc')
• B.  INSERT INTO view1VALUES(100, 'abc')
• C.  INSERT INTO view1 VALUES (50,abc)
• D.  INSERT INTO view1VALUES(100, abc)

Which of the following DB2 data types can NOT be used to create an identity column?

• A.  SMALLINT
• B.  INTEGER
• C.  DOUBLE
• D.  NUMERIC

Which of the following can be used to ensure that once a row has been inserted in table TABLEX, the column MAINID in that row cannot be updated?

• A.  Define an UPDATE trigger on table TABLEX.
• B.  Define the column MAINID as a FOREIGN KEY.
• C.  Define the column MAINID as NOT UPDATABLE.
• D.  Define the column MAINID as a PRIMARY KEY.

What does the following statement do? GRANT ALTER ON SEQUENCE gen_empid TO user1 WITH GRANT OPTION

• A.  Gives USER1 the ability to change the values returned by the PREVIOUS_VALUE and NEXT_VALUE expressions associated with a sequence named GEN_EMPID, along with the ability to give this authority to other users and groups.
• B.  Gives USER1 the ability to change the comment associated with a sequence named GEN_EMPID, along with the ability to give this authority to other users and groups.
• C.  Gives USER1 the ability to change the values returned by the PREVIOUS_VALUE and NEXT_VALUE expressions associated with a sequence named GEN_EMPID, along with the ability to give CONTROL authority for the sequence to other users and groups.
• D.  Gives USER1 the ability to change the comment associated with a sequence named GEN_EMPID, along with the ability to give this CONTROL authority for the sequence to other users and groups.