[Free] 2017(Nov) EnsurePass Passguide IBM C2090-556 Dumps with VCE and PDF 21-30

EnsurePass
2017 Nov 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: 21 – (Topic 1)

In an ANSI compliant database, what value of SQLCODE indicates a successful query that returned no rows?

A. 100

B. -330

C. -201

D. -1

Answer: A

Question No: 22 – (Topic 1)

Which of the following data types can be directly cast to a DATE type?

  1. DECIMAL

  2. DATETIME

  3. SMALLINT

  4. SMALLFLOAT

Answer: C

Question No: 23 – (Topic 1)

When is a cursor necessary in an SQL program?

  1. A cursor is necessary before an after trigger can be created.

  2. A cursor is necessary when a query returns one row and you wish to examine its content and maybe update it or delete it.

  3. A cursor is necessary when a query returns more than one row and you wish to examine their content before an update or delete statement isexecuted.

  4. A cursor is only necessary when using DISTINCT, UNIQUE, ORDER BY, GROUP BY or aggregates in SQL statements.

Answer: C

Question No: 24 – (Topic 1)

What is the syntax to query a table that resides on a remote Informix database?

  1. database@server:[owner.]table

  2. database@server:databasename:[owner.]table

  3. database@server:user:password:[owner.]table

  4. database@server:databasename:user:password:[owner.]table

Answer: A

Question No: 25 – (Topic 1)

Which two are valid Interval classes of the INTERVAL datatype? (Choose two.)

  1. Day-time Interval

  2. Month-day Interval

  3. Day-second Interval

  4. Year-month Interval

  5. Hour-second Interval

Answer: A,D

Question No: 26 – (Topic 1)

What is the EXECUTE IMMEDIATE statement used for?

  1. To dynamically execute a SELECT statement.

  2. To execute dynamically composed SQL statements.

  3. To return a result set immediately from the statement.

  4. To execute a particular SQL statement with a higher priority.

Answer: B

Question No: 27 – (Topic 1)

To register a routine in the database, an authorized user wraps the SPL commands in a CREATE FUNCTION or CREATE PROCEDURE statement. The database server stores a registered SPL routine internally. Which two of the following can register a new routine in

the database? (Choose two.)

  1. All users.

  2. The user informix.

  3. Any user in the DBA group.

  4. Any user with DBA privileges.

  5. Any user in the DBSECADM group.

Answer: B,D

Question No: 28 – (Topic 1)

What is a view?

  1. a synonym

  2. a base table

  3. a virtual or synthetic table

  4. a copy of an ordinary table

Answer: C

Question No: 29 – (Topic 1)

What is the correct sequence for retrieving multiple rows using a cursor for a dynamic SQL query?

  1. OPEN, DECLARE, FETCH, CLOSE, FREE

  2. DECLARE, OPEN, FETCH, FREE, CLOSE

  3. DECLARE, FETCH, OPEN, CLOSE, FREE

  4. DECLARE, OPEN, FETCH, CLOSE, FREE

Answer: D

Question No: 30 – (Topic 1)

A user opens a transaction. In that transaction, a cursor is opened to fetch multiple rows for read access. Another transaction is opened and that connection attempts to modify some

rows that the first transaction is examining. Which isolation level will ensure that the rows the first transaction examines remain the same?

  1. COMMITTED READ

  2. REPEATABLE READ

  3. DIRTY READ

  4. CURSOR STABILITY

Answer: B

100% Free Download!
Download Free Demo:C2090-556 Demo PDF
100% Pass Guaranteed!
Download 2017 EnsurePass C2090-556 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

Leave a Reply