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

Informix 11.50 Application Developer

Question No: 31 – (Topic 1)

Which statement about casting is correct?

  1. The following code fragment creates an implicit cast: CREATE CAST (percent AS INTEGER).

  2. A straight cast tells the database server that two data types have the same internal structure.

  3. You cannot explicitly invoke an implicit cast with the CAST AS keywords or the :: cast operator.

  4. A differential cast tells the database server that two data types have different internal structures.

Answer: B

Question No: 32 – (Topic 1)

Which datatype contains an ordered set of elements of the same type?

  1. Row

  2. Set

  3. List

  4. Multiset

Answer: C

Question No: 33 – (Topic 1)

Which of the following is NOT a valid loop construct in Stored Procedure Language?

  1. FOR … END FOR

  2. LOOP … END LOOP

  3. WHILE … END WHILE

  4. REPEAT … END REPEAT

Answer: D

Question No: 34 – (Topic 1)

What format should be used to define columns using user-defined types in an ANSI- compliant database?

  1. colname

  2. owner.colname

  3. tablename.colname

  4. owner.tablename.colname

Answer: B

Question No: 35 – (Topic 1)

Assuming you have an employee table that stores the salary for each employee. What will this query return?

SELECT AVG(salary), STDEV(salary) FROM employees;

  1. Average salary and standard deviation for all rows.

  2. Average salary and standard deviation for all rows not containing NULL salaries.

  3. Average salary and standard deviation for all rows assuming zero for NULL salaries.

  4. Average salary and standard deviation for all rows assuming the average value for NULL salaries.

Answer: B

Question No: 36 – (Topic 1)

What are the two valid methods to obtain trace data for diagnosing JDBC problems with the IBM Data Server Driver for JDBC and SQLJ type 4 connectivity? (Choose two.)

  1. Set the ibm.jcc.override.trace property.

  2. Set the ifx.jcc.override.traceFile property.

  3. Set the db2.jcc.override.traceFile property.

  4. Set the ifx.jcc.override.traceDirectory property.

  5. Set the db2.jcc.override.traceDirectory property.

Answer: C,E

Question No: 37 – (Topic 1)

What happens if you run the following CREATE TABLE statement without the PUT clause? CREATE TABLE EMPLOYEE

(EMP_ID INTEGER, EMP_PICTURE BLOB) PUT EMP_PICTURE IN MYSPACE1;

  1. The BLOB is stored with the table data.

  2. The CREATE TABLE statement fails with syntax error.

  3. The BLOB is inserted into an operating system file on the server.

  4. The BLOB is inserted into a system default SBSPACE defined with SBSPACENAME onconfig parameter.

Answer: D

Question No: 38 – (Topic 1)

Which type of isolation level results in a lock on every row a query examines in order to retrieve any row from the result set?

  1. DIRTY READ

  2. COMMITTED READ

  3. CURSOR STABILITY

  4. REPEATABLE READ

Answer: D

Question No: 39 – (Topic 1)

Which two statements are true for built-in functions? (Choose two.)

  1. You cannot overload the functions.

  2. All functions require at least one argument.

  3. The function is evaluated for each row in the query.

  4. You cannot specify the function as the default column value.

  5. The function can be used in both SQL statements and shell scripts.

Answer: B,C

Question No: 40 – (Topic 1)

How is the DBINFO function used in the SQL statement below? SELECT FIRST 1 DBINFO(#39;sessionid#39;) FROM systables;

  1. The DBINFO function sets the session id.

  2. The DBINFO function creates a new session.

  3. The DBINFO function returns the current session id.

  4. The DBINFO function is a wrapper to the systables table.

Answer: C

100% Ensurepass Free Download!
Download Free Demo:C2090-556 Demo PDF
100% Ensurepass Free Guaranteed!
C2090-556 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.