Ensurepass.com : Ensure you pass the IT Exams
2018 Jan IBM Official New Released C2090-610
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/C2090-610.html

DB2 10.1 Fundamentals

Question No: 51 – (Topic 1)

A table named STATES was created as follows:

Ensurepass 2018 PDF and VCE

What will happen?

  1. An error will be returned and the operationwill fail.

  2. A warning will be returned and the unique index INDX1 will become the index for the primary key.

  3. The primary key will be successfully added and the unique index INDX1 will be dropped and recreated as the primary key index.

  4. The primarykey will be successfully added, the unique index INDX1 will be dropped, and a new index will be created for the primary key.

Answer: B

Question No: 52 – (Topic 1)

Which SQL statement will retrieve the employee number (EMPNO), hire date (HIREDATE), and salary (SALARY) for each employee from a table named EMPLOYEE who was hired before 1998 and earns a salary of less than $35,000.00 per year?

  1. SELECT empno, hiredate, salary FROM employee

    FOR hiredate lt; #39;1998-01-01#39; AND salary lt; 35000

  2. SELECT empno, hiredate, salary FROM employee

    WHERE hiredate lt; #39;1998-01-01#39; AND salary lt; 35000

  3. SELECT empno, hiredate, salary FROM employee

    WHERE hiredate lt; #39;1998-01-01#39; OR salary lt; 35000

  4. SELECT empno, hiredate, salary FROM employee

FOR hiredate lt;#39;1998-01-01#39; OR salary lt; 35000

Answer: B

Question No: 53 – (Topic 1)

Which privilege is required to invoke a user defined function?

  1. CALL

  2. USAGE

  3. EXECUTE

  4. REFERENCES

Answer: C

Question No: 54 – (Topic 1)

An SQL function designed to convert temperatures from Fahrenheit to Celsius was created as follows:

Ensurepass 2018 PDF and VCE

How can thisfunction be used to convert average temperature (AVG_TEMP) data stored in a table called CLIMATE_INFO?

  1. CALL conv_temp(climate_info.avg_temp);

  2. CALL convert_ftoc(climate_info.avg_temp);

  3. SELECT conv_temp(avg_temp) FROM climate_info;

  4. SELECT convert_ftoc(avg_temp) FROM climate_info;

Answer: C

Question No: 55 – (Topic 1)

Which command will delete all rows from a table without generating log records?

  1. TRIM

  2. DROP

  3. DELETE

  4. TRUNCATE

Answer: D

Question No: 56 – (Topic 1)

What is the purpose ofthe Query Tuner?

  1. To automatically capture and stop rogue queries.

  2. To provide recommendations and analysis for tuning a single query.

  3. To provide recommendations and analysis for tuning up to 100 queries.

  4. To recommend indexes and to guide DBAsthrough the process of creating new indexes.

Answer: B

Question No: 57 – (Topic 1)

Which type of lock allows the lock owner and all concurrent applications to read, but not update, the locked data?

  1. Share (S)

  2. Update (U)

  3. Exclusive (X)

  4. Intent Exclusive (IX)

Answer: A

Question No: 58 – (Topic 1)

Which statement is true about an index that is used to support a UNIQUE constraint?

  1. It must not contain more than one column.

  2. It cannot be used in a referential constraint.

  3. It must be defined with the UNIQUE attribute.

  4. It must be defined as UNIQUE WHERE NOT NULL.

Answer: C

Question No: 59 – (Topic 1)

Whatisolation level prevents dirty reads, nonrepeatable reads, and phantoms?

  1. Read stability (RS)

  2. Cursor stability (CS)

  3. Repeatable read (RR)

  4. Uncommitted read (UR)

Answer: C

Question No: 60 – (Topic 1)

Which isolation level offers the greatest protection of data but provides the least amount ofconcurrency?

  1. Read Stability (RS)

  2. Cursor Stability (CS)

  3. Repeatable Read (RR)

  4. Uncommitted Read (UR)

Answer: C

100% Ensurepass Free Download!
Download Free Demo:C2090-610 Demo PDF
100% Ensurepass Free Guaranteed!
C2090-610 Dumps

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

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.