Precise of C2090-730 test questions materials and study guides for IBM certification for IT professionals, Real Success Guaranteed with Updated C2090-730 pdf dumps vce Materials. 100% PASS DB2 9 Family Fundamentals exam Today!
2021 May C2090-730 Study Guide Questions:
Q141. What is the lowest privilege and/or authority required to execute the following SQL statement?
CREATE VIEW view1 AS
SELECT * FROM table1
WHERE STATE = 'TX'
A. DBADM authority
B. SYSADM authority
C. SELECT privilege on TABLE1 D. REFERENCES privilege on TABLE1
Answer: C
Explanation:
Q142. Given that tables T1 and T2 contain the following rows:
Table T1: C1 C2
5 4 5 2 5 5 Table T2: C1 C2 5 1
5 2
5 3
Which of the following queries will return only those rows that exist in T1 and not in T2 ?
A. SELECT * FROM T1 MINUS SELECT * FROM T2
B. SELECT * FROM T1 EXCEPT SELECT * FROM T2
C. SELECT * FROM T2 UNION EXCEPT SELECT * FROM T1
D. SELECT * FROM T1 NOT EXISTS SELECT * FROM T2
Answer: B
Explanation:
Q143. What does the following statement do?
GRANT REFERENCES (col1, col2) ON TABLE table1 TO user1 WITH
GRANT OPTION
A. Gives user USER1 the ability to refer to COL1 and COL2 of table TABLE1 in queries, along with the ability to give this authority to other users and groups.
B. Gives user USER1 the ability to refer to COL1 and COL2 of table TABLE1 in views, along with the ability to give this authority to other users and groups.
C. Gives user USER1 the ability to define a referential constraint on table TABLE1 using columns COL1 and COL2 as the parent key of the constraint.
D. Gives user USER1 the ability to define a referential constraint on table TABLE1 using columns COL1 and COL2 as the foreign key of the constraint.
Answer: C
Explanation:
Renewal C2090-730 exam engine:
Q144. To which of the following resources can a lock NOT be applied?
A. Table spaces
B. Buffer pools
C. Tables
D. Rows
Answer: B
Explanation:
Q145. A programmer wants to generate values for a numeric ID column in their EXPENSE table. The ID column values need to be incremented by 1000 for each new expense report added to the EXPENSE table. Which DB2 object can be referenced by an INSERT statement to meet this requirement?
A. Sequence
B. Table Function
C. Identity Column
D. INSTEAD OF Trigger
Answer: A
Explanation:
Q146. Which of the following deletion rules on CREATE TABLE will allow parent table rows to be deleted if a dependent row exists?
A. ON DELETE RESTRICT
B. ON DELETE NO ACTION
C. ON DELETE SET NO VALUE
D. ON DELETE CASCADE
Answer: D
Explanation:
Realistic C2090-730 braindumps:
Q147. Given the following insert statement:
INSERT INTO product ( pid, description ) VALUES ( '100-100-01', XMLPARSE ( DOCUMENT
'<product xmlns="http://posample.org" pid=''100-100-01'' > <description> <name>Snow Shovel,
Basic 22in</name> <details>Basic Snow Shovel, 22in wide, straight handle with D-Grip</details>
<price>9.99</price> <weight>1 kg</weight> </description> </product>' PRESERVE
WHITESPACE ) );
Which of the following table definitions will support the insert statement above?
A. CREATE TABLE product
( pid XML NOT NULL PRIMARY KEY,
name VARCHAR(128),
price DECIMAL(30,2),
promoprice DECIMAL(30,2),
promostart DATE,
promoend DATE,
description XML);
B. CREATE TABLE product
( pid VARCHAR(10) NOT NULL PRIMARY KEY,
name VARCHAR(128),
price DECIMAL(30,2),
promoprice DECIMAL(30,2),
promostart DATE,
promoend DATE,
description XML);
C. CREATE TABLE product
( pid XML NOT NULL PRIMARY KEY,
name VARCHAR(128),
price DECIMAL(30,2),
promoprice DECIMAL(30,2),
promostart DATE,
promoend DATE,
description VARCHAR(1000));
D. CREATE TABLE product
( pid VARCHAR(10) NOT NULL PRIMARY KEY,
name VARCHAR(128),
price DECIMAL(30,2),
promoprice DECIMAL(30,2),
promostart DATE,
promoend DATE,
description VARCHAR(1000));
Answer: B
Q148. Given the following table:
CURRENT_EMPLOYEES
EMPID INTEGER NOT NULL
NAME CHAR(20)
SALARY DECIMAL(10,2) PAST_EMPLOYEES
EMPID INTEGER NOT NULL
NAME CHAR(20)
SALARY DECIMAL(10,2)
Assuming both tables contain data, which of the following statements will NOT successfully add data to table CURRENT_EMPLOYEES?
A. INSERT INTO current_employees (empid) VALUES (10)
B. INSERT INTO current_employees VALUES (10, 'JAGGER', 85000.00)
C. INSERT INTO current_employees SELECT empid, name, salary FROM past_employees WHERE empid = 20
D. INSERT INTO current_employees (name, salary) VALUES (SELECT name, salary FROM past_employees WHERE empid = 20)
Answer: D
Explanation:
Q149. Given the following expression:
SELECT QUANTITY,
CASE WHEN ITEMCODE = '099' THEN "SILVER"
WHEN ITEMCODE = '788' THEN "GOLD"
WHEN ITEMCODE = '899' THEN "PLATINUM"
ELSE ERROR
END
FROM SUPPLIER What will be the result of the query if the following data is evaluated by the CASE expression?
QUANTITY ITEMCODE
3 099
4 099
1 788
1 899
5 009
3 788
1 899
A. 3, SILVER 4, GOLD 1, SILVER 1, GOLD 5, PLATINUM 3, SILVER 1, GOLD
B. 3, SILVER 4, SILVER 1, GOLD 1, PLATINUM 5, ERROR 3, GOLD 1, PLATINUM
C. C. C. 3, SILVER 4, SILVER 1, PLATINUM 1, ERROR 5, SILVER 3, GOLD 1, PLATINUM
D. D. D. 3, SILVER 4, SILVER 1, GOLD 1, GOLD 5, SILVER 3, ERROR 1, PLATINUM
Answer: B
Explanation:
Q150. Application A currently holds an exclusive lock on a single row and application B tries to access that row. If lock timeout is set to -1 and both applications are using isolation level RS, which of the following will occur?
A. Applications A and B will cause a deadlock situation.
B. Application B will read the previous version of the row.
C. Application B will read the row and see uncommitted changes made by application A.
D. Application B will be placed in a lock-wait state until application A releases its lock.
Answer: D
Explanation: