Exam Code: C2090-730 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: DB2 9 Family Fundamentals
Certification Provider: IBM
Free Today! Guaranteed Training- Pass C2090-730 Exam.
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for IBM C2090-730 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Free Instant Download NEW C2090-730 Exam Dumps (PDF & VCE):
Available on:
http://www.surepassexam.com/C2090-730-exam-dumps.html
Q41. A table called DEPARTMENT has the following columns:
DEPT_ID
DEPT_NAME
MANAGER
Which of the following statements will ONLY allow user USER1 to modify the DEPT_NAME column?
A. GRANT ALTER ON TABLE department TO user1
B. GRANT ALTER (dept_name) ON TABLE department TO user1
C. GRANT UPDATE ON TABLE department TO user1
D. GRANT UPDATE (dept_name) ON TABLE department TO user1
Answer: D
Explanation:
Q42. 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:
Q43. A number of applications issue the following SQL statement:
SELECT d.deptno, e.empno, e.salary FROM department d INNER JOIN employee e ON d.deptno = e.deptno
A database administrator wishes to store this query within the database. Which of the following database objects can be used to accomplish this?
A. Alias
B. View
C. Schema
D. Trigger
Answer: B
Explanation:
Q44. 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
Q45. Which of the following tools for DB2 V9 allows a user to create and debug a
SQL stored procedure?
A. Control Center
B. Development Center
C. Developer Workbench
D. Stored Procedure Builder Security
Answer: C
Explanation:
Q46. Which of the following best describes the lock protection provided by DB2 for the current row of a cursor?
A. The cursor is only protected from updates and deletes by concurrent applications.
B. The row is only protected from positioned updates and deletes that reference another cursor of the same application.
C. The cursor is protected from positioned updates and deletes that reference another cursor of a different application.
D. The row is protected from updates and deletes by the current application and from positioned updates and deletes that reference another cursor of the same application
Answer: A
Explanation:
Q47. Which of the following resources can be explicitly locked?
A. Row
B. Page
C. Table
D. Column
Answer: C
Explanation:
Q48. Which of the following is used to create and debug user-defined functions?
A. SQL Assist
B. Control Center
C. Command Editor
D. Developer Workbench
Answer: D
Explanation:
Q49. Which of the following DB2 tools allows a user to set DB2 registry parameters?
A. Task Center
B. Visual Explain
C. Configuration Assistant
D. Satellite Administration Center
Answer: C
Explanation:
Q50. A "trusted" client needs to communicate with a server that has been configured to use CLIENT authentication. Which of the following will be used to verify passwords?
A. User ID/password file
B. Communications layer
C. Client applications
D. Operating system
Answer: D
Explanation: