Exambible offers free demo for C2090-730 exam. "DB2 9 Family Fundamentals", also known as C2090-730 exam, is a IBM Certification. This set of posts, Passing the IBM C2090-730 exam, will help you answer those questions. The C2090-730 Questions & Answers covers all the knowledge points of the real exam. 100% real IBM C2090-730 exams and revised by experts!
♥♥ 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
Q61. Which of the following is an accurate statement about packages?
A. Packages provide a logical grouping of database objects.
B. Packages contain control structures that are considered the bound form for SQL statements
C. Packages describe the objects in a DB2 database and their relationship to each other
D. Packages may be used during query optimization to improve the performance for a subset of SELECT queries
Answer: B
Explanation:
92. Given the following information:
Protocol: TCP/IP
Port Number: 5000
Host Name: DB_SERVER
Database Name: TEST_DB
Database Server Platform: Linux
Which of the following will allow a client to access the database stored on the server?
A. CATALOG DATABASE test_db AS test_db REMOTE TCPIP SERVER db_server PORT 5000
OSTYPE LINUX;
B. CATALOG TCPIP NODE 5000 REMOTE SERVER db_server OSTYPE LINUX;
CATALOG DATABASE test_db AS test_db AT NODE db_server AUTHENTICATION SERVER;
C. CATALOG TCPIP NODE db_server REMOTE db_server SERVER 5000 OSTYPE LINUX;
CATALOG DATABASE test_db AS test_db AT NODE db_server AUTHENTICATION SERVER;
D. CATALOG TCPIP NODE db_server REMOTE db_server PORT 5000 OSTYPE LINUX;
CATALOG DATABASE test_db AS test_db AT NODE db_server AUTHENTICATION SERVER;
Answer: C
Explanation:
Q62. Which of the following describes the objects of a DB2 database and their relationships?
A. Instance
B. Table space
C. System catalog
D. Schema repository
Answer: C
Explanation:
Q63. User USER1 has the privileges needed to invoke a stored procedure named GEN_RESUME. User USER2 needs to be able to call the procedure - user USER1 and all members of the group PUBLIC should no longer be allowed to call the procedure. Which of the following statement(s) can be used to accomplish this?
A. GRANT EXECUTE ON ROUTINE gen_resume TO user2 EXCLUDE user1, PUBLIC
B. GRANT EXECUTE ON PROCEDURE gen_resume TO user2;
REVOKE EXECUTE ON PROCEDURE gen_resume FROM user1, PUBLIC;
C. GRANT CALL ON ROUTINE gen_resume TO user2 EXCLUDE user1 PUBLIC
D. GRANT CALL ON PROCEDURE gen_resume TO user2;
REVOKE CALL ON PROCEDURE gen_resume FROM user1, PUBLIC;
Answer: B
Explanation:
Q64. Which of the following is a typical data warehouse query?
A. What is this customer’s address?
B. Does this customer have any unpaid bills?
C. What is the balance in this customers account?
D. What are the total sales for each of the last 6 months?
Answer: D
Explanation:
Q65. What type of constraint is used to ensure that each row inserted into the EMPLOYEE table with a value in the WORKDEPT column has a row with a corresponding value in the DEPTNO column of the DEPARTMENT table?
A. A check constraint on the EMPLOYEE table
B. A unique constraint on the EMPLOYEE table WORKDEPT column
C. A foreign key reference from the DEPARTMENT tables DEPTNO column to the WORKDEPT column ofthe EMPLOYEE table
D. A foreign key reference from the EMPLOYEE tables WORKDEPT column to the DEPTNO column of theDEPARTMENT table
Answer: D
Explanation:
Q66. Which object may be used during query optimization to improve the performance for a subset of SELECT queries?
A. MQT
B. Trigger
C. Read Only Cursor
D. Stored Procedure
Answer: A
Explanation:
94. A DRDA host database resides on a z/OS or an i5/OS system and listens on port 446. The TCP/IP address for this system is 192.168.10.1 and the TCP/IP host name is myhost. Which of the following commands is required to update the local node directory so that a DB2 client can access this DRDA database?
A. CATALOG TCPIP NODE myhost REMOTE db2srv SERVER 446
B. CATALOG TCPIP NODE mydb2srv REMOTE myhost SERVER 446
C. CATALOG TCPIP NODE myhost REMOTE db2srv SERVER 192.168.10.1
D. CATALOG TCPIP NODE mydb2srv REMOTE myhost SERVER 192.168.10.1
Answer: B
Explanation:
Q67. User USER1 holds CONTROL privilege on table TABLE1. Which two of the following statements is user USER1 allowed to execute?
A. GRANT CONTROL ON table1 TO user2
B. GRANT LOAD ON table1 TO user2
C. GRANT INSERT, UPDATE ON table1 TO user2 WITH GRANT OPTION
D. GRANT BINDADD ON table1 TO PUBLIC
E. GRANT ALL PRIVILEGES ON table1 TO PUBLIC
Answer: C,E
Explanation:
Q68. Which of the following strings can NOT be inserted into an XML column using XMLPARSE()?
A. "<employee />"
B. "<name>John Doe</name>"
C. "<?xml version='1.0' encoding='UTF-8' ?>"
D. "<p></p>"
Answer: C
Explanation:
Q69. Given the following tables:
YEAR_2006
EMPID NAME
1 Jagger, Mick
2 Richards, Keith
3 Wood, Ronnie
4 Watts, Charlie
5 Jones, Darryl 6 Leavell, Chuck YEAR_1962 EMPID NAME
1 Jagger, Mick 2 Richards, Keith 3 Jones, Brian 4 Wyman, Bill 5 Watts, Charlie 6 Stewart, Ian
If the following SQL statement is executed, how many rows will be returned?
SELECT name FROM year_2007 UNION ALL SELECT name FROM year_1962
A. 6
B. 9
C. 10
D. 12
Answer: D
Explanation:
Q70. Application A holds an Update lock on a single row and application B is trying to read that row. If both applications are using isolation level UR, which of the following will occur?
A. Application B will read the row.
B. Applications A and B will cause a deadlock situation.
C. Application B will wait until application A releases the Update lock.
D. Application A will be terminated so that application B can read the row.
Answer: A
Explanation: