[Free] 2017(Jan) EnsurePass Passguide IBM C2090-730 Dumps with VCE and PDF 191-200

EnsurePass
2017 Jan IBM Official New Released C2090-730
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/C2090-730.html

DB2 9 Family Fundamentals

Question No: 191

If a view named V1 is created in such a waythat it references every column in a table named EMPLOYEE except a column named SALARY, which of the following is NOT an accurate statement?

  1. View V1 can be used in the same context as the EMPLOYEE table for all data retrieval operations that do not acquire SALARY information

  2. View V1 can be used as a data source for other views

  3. View V1 does not have to reside in the same schema as the EMPLOYEE table

  4. All data, except SALARY data that is stored in the EMPLOYEE table is copied to the physical location associated with view V1

Answer: D

Question No: 192

Which of the following will begin a new unit of work?

  1. The CONNECT statement

  2. The first FETCH of a cursor

  3. The BEGIN TRANSACTION statement

  4. The first executable SQL statement

Answer: D

Question No: 193

Given the following table definitions:

DEPARTMENT

————- DEPTNO CHAR(3) DEPTNAME CHAR(30) MGRNO INTEGER ADMRDEPT CHAR(3)

EMPLOYEE

————- EMPNO INTEGER FIRSTNAME CHAR(30) MIDINIT CHAR LASTNAME CHAR(30) WORKDEPT CHAR(3)

Which of the following statements will list every employee number and last name, along with the employee number and last name of their manager, including employees that have not been assigned to a manager?

  1. SELECT e.empno, e.lastname, m.empno,m.lastname FROM employee e LEFT INNER JOIN department INNER JOIN employee m ON mgrno=m.empno ON e.workdept=deptno

  2. SELECT e.empno, e.lastname, m.empno, m.lastname FROM employee e LEFT OUTER JOIN department INNER JOIN employee m ON mgrno=m.empno ON e.workdept=deptno

  3. SELECT e.empno, e.lastname, m.empno, m.lastname FROM employee e RIGHT OUTER JOIN department INNER JOIN employee m ON mgrno=m.empno ON e.workdept=deptno

  4. SELECT e.empno, e.lastname, m.empno, m.lastname FROM employee e RIGHT INNER JOIN department INNER JOIN employee m ON mgrno=m.empno ON e.workdept=deptno

Answer: B

Question No: 194

An index named EMPID_X exists for a table named EMPLOYEE. Which of the following will allow user USER1 to drop the EMPID_X index?

  1. GRANT DROP ON INDEX empid_x TO user1

  2. GRANT DELETE ON INDEXempid_x TO user1

  3. GRANT INDEX ON TABLE employee TO user1

  4. GRANT CONTROL ON INDEX empid_x TO user1

Answer: D

Question No: 195

In a client-server environment, which two ofthe following can be used to verify passwords?

  1. System Catalog

  2. User ID/password file

  3. Client Operating System

  4. Communications layer

  5. Application Server

Answer: C,E

Question No: 196

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?

  1. INSERT INTO tab1 VALUES (0, #39;abc#39;)

  2. INSERT INTO tab1 VALUES (NULL, #39;abc#39;)

  3. INSERT INTO tab1 VALUES (ABS(2), #39;abc#39;)

  4. INSERT INTO tab1 VALUES (DEFAULT, #39;abc#39;)

Answer: C

Question No: 197

The following triggers were defined for table TAB1 in the order shown:

CREATE TRIGGER trig_a AFTER UPDATE ON tab1 FOR EACH ROW

UPDATE sale_tab SETsale_date = CURRENT DATE; CREATE TRIGGER trig_b AFTER UPDATE ON tab1 FOR EACH STATEMENT

UPDATE invoice_tab SET invoice_date = CURRENT DATE; CREATE TRIGGER trig_c AFTER UPDATE ON tab1

FOR EACH ROW

UPDATE shipping_tab SET ship_date = CURRENT DATE; CREATE TRIGGER trig_d AFTER UPDATE ON tab1

FOR EACH STATEMENT

UPDATE billing_tab SET billing_date = CURRENT DATE;

If an event occurs that causes all of them to activate, which trigger will be activated first?

  1. TRIG_A

  2. TRIG_B

  3. TRIG_C

  4. TRIG_D

Answer: A

Question No: 198

Which of the following are all valid DB2 data types?

  1. LONG VARCHAR, SMALLINT, NUMBER, BLOB

  2. DECIMAL, DATE, DBCLOB, INTERVAL

  3. NUMERIC, TIMESTAMP, BYTE, FLOAT

  4. NUM, TIME, XML, DOUBLE

Answer: D

Question No: 199

Which of the following modes, when used with the LOCK TABLE statement, will cause the DB2 Database Manager to acquire a table-level lock that prevents other concurrent transactions from accessing data stored in the table while the owning transaction is active?

  1. SHARE MODE

  2. ISOLATED MODE

  3. EXCLUSIVE MODE

  4. RESTRICT MODE

Answer: C

Question No: 200

Which kind of non-sourced UDF can be created so that it only returns a single value?

  1. Row

  2. Table

  3. Scalar

  4. Column

Answer: C

100% Free Download!
Download Free Demo:C2090-730 Demo PDF
100% Pass Guaranteed!
Download 2017 EnsurePass C2090-730 Full Exam PDF and VCE

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

2017 EnsurePass IT Certification PDF and VCE