Assessment: DB2 9 Family Fundamentals: A2090-730 Exam Premium File as PDF & Test Engine

Quality and Value for the A2090-730 Exam

Fast2test Practice Exams for IBM DB2 A2090-730 are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development.

100% Guarantee to Pass Your A2090-730 Exam

If you do not pass the IBM DB2 A2090-730 exam (Assessment: DB2 9 Family Fundamentals) on your first attempt using our Fast2test testing engine, we will give you a FULL REFUND of your purchasing fee.

Prompt Updates on A2090-730

Once there is some changes on A2090-730 exam, we will update the study materials timely to make them be consistent with the current exam. We devote to giving our customers the best and latest IBM A2090-730 dumps. Besides, the product you buy will be updated in time within 365 Days for free.

Why Choose IBM A2090-730 Exam on Fast2test

Fast2test is suitable for busy professional, who can know prepare for Certification exam in a week. Our A2090-730 practice materials has been prepared by the team of IBM experts after an in-depth analysis of vendor recommended syllabus. Now you can pass IBM certification exam with our A2090-730 study material on the first attempt.

A2090-730 exam is an important IBM Certification which can test your professional skills. Candidates want to pass the exam successfully to prove their competence. Fast2test IBM technical experts have collected and certified 303 questions and answers of DB2 - Assessment: DB2 9 Family Fundamentals which are designed to cover the knowledge points of the Planning and Designing IBM Superdome Server Solutions and enhance candidates' abilities. With Fast2test A2090-730 preparation tests you can pass the DB2 - Assessment: DB2 9 Family Fundamentals easily, get the IBM certification and go further on IBM career path.

Downloadable, Interactive A2090-730 Testing engines

Our Assessment: DB2 9 Family Fundamentals Preparation Material provides you everything you will need to take a IBM DB2 A2090-730 examination. Details are researched and produced by IBM Certification Experts who are constantly using industry experience to produce precise, and logical.

IBM A2090-730 Exam Syllabus Topics:

IBM Assessment: DB2 9 Family Fundamentals Sample Questions:

1. Given the following requirements:
Create a table to contain employee data, with a unique numeric identifier automatically assigned when a row is added, has an EDLEVEL column that permits only the values 'C', 'H' and 'N', and permits inserts only when a corresponding value for the employee's department exists in the DEPARTMENT table.
Which of the following CREATE statements will successfully create this table?

A) CREATE TABLEemp (
empno SMALLINT NEXTVAL GENERATED ALWAYS AS IDENTITY,
firstname VARCHAR(30) NOT NULL,
lastname VARCHAR(30) NOT NULL,
workdept CHAR(3) NOT NULL,
edlevel CHAR(1),
PRIMARY KEY emp_pk (empno),
FOREIGN KEY emp_workdept_fk ON (workdept) REFERENCES department (deptno),
CHECK edlevel_ck VALUES (edlevel IN ('C','H','N')),
);
B) CREATE TABLEemp (
empno SMALLINT NOT NULL GENERATED BY DEFAULT AS IDENTITY,
firstname VARCHAR(30) NOT NULL,
lastname VARCHAR(30) NOT NULL,
workdept CHAR(3),
edlevel CHAR(1),
CONSTRAINT emp_pk PRIMARY KEY (empno),
CONSTRAINT emp_workdept_fk FOREIGN KEY (workdept) REFERENCES department
(deptno),
CONSTRAINT edlevel_ck CHECK edlevel VALUES ('C','H','N')
);
C) CREATE TABLEemp (
empno SMALLINT NEXTVAL GENERATED BY DEFAULT AS IDENTITY,
firstname VARCHAR(30) NOT NULL,
lastname VARCHAR(30) NOT NULL,
workdept CHAR(3) NOT NULL,
edlevel CHAR(1) CHECK IN ('C','H','N')),
CONSTRAINT emp_pk PRIMARY KEY (empno),
CONSTRAINT emp_workdept_fk FOREIGN KEY department (deptno) REFERENCES
(workdept)
);
D) CREATE TABLEemp (
empno SMALLINT NOT NULL GENERATED BY DEFAULT AS IDENTITY,
firstname VARCHAR(30) NOT NULL,
lastname VARCHAR(30) NOT NULL,
workdept CHAR(3),
edlevel CHAR(1),
CONSTRAINT emp_pk PRIMARY KEY (empno),
CONSTRAINT emp_workdept_fk FOREIGN KEY (workdept) REFERENCES department
(deptno),
CONSTRAINT edlevel_ck CHECK (edlevel IN ('C','H','N'))
);

2. A database named TEST_DB resides on a z/OS system and listens on port 446. The TCP/IP address for this system is 192.168.10.20 and the TCP/IP host name is MYHOST. Which of the following commands is required to make this database accessible to a Linux client?

A) CATALOG TCPIP NODEzos_srvr REMOTE myhost SERVER 446;
CATALOG DCS DATABASE zos_db AS test_db AT NODE zos_srvr;
B) CATALOG TCPIP NODEzos_srvr REMOTE myhost SERVER 192.168.10.20;
CATALOG DCS DATABASE zos_db AS test_db AT NODE zos_srvr;
C) CATALOG TCPIP NODEzos_srvr REMOTE myhost SERVER 446;
CATALOG DATABASE zos_db AS test_db AT NODE zos_srvr;
CATALOG DCS DATABASE zos_db AS test_db;
D) CATALOG TCPIP NODEzos_srvr REMOTE myhost SERVER 192.168.10.20;
CATALOG DATABASE zos_db AS test_db AT NODE zos_srvr;
CATALOG DCS DATABASE zos_db AS test_db;

3. Given the following statements:
CREATE TABLE table1 (col1 INTEGER, col2 CHAR(3)); CREATE VIEW view1 AS SELECT col1, col2 FROM table1 WHERE col1 < 100 WITH LOCAL CHECK OPTION;
Which of the following INSERT statements will execute successfully?

A) INSERT INTO view1 VALUES (50,abc)
B) INSERT INTO view1VALUES(50, 'abc')
C) INSERT INTO view1VALUES(100, 'abc')
D) INSERT INTO view1VALUES(100, abc)

4. Which of the following strings can be inserted into an XML column using XMLPARSE?

A) "<?xml version='1.0' encoding='UTF-8' ?>"
B) "<employee/>"
C) "<!DOCTYPE hello SYSTEM 'hello_world.dtd'>"
D) "<xxmlns:ibmcert='http://www.ibm.com/certify'>"

5. 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?

A) CALLdegf_to_c(32)
B) VALUESdegf_to_c(32) AS temp_c
C) SELECT date,degf_to_c(temp) AS temp_c FROM temp_data
D) SELECT * FROMTABLE(degf_to_c(temp)) AS temp_c
E) VALUESdegf_to_c(32)

Solutions: