Ensurepass.com : Ensure you pass the IT Exams
2017 Nov IBM Official New Released C2090-730
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/C2090-730.html

DB2 9 Family Fundamentals

Question No: 81

If the following statement is executed:

CREATE TABLE employee

(empid INT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 5), name VARCHAR(20),

dept INT CHECK (dept BETWEEN 1 AND 20), hiredate DATE WITH DEFAULT CURRENT DATE,

salary DECIMAL(7,2), PRIMARY KEY(empid),

CONSTRAINT cst1 CHECK (YEAR(hiredate) gt; 2006 OR

Salary gt; 60500));

Which of the following INSERT statements will fail?

  1. INSERT INTO employee VALUES (15, #39;Smith#39;, 5, #39;01/22/2004#39;, 92500.00)

  2. INSERT INTO employee VALUES (DEFAULT, #39;Smith#39;, 2, #39;10/07/2002#39;, 80250.00)

  3. INSERT INTO employee VALUES (20, #39;Smith#39;, 5, NULL, 65000.00)

  4. INSERT INTO employee VALUES (DEFAULT, #39;Smith#39;, 10, #39;11/18/2004#39;, 60250.00)

Answer: D

Question No: 82

Given the following statement:

CREATE TABLE tab1

(col1 SMALLINT NOT NULL PRIMARY KEY,

col2 VARCHAR(200) NOT NULL WITH DEFAULT NONE, col3 DECIMAL(5,2) CHECK (col3 gt;= 100.00),

col4 DATE NOT NULL WITH DEFAULT)

Which of the following definitions will cause the CREATE TABLE statement to fail?

  1. COL1

  2. COL2

  3. COL3

  4. COL4

Answer: B

Question No: 83

Which of the following DB2 data types does NOT have a fixed length?

  1. INT

  2. CHAR

  3. XML

  4. DOUBLE

Answer: C

Question No: 84

Given the following table definition: STOCK:

itemVARCHAR(30)

status CHAR(1) quantity INT price DEC(7,2)

If items are indicated to be out of stock by setting STATUS to NULL and QUANTITY and PRICE to zero, which of the following statements would be used to update the STOCK table to indicate that all the items whose description begins with the letter quot;Squot; are out of stock?

  1. UPDATE stock SET (status = NULL; quantity, price = 0) WHERE item LIKE S%

  2. UPDATE stock SET (status, quantity, price) = (NULL, 0, 0) WHERE item LIKE S%

  3. UPDATE stock SET status = NULL, SET quantity = 0, SET price = 0 WHERE item LIKE #39;S%#39;

  4. UPDATE stock SET (status = NULL), (quantity = 0), (price = 0) WHERE item LIKE S%

Answer: B

Question No: 85

Which of the following is NOT true about schemas?

  1. If a schema name is not specified, either by qualifying a database object name or by executing the SET CURRENTSCHEMA statement, the authorization ID of the current session user is used as the schema name by default

  2. The value assigned to the CURRENT SCHEMA special register is persistent across database restarts

  3. A schema enables the creation of multiple objects in a database without encountering namespace collisions

  4. When most database objects are created, they are either implicitly or explicitly assigned to a schema

Answer: B

Question No: 86

Given the following query:

SELECT last_name, first_name, age, hire_date FROM employee

WHERE age gt; 40

Which of the following clauses must be added to return the rows sorted by AGE, oldest first, and by LAST_NAME, from A to Z?

  1. SORT BY age ASC, last_name

  2. SORT BY age DESC, last_name

  3. ORDER BY age DESC, last_name

  4. ORDER BY age ASC, last_name

Answer: C

Question No: 87

User USER1 wants to utilize an alias to remove rows from a table. Assuming USER1 has no authorities or privileges, which of the following privileges are needed?

  1. DELETE privilege on the table

  2. DELETEprivilege on the alias

  3. DELETE privilege on the alias; REFERENCES privilege on the table

  4. REFERENCES privilege on the alias; DELETE privilege on the table

Answer: A

Question No: 88

If the following SQL statements are executed:

CREATE TABLE make (makeid SMALLINT NOT NULL PRIMARY KEY, make VARCHAR(25));

CREATE TABLE model (modelid SMALLINT,

model VARCHAR(25),

makeid SMALLINT,

CONSTRAINT const1 FOREIGN KEY (makeid) REFERENCES make(makeid) ON DELETE RESTRICT);

And each table created is populated as follows: MAKE

MAKEID MAKE

— —-

  1. Ford

  2. Chevrolet

  3. Toyota MODEL

MODELID MODEL MAKEID

—- —- —-

  1. Mustang 1

  2. Escort 1

  3. Malibu 2

  4. Camry 3

If the following SQL statement is executed: DELETE FROM make WHERE makeid = 1

What is the total number ofrows that will be deleted?

  1. 0

  2. 1

  3. 2

  4. 3

Answer: A

Question No: 89

User USER1 holds CONTROL privilege on table TABLE1. Which two of the following statements is user USER1 allowed to execute?

  1. GRANT CONTROL ON table1 TO user2

  2. GRANTLOAD ON table1 TO user2

  3. GRANT INSERT, UPDATE ON table1 TO user2 WITH GRANT OPTION

  4. GRANT BINDADD ON table1 TO PUBLIC

  5. GRANT ALL PRIVILEGES ON table1 TO PUBLIC

Answer: C,E

Question No: 90

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

  1. REVOKE ADD, DELETE FROM USERtom ON TABLE tab1

  2. REVOKE ADD, DELETE ON TABLE tab1 FROM USER tom

  3. REVOKE INSERT, DELETE FROM USER tom ON TABLE tab1

  4. REVOKE INSERT, DELETE ON TABLE tab1 FROM USER tom

Answer: D

100% Ensurepass Free Download!
Download Free Demo:C2090-730 Demo PDF
100% Ensurepass Free Guaranteed!
Download 2017 EnsurePass C2090-730 Full Exam PDF and VCE

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

2017 EnsurePass IT Certification PDF and VCE