Pinpoint of C2090-730 book materials and free samples for IBM certification for candidates, Real Success Guaranteed with Updated C2090-730 pdf dumps vce Materials. 100% PASS DB2 9 Family Fundamentals exam Today!
2021 May C2090-730 Study Guide Questions:
Q11. Given the following table: TAB1 COL1 COL2
A 10 B 20 C 30 A 10 D 40 C 30
Assuming the following results are desired:
TAB1
COL1 COL2
A 10 B 20 C 30 D 40
Which of the following statements will produce the desired results?
A. SELECT UNIQUE * FROM tab1
B. SELECT DISTINCT * FROM tab1
C. SELECT UNIQUE(*) FROM tab1
D. SELECT DISTINCT(*) FROM tab1
Answer: B
Explanation:
Q12. If DB2 detects a deadlock between application A and application B (each waiting for a lock held by the other one), what action will DB2 take?
A. Rollback the transaction in both applications.
B. Rollback the transaction in one of the two applications.
C. Decrease the lock timeout value for both applications, thereby causing a lock timeout situation.
D. Send a message to let the administrator know of the situation and decide which application or applications should be terminated.
Answer: B
Explanation:
Q13. Given the following UPDATE statement:
UPDATE employees SET workdept =
(SELECT deptno FROM department WHERE deptno = 'A01')
WHERE workdept IS NULL
Which of the following describes the result if this statement is executed?
A. The statement will fail because an UPDATE statement cannot contain a subquery.
B. The statement will only succeed if the data retrieved by the subquery does not contain multiple records.
C. The statement will succeed; if the data retrieved by the subquery contains multiple records, only the first record will be used to perform the update.
D. The statement will only succeed if every record in the EMPLOYEES table has a null value in the WORKDEPT column.
Answer: B
Explanation:
Abreast of the times C2090-730 practice question:
Q14. Which of the following database objects can be used to raise an error if a table is updated?
A. Package
B. Trigger
C. Stored Procedure
D. Informational Constraint
Answer: B
Explanation:
Q15. Which of the following will be a consequence of defining the column IDCOL2 in TABLE2 as a foreign key referencing the primary key (IDCOL1) of TABLE1?
A. DB2 will no longer allow updating the value of IDCOL1 in TABLE1.
B. When inserting a row in TABLE2, the only values that DB2 will allow for IDCOL2 are the existing values of IDCOL1.
C. When inserting a row in TABLE2, DB2 will only allow foreign values for IDCOL2,that is values which do not exist in IDCOL1.
D. When a SELECT statement joins TABLE1 with TABLE2, DB2 will automatically add the condition TABLE1.IDCOL1=TABLE2.IDCOL2 if not specified in the statement.
Answer: B
Explanation:
Q16. What is the SQL Performance Monitor used for?
A. To examine the health of a DB2 Database Manager instance
B. To visually construct complex DML statements and examine the results of their execution
C. To schedule tasks, run tasks, and send notifications about completed tasks to other users
D. To analyze database operations performed against a DB2 for i5/OS database
Answer: D
Explanation:
Simulation C2090-730 testing bible:
Q17. Which of the following is NOT an accurate statement about views?
A. Views are publicly referenced names and no special authority or privilege is needed to use them.
B. Views can be used to restrict access to columns in a base table that contain sensitive data
C. Views can be used to store queries that multiple applications execute on a regular basis in a database
D. Views support INSTEAD OF triggers
Answer: A
Explanation:
Q18. If the following SQL statements are executed:
CREATE TABLE tab1 (id SMALLINT NOT NULL PRIMARY KEY,
name VARCHAR(25));
CREATE TABLE tab2 (empid SMALLINT,
weekno SMALLINT,
payamt DECIMAL(6,2),
CONSTRAINT const1 FOREIGN KEY (empid)
REFERENCES taba(id) ON UPDATE NO ACTION);
Which of the following statements is true?
A. Only values that exist in the ID column of table TAB1 are allowed to be inserted in the EMPID column of table TAB2
B. The updating of values in the ID column of table TAB1 is not allowed
C. Only values that do not already exist in the ID column of table TAB1 are allowed to be inserted in the EMPID column of table TAB2
D. When values that exist in the ID column of table TAB1 are updated, corresponding values in the EMPID column of table TAB2 are updated as well
Answer: A
Explanation:
226. An application needs to store a 5 MB JPEG image in a DB2 table. Which data type should be specified for the column that will be used for storing the image?
A. GRAPHIC
B. BINARY
C. IMAGE
D. BLOB
Answer: D
Explanation:
Q19. Given the following table:
EMPLOYEE
EMPID NAME INSTRUMENT
1 Jagger, Mick 01
2 Richards, Keith 02
3 Wood, Ronnie 02
4 Watts, Charlie 03
5 Jones, Darryl 04
6 Leavell, Chuck 05 If the following query is executed:
SELECT name,
CASE WHEN instrument = '01' THEN 'HARMONICA'
WHEN instrument = '02' THEN 'GUITAR'
WHEN instrument = '03' THEN 'DRUMS'
ELSE 'UNKNOWN'
END AS instrument
FROM employee
What will be the results?
A. NAME INSTRUMENT
Jagger, Mick HARMONICA Richards, Keith GUITAR Wood, Ronnie GUITAR Watts, Charlie DRUMS Jones, Darryl ERROR Leavell, Chuck ERROR
B. NAME INSTRUMENT
Jagger, Mick HARMONICA Richards, Keith GUITAR Wood, Ronnie GUITAR Watts, Charlie DRUMS Jones, Darryl 04 Leavell, Chuck 05
C. NAME INSTRUMENT
Jagger, Mick HARMONICA Richards, Keith GUITAR Wood, Ronnie GUITAR Watts, Charlie DRUMS Jones, Darryl UNKNOWN Leavell, Chuck UNKNOWN
D. NAME INSTRUMENT
Jagger, Mick HARMONICA Richards, Keith GUITAR Wood, Ronnie GUITAR Watts, Charlie DRUMS Jones, Darryl -Leavell, Chuck -
Answer: C
Explanation:
Q20. Given the following table definition:
SALES
INVOICE_NO CHAR(20) NOT NULL
SALES_DATE DATE
SALES_PERSON CHAR(20)
REGION CHAR(20)
SALES INTEGER
If the following SELECT statement is executed, which of the following describes the order of the rows in the result data set produced?
SELECT * FROM sales
A. The rows are sorted by INVOICE_NO in ascending order.
B. The rows are sorted by INVOICE_NO in descending order.
C. The rows are ordered based on when they were inserted into the table.
D. The rows are not sorted in any particular order.
Answer: D
Explanation: