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 Apr C2090-730 Study Guide Questions:
Q91. Which of the following statements is used to prevent user TOM from adding and deleting data in table TAB1?
A. REVOKE ADD, DELETE FROM USER tom ON TABLE tab1
B. REVOKE ADD, DELETE ON TABLE tab1 FROM USER tom
C. REVOKE INSERT, DELETE FROM USER tom ON TABLE tab1
D. REVOKE INSERT, DELETE ON TABLE tab1 FROM USER tom
Answer: D
Explanation:
71. Which of the following privileges permits a user to update the comment on a sequence?
A. CONTROL
B. UPDATE
C. USAGE
D. ALTER
Answer: D
Explanation:
Q92. Which of the following is a valid DB2 data type?
A. NUMBER
B. INTERVAL
C. BYTE
D. NUM
Answer: D
Explanation:
215. Which of the following DB2 data types does NOT have a fixed length?
A. INT
B. CHAR
C. XML
D. DOUBLE
Answer: C
Explanation:
Q93. Application A issues the following SQL statements within in a single transaction using the Uncommitted Read isolation level:
SELECT * FROM employee WHERE deptno='A00'
UPDATE employee SET salary = salary * 1.1 WHERE deptno='A00' As long as the transaction has not been committed, which of the following is true for all other applications not running under the Uncommitted Read isolation level?
A. They can read and make changes to data for any employee in department A00.
B. They can read but not make changes to data for any employee in department A00.
C. They must wait until the transaction is committed before accessing data of any employee in department A00.
D. They must wait until application A disconnects before accessing data of any employee in department A00.
Answer: C
Explanation:
Refresh C2090-730 pdf exam:
Q94. If the following SQL statements are executed in the order shown:
CREATE TABLE orders
(order_num INTEGER NOT NULL,
buyer_name VARCHAR(35), amount NUMERIC(5,2));
CREATE UNIQUE INDEX idx_orderno ON orders (order_num);
Which of the following describes the resulting behavior?
A. Every ORDER_NUM value entered must be unique; whenever the ORDERS table is queried rows should be displayed in order of increasing ORDER_NUM values
B. Every ORDER_NUM value entered must be unique; whenever the ORDERS table is queried rows will be displayed in no particular order
C. Duplicate ORDER_NUM values are allowed; no other index can be created for the ORDERS table that reference the ORDER_NUM column
D. Every ORDER_NUM value entered must be unique; no other index can be created for the ORDERS table that reference the ORDER_NUM column
Answer: A
Explanation:
Q95. Given the following table definitions:
DEPARTMENT
DEPTNO CHAR(3)
DEPTNAME CHAR(30)
MGRNO INTEGER
ADMRDEPT CHAR(3)
EMPLOYEE
EMPNO INTEGER
FIRSTNAME CHAR(30) MIDINIT CHAR
LASTNAME CHAR(30)
WORKDEPT CHAR(3)
Which of the following statements will list every employee number and last name, along with the employee number and last name of their manager, including employees that have not been assigned to a manager?
A. SELECT e.empno, e.lastname, m.empno, m.lastname FROM employee e LEFT INNER JOIN department INNER JOIN employee m ON mgrno=m.empno ON e.workdept=deptno
B. SELECT e.empno, e.lastname, m.empno, m.lastname FROM employee e LEFT OUTER JOIN department INNER JOIN employee m ON mgrno=m.empno ON e.workdept=deptno
C. SELECT e.empno, e.lastname, m.empno, m.lastname FROM employee e RIGHT OUTER JOIN department INNER JOIN employee m ON mgrno=m.empno ON e.workdept=deptno
D. SELECT e.empno, e.lastname, m.empno, m.lastname FROM employee e RIGHT INNER JOIN department INNER JOIN employee m ON mgrno=m.empno ON e.workdept=deptno
Answer: B
Explanation:
Q96. Which of the following is a NOT a valid reason for defining a view on a table?
A. Restrict users' access to a subset of table data
B. Ensure that rows inserted remain within the scope of a definition
C. Produce an action as a result of a change to a table
D. Provide users with an alternate view of table data
Answer: C
Explanation:
Download C2090-730 testing material:
Q97. Given the following two tables:
NAMES
NAME NUMBER
Wayne Gretzky 99 Jaromir Jagr 68 Bobby Orr 4 Bobby Hull 23 Mario Lemieux 66
POINTS
NAME POINTS
Wayne Gretzky 244 Bobby Orr 129 Brett Hull 121 Mario Lemieux 189 Joe Sakic 94
How many rows would be returned using the following statement?
SELECT name FROM names, points
A. 0
B. 5
C. 10
D. 25
Answer: D
Explanation:
Q98. Given the following set of statements:
CREATE TABLE tab1 (col1 INTEGER, col2 CHAR(20));
COMMIT;
INSERT INTO tab1 VALUES (123, 'Red');
INSERT INTO tab1 VALUES (456, 'Yellow');
SAVEPOINT s1 ON ROLLBACK RETAIN CURSORS;
DELETE FROM tab1 WHERE col1 = 123;
INSERT INTO tab1 VALUES (789, 'Blue');
ROLLBACK TO SAVEPOINT s1;
INSERT INTO tab1 VALUES (789, 'Green'); UPDATE tab1 SET col2 = NULL WHERE col1 = 789;
COMMIT;
Which of the following records would be returned by the following statement?
SELECT * FROM tab1
A. COL1 COL2
123 Red 456 Yellow 2 record(s) selected.
B. COL1 COL2
456 Yellow 1 record(s) selected.
C. COL1 COL2
123 Red 456 Yellow 789 -3 record(s) selected.
D. COL1 COL2
123 Red 456 Yellow 789 Green 3 record(s) selected.
Answer: C
Explanation:
Q99. A database named TEST_DB resides on a z/OS system and listens on port 446. The TCP/IP address for this system is 192.168.10.20 and the TCP/IP host name is MYHOST. Which of the following commands is required to make this database accessible to a Linux client?
A. CATALOG TCPIP NODE zos_srvr REMOTE myhost SERVER 192.168.10.20;
CATALOG DATABASE zos_db AS test_db AT NODE zos_srvr;
CATALOG DCS DATABASE zos_db AS test_db;
B. CATALOG TCPIP NODE zos_srvr REMOTE myhost SERVER 192.168.10.20;
CATALOG DCS DATABASE zos_db AS test_db AT NODE zos_srvr;
C. CATALOG TCPIP NODE zos_srvr REMOTE myhost SERVER 446;
CATALOG DCS DATABASE zos_db AS test_db AT NODE zos_srvr;
D. CATALOG TCPIP NODE zos_srvr REMOTE myhost SERVER 446;
CATALOG DATABASE zos_db AS test_db AT NODE zos_srvr;
CATALOG DCS DATABASE zos_db AS test_db;
Answer: C
Explanation:
Q100. Which of the following events will NOT cause a trigger to be activated?
A. A select operation
B. An insert operation
C. An update operation
D. A delete operation
Answer: A
Explanation: