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:
Q121. Given the following DDL and INSERT statements:
CREATE VIEW v1 AS SELECT col1 FROM t1 WHERE col1 > 10;
CREATE VIEW v2 AS SELECT col1 FROM v1 WITH CASCADED CHECK OPTION;
CREATE VIEW v3 AS SELECT col1 FROM v2 WHERE col1 < 100;
INSERT INTO v1 VALUES(5);
INSERT INTO v2 VALUES(5);
INSERT INTO v3 VALUES(20);
INSERT INTO v3 VALUES(100);
How many of these INSERT statements will be successful?
A. 0
B. 1
C. 2
D. 3
Answer: C
Explanation:
Q122. In which of the following scenarios would a stored procedure be beneficial?
A. An application running on a remote client needs to be able to convert degrees Celsius to degrees Fahrenheit and vice versa
B. An application running on a remote client needs to collect three input values, perform a calculation using the values provided, and store the input data, along with the results of the calculation in two different base tables
C. An application running on a remote client needs to track every modification made to a table that contains sensitive data
D. An application running on a remote client needs to ensure that every new employee that joins the company is assigned a unique, sequential employee number
Answer: B
Explanation:
Q123. Given the following two tables: TAB1 C1 C2
A 11 B 12 C 13 TAB2 CX CY
A 21 C 22 D 23
The following results are desired:
C1 C2 CX CY
A 11 A 21 C 13 C 22 -- -- D 23
Which of the following queries will yield the desired results?
A. SELECT * FROM tab1 INNER JOIN tab2 ON c1=cx
B. SELECT * FROM tab1 LEFT OUTER JOIN tab2 ON c1=cx
C. SELECT * FROM tab1 FULL OUTER JOIN tab2 ON c1=cx
D. SELECT * FROM tab1 RIGHT OUTER JOIN tab2 ON c1=cx
Answer: D
Explanation:
Most up-to-date C2090-730 test question:
Q124. Which two of the following are optional and do not have to be specified when creating a table?
A. Table name
B. Column name
C. Default constraint
D. Column data type
E. NOT NULL constraint
Answer: C,E
Explanation:
Q125. Given the following CREATE TABLE statement: CREATE TABLE table2 LIKE table1
Which two of the following will NOT occur when the statement is executed?
A. TABLE2 will have the same column names and column data types as TABLE1
B. TABLE2 will have the same column defaults as TABLE1
C. TABLE2 will have the same nullability characteristics as TABLE1
D. TABLE2 will have the same indexes as TABLE1.
E. TABLE2 will have the same referential constraints as TABLE1
Answer: D,E
Explanation:
Q126. Which of the following is the best statement to use to create a user-defined data type that can be used to store currency values?
A. CREATE DISTINCT TYPE currency AS NUMERIC(7,2)
B. CREATE DISTINCT TYPE currency AS SMALLINT
C. CREATE DISTINCT TYPE currency AS BIGINT
D. CREATE DISTINCT TYPE currency AS DOUBLE
Answer: A
Explanation:
Actual C2090-730 secret:
Q127. Which of the following is true about XML columns?
A. XML columns are used to store XML documents as a hierarchical set of entities
B. Only XQuery can be used to retrieve an XML document from an XML column
C. XML columns must be altered to accommodate additional parent/child relationships if they are used in referential constraints
D. In order to access any portion of an XML document stored in an XML column, the entire document must be retrieved
Answer: A
Explanation:
Q128. Which of the following is a feature of a unit of work?
A. It applies to a single data server.
B. It is a recoverable sequence of operations.
C. Its value can be queried from the system catalog tables.
D. It begins when the application connects to the data server.
Answer: B
Explanation:
Q129. Assuming table TAB1 contains 100 rows, which of the following queries will return only half of the rows available?
A. SELECT * FROM tab1 FIND FIRST 50 ROWS
B. SELECT * FROM tab1 FETCH FIRST 50 ROWS ONLY
C. SELECT * FROM tab1 WHILE ROW_NUM < 50
D. SELECT * FROM tab1 MAXROWS 50
Answer: B
Explanation:
Q130. A transaction using the Read Stability isolation level scans the same table multiple times before it terminates. Which of the following can occur within this transaction's processing?
A. Uncommitted changes made by other transactions can be seen from one scan to the next.
B. Rows removed by other transactions that appeared in one scan will no longer appear in subsequent scans.
C. Rows added by other transactions that did not appear in one scan can be seen in subsequent scans.
D. Rows that have been updated can be changed by other transactions from one scan to the next.
Answer: C
Explanation: