Free IBM A2090-730 Exam Dumps Questions & Answers

An alias can be an alternate name for which two of the following DB2 objects?

• A.  View
• B.  Schema
• C.  Trigger
• D.  Table
• E.  Sequence

Which of the following is the major difference between relational data and XML data?

• A.  Relational data is self-describing; XML data is not
• B.  Relational data is comprised of entities; XML data is comprised of numbers, characters, and dates
• C.  Relational data has inherent ordering; XML data does not
• D.  Relational data must be tabular; XML data does not have to be tabular

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.  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
• D.  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

Which of the following DB2 products are required on an iSeries or System I server to enable an application running on that server to retrieve data from a DB2 database on a Linux server?

• A.  DB2 ConnectEnterprise Edition
• B.  DB2 Runtime Client
• C.  DB2 for i5/OS
• D.  DB2 for i5/OS SQL Development Kit

Which of the following are NOT stored in the system catalog tables?

• A.  SQL statements used to create views
• B.  Table names
• C.  SQL statements used to create triggers
• D.  SQL statements used to create constraints