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 May C2090-730 Study Guide Questions:
Q41. After the following SQL statement is executed:
GRANT ALL PRIVILEGES ON TABLE employee TO USER user1
Assuming user USER1 has no other authorities or privileges, which of the following actions is user USER1 allowed to perform?
A. Drop an index on the EMPLOYEE table
B. Grant all privileges on the EMPLOYEE table to other users
C. Alter the table definition
D. Drop the EMPLOYEE table
Answer: C
Explanation:
Q42. 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:
Q43. Given the following statements:
CREATE TABLE tab1 (c1 INTEGER, c2 CHAR(5));
CREATE VIEW view1 AS SELECT c1, c2 FROM tab1 WHERE c1 < 100;
CREATE VIEW view2 AS SELECT c1, c2 FROM view1
WITH CASCADED CHECK OPTION;
Which of the following INSERT statements will fail to execute?
A. INSERT INTO view2 VALUES(50, 'abc')
B. INSERT INTO view1 VALUES (100, 'abc')
C. INSERT INTO view2 VALUES(150, 'abc')
D. INSERT INTO view1 VALUES(100, 'abc')
Answer: C
Explanation:
Up to the immediate present C2090-730 test questions:
Q44. Which of the following is TRUE for the DB2 isolation level Cursor Stability (CS)?
A. An application process acquires at least a share lock on the current row of every cursor.
B. Any row that is read during a unit of work cannot be changed by other application processes until the unit of work is complete.
C. Any row changed by another application process can be read, even if the change has not been committed by that application process.
D. An application process that issues the same query more than once in a unit of work will not see additional rows caused by other application processes appending new information to the database.
Answer: A
Explanation:
Q45. Which two of the following allow you to perform administrative tasks against database objects?
A. Control Center
B. Journal
C. Command Line Processor
D. Task Center
E. Health Center
Answer: A,C
Explanation:
Q46. Which two of the following statements are true about the HAVING clause?
A. The HAVING clause is used in place of the WHERE clause.
B. The HAVING clause uses the same syntax as the WHERE clause.
C. The HAVING clause can only be used with the GROUP BY clause.
D. The HAVING clause accepts wildcards.
E. The HAVING clause uses the same syntax as the IN clause.
Answer: B,C
Explanation:
Real C2090-730 dumps:
Q47. Which of the following DB2 tools allows a user to execute an SQL statement and view a graphical representation of the access plan?
A. Task Center
B. Command Editor
C. Developer Workbench
D. Command Line Processor
Answer: B
Explanation:
Q48. Given the following table definition:
SALES
SALES_DATE DATE
SALES_PERSON CHAR(20)
REGION CHAR(20)
SALES INTEGER
Which of the following SQL statements will remove all rows that had a SALES_DATE in the year 1995?
A. DELETE * FROM sales WHERE YEAR(sales_date) = 1995
B. DELETE FROM sales WHERE YEAR(sales_date) = 1995
C. DROP * FROM sales WHERE YEAR(sales_date) = 1995
D. DROP FROM sales WHERE YEAR(sales_date) = 1995
Answer: B
Explanation:
Q49. Which of the following are types of routine objects?
A. Package and function
B. Function and userexit
C. Procedure and package
D. Function and procedure
Answer: D
Explanation:
Q50. Which of the following products is used to shred extensible markup language documents?
A. DB2 AVI Extender
B. DB2 Text Extender
C. DB2 XML Extender
D. DB2 Spatial Extender
Answer: C
Explanation: