IBM A2090-730 Actual Free Exam Questions & Community Discussion
Which of the following tools can make recommendations for indexes and/or MQTs to improve the performance of DB2 applications?
Correct Answer: B
Vote an answer
Which of the following resources can be explicitly locked?
Correct Answer: A
Vote an answer
Which of the following is a characteristic of a schema?
Correct Answer: B
Vote an answer
A "trusted" client needs to communicate with a server that has been configured to use CLIENT authentication. Which of the following will be used to verify passwords?
Correct Answer: C
Vote an answer
Which of the following DB2 tools allows a user to execute an SQL statement and view a graphical representation of the access plan?
Correct Answer: B
Vote an answer
Which two of the following are optional and do not have to be specified when creating a table?
Correct Answer: B,D
Vote an answer
User USER1 holds CONTROL privilege on table TABLE1. Which two of the following statements is user USER1 allowed to execute?
Correct Answer: A,C
Vote an answer
Which of the following is NOT a characteristic of a unique index?
Correct Answer: A
Vote an answer
A stored procedure object is created into which DB2 object?
Correct Answer: B
Vote an answer
Which of the following can be viewed with the Journal?
Correct Answer: D
Vote an answer
Given the following table:
TEMP_DATA
TEMP DATE
45 12/25/2006 51 12/26/2006 67 12/27/2006 72 12/28/2006 34 12/29/2006 42 12/30/2006
And the following SQL statement:
CREATE FUNCTION degf_to_c (temp INTEGER) RETURNS INTEGER LANGUAGE SQL CONTAINS SQL NO EXTERNAL ACTION DETERMINISTIC BEGIN ATOMIC DECLARE newtemp INTEGER; SET newtemp = temp - 32; SET newtemp = newtemp * 5; RETURN newtemp / 9; END
Which two of the following SQL statements illustrate the proper way to invoke the scalar function DEGF_TO_C?
TEMP_DATA
TEMP DATE
45 12/25/2006 51 12/26/2006 67 12/27/2006 72 12/28/2006 34 12/29/2006 42 12/30/2006
And the following SQL statement:
CREATE FUNCTION degf_to_c (temp INTEGER) RETURNS INTEGER LANGUAGE SQL CONTAINS SQL NO EXTERNAL ACTION DETERMINISTIC BEGIN ATOMIC DECLARE newtemp INTEGER; SET newtemp = temp - 32; SET newtemp = newtemp * 5; RETURN newtemp / 9; END
Which two of the following SQL statements illustrate the proper way to invoke the scalar function DEGF_TO_C?
Correct Answer: A,D
Vote an answer
Which of the following DB2 objects are publicly referenced names that require no special authority or privilege to use them?
Correct Answer: C
Vote an answer
If the following SQL statement is executed:
CREATE TABLE sales
(invoice_no NOT NULL PRIMARY KEY,
sales_date DATE,
sales_amt NUMERIC(7,2))
IN tbsp0, tbsp1, tbsp2, tbsp3
PARTITION BY RANGE (sales_date NULLS FIRST)
(STARTING '1/1/2007' ENDING '12/31/2007'
EVERY 3 MONTHS)
Which of the following statements is true?
CREATE TABLE sales
(invoice_no NOT NULL PRIMARY KEY,
sales_date DATE,
sales_amt NUMERIC(7,2))
IN tbsp0, tbsp1, tbsp2, tbsp3
PARTITION BY RANGE (sales_date NULLS FIRST)
(STARTING '1/1/2007' ENDING '12/31/2007'
EVERY 3 MONTHS)
Which of the following statements is true?
Correct Answer: D
Vote an answer
0
0
0
10