We provide real C2090-730 exam questions and answers braindumps in two formats. Download PDF & Practice Tests. Pass IBM C2090-730 Exam quickly & easily. The C2090-730 PDF type is available for reading and printing. You can print more and practice many times. With the help of our IBM C2090-730 dumps pdf and vce product and material, you can easily pass the C2090-730 exam.
♥♥ 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
Q161. Which of the following deletion rules on CREATE TABLE will allow parent table rows to be deleted if a dependent row exists?
A. ON DELETE RESTRICT
B. ON DELETE NO ACTION
C. ON DELETE SET NO VALUE
D. ON DELETE CASCADE
Answer: D
Explanation:
Q162. 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 NODE zos_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;
B. CATALOG TCPIP NODE zos_srvr REMOTE myhost SERVER 192.168.10.20;
CATALOG DCS DATABASE zos_db AS test_db AT NODE zos_srvr;
C. CATALOG TCPIP NODE zos_srvr REMOTE myhost SERVER 446;
CATALOG DCS DATABASE zos_db AS test_db AT NODE zos_srvr;
D. CATALOG TCPIP NODE zos_srvr REMOTE myhost SERVER 446;
CATALOG DATABASE zos_db AS test_db AT NODE zos_srvr;
CATALOG DCS DATABASE zos_db AS test_db;
Answer: C
Explanation:
Q163. Which of the following tools can be used to schedule a backup operation that is to be run every Sunday evening?
A. Journal
B. Task Center
C. Activity Monitor
D. Command Line Processor
Answer: B
Explanation:
Q164. 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 has inherent ordering; XML data does not
C. Relational data must be tabular; XML data does not have to be tabular
D. Relational data is comprised of entities; XML data is comprised of numbers, characters, and dates
Answer: C
Explanation:
Q165. 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:
Q166. 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:
Q167. A declared temporary table is used for which of the following purposes?
A. Backup purposes
B. Storing intermediate results
C. Staging area for load operations
D. Sharing result data sets between applications
Answer: B
Explanation:
Q168. Which type of key is defined on the child table to implement a referential constraint?
A. Unique key
B. Primary key
C. Foreign key
D. Composite key
Answer: B
Explanation:
Q169. Which product must be installed on z/OS to allow a COBOL program running on that machine to access data on a remote DB2 for z/OS server?
A. DB2 for z/OS
B. DB2 Run-Time Client for z/OS
C. DB2 Connect Enterprise Edition for z/OS
D. z/OS Application Connectivity to DB2 for z/OS and OS/390
Answer: A
Explanation:
Q170. If the following statement is executed:
CREATE TABLE employee
(empid INT NOT NULL GENERATED BY DEFAULT
AS IDENTITY (START WITH 1, INCREMENT BY 5),
name VARCHAR(20),
dept INT CHECK (dept BETWEEN 1 AND 20),
hiredate DATE WITH DEFAULT CURRENT DATE,
salary DECIMAL(7,2), PRIMARY KEY(empid),
CONSTRAINT cst1 CHECK (YEAR(hiredate) > 2006 OR
Salary > 60500));
Which of the following INSERT statements will fail?
A. INSERT INTO employee VALUES (15, 'Smith', 5, '01/22/2004', 92500.00)
B. INSERT INTO employee VALUES (DEFAULT, 'Smith', 2, '10/07/2002', 80250.00)
C. INSERT INTO employee VALUES (20, 'Smith', 5, NULL, 65000.00)
D. INSERT INTO employee VALUES (DEFAULT, 'Smith', 10, '11/18/2004', 60250.00)
Answer: D
Explanation: