we provide Printable IBM C2090-730 exam cram which are the best for clearing C2090-730 test, and to get certified by IBM DB2 9 Family Fundamentals. The C2090-730 Questions & Answers covers all the knowledge points of the real C2090-730 exam. Crack your IBM C2090-730 Exam with latest dumps, guaranteed!
♥♥ 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
Q141. Which of the following DB2 objects are publicly referenced names that require no special authority or privilege to use them?
A. View
B. Alias
C. Table
D. Package
Answer: B
Explanation:
Q142. Given the following table definition: SALES INVOICE_NO CHAR(20) NOT NULL
SALES_DATE DATE
SALES_PERSON VARCHAR(25)
REGION CHAR(20)
SALES_AMT DECIMAL(9,2)
Which of the following queries will return SALES information, sorted by SALES_PERSON, from A to Z, and SALES_DATE, from most recent to earliest?
A. SELECT invoice_no, sales_person, sales_date, sales_amt FROM sales SORT BY sales_person, sales_date DESC
B. SELECT invoice_no, sales_person, sales_date, sales_amt FROM sales SORT BY sales_person DESC, sales_date
C. SELECT invoice_no, sales_person, sales_date, sales_amt FROM sales ORDER BY sales_person, sales_date DESC
D. SELECT invoice_no, sales_person, sales_date, sales_amt FROM sales ORDER BY sales_person DESC, sales_date
Answer: D
Explanation:
Q143. If the following SQL statements are executed:
CREATE TABLE make (makeid SMALLINT NOT NULL PRIMARY KEY, make VARCHAR(25));
CREATE TABLE model (modelid SMALLINT, model VARCHAR(25), makeid SMALLINT, CONSTRAINT const1 FOREIGN KEY (makeid) REFERENCES make(makeid) ON DELETE RESTRICT);
And each table created is populated as follows:
MAKE
MAKEID MAKE
1 Ford 2 Chevrolet 3 Toyota
MODEL
MODELID MODEL MAKEID 1 Mustang 1 2 Escort 1 3 Malibu 2 4 Camry 3
If the following SQL statement is executed:
DELETE FROM make WHERE makeid = 1
What is the total number of rows that will be deleted?
A. 0
B. 1
C. 2
D. 3
Answer: A
Explanation:
Q144. Which of the following DB2 data types does NOT have a fixed length?
A. INT
B. CHAR
C. XML
D. DOUBLE
Answer: C
Explanation:
Q145. Which of the following best describes the age of the data in an OLTP system?
A. Current
B. Projected
C. Historical D. Current and projected
Answer: A
Explanation:
Q146. If table TAB1 is created using the following statement:
CREATE TABLE tab1 (col1 INTEGER NOT NULL, col2 CHAR(5), CONSTRAINT cst1 CHECK (col1 in (1, 2, 3)))
Which of the following statements will successfully insert a record into table TAB1?
A. INSERT INTO tab1 VALUES (0, 'abc')
B. INSERT INTO tab1 VALUES (NULL, 'abc')
C. INSERT INTO tab1 VALUES (ABS(2), 'abc')
D. INSERT INTO tab1 VALUES (DEFAULT, 'abc')
Answer: C
Explanation:
Q147. What is the purpose of the Design Advisor?
A. To analyze workloads and make recommendations for indexes and MQTs
B. To present a graphical representation of a data access plan and recommend design changes that will improve performance
C. To replicate data between a DB2 database and another relational database
D. To configure clients so they can access databases stored on remote servers
Answer: A
Explanation:
Q148. Which of the following is NOT a characteristic of a data warehouse?
A. Summarized queries that perform aggregations and joins
B. Heterogeneous data sources
C. Voluminous historical data
D. Sub-second response time
Answer: D
Explanation:
Q149. Which of the following database objects is considered executable using SQL?
A. View
B. Table
C. Routine
D. Package
Answer: C
Explanation:
Q150. An alias can be an alternate name for which two of the following DB2 objects?
A. Sequence
B. Trigger
C. View
D. Schema
E. Table
Answer: C,E
Explanation: