最新的IBM C2090-556免費考試真題

問題1

Which value can be used for connection type field from sqlhosts file when using Secured Sockets Layer (SSL) protocol for Distributed Relational Database Architecture (DRDA) ?

A. onsoctcp

B. onsocssl

C. drtlitcp

D. drsocssl

正確答案: D

問題2

Assume a three level hierarchy of table inheritance, with table supertable as the parent, subtable as the child and subsubtable as the grandchild. How would you disable DELETE trigger delst_trg1 inherited from supertable at the subtable level only?

A. SET TRIGGER delst_trg1 FOR subtable DISABLED;

B. DROP TRIGGER delst_trg1;

C. DROP TRIGGER subtables.delst_trg1;

D. SET TRIGGER subtable.delst_trg1 DISABLED;

正確答案: A

問題3

Which statement about casting is correct?

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

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

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

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

正確答案: A

問題4

Which of the following data types is not based on built-in data types?

A. Distinct types

B. Named row types

C. Row types

D. Opaque types

正確答案: D

問題5

Which of the following data types can be used for values in a sequence?

A. CLOB and BLOB

B. SMALLINT, INTEGER or DECIMAL

C. INTERVAL

D. SERIAL8

正確答案: D

問題6

What are the default privileges when a table is created by the user?

A. Select, Insert, Update, Delete and Execute.

B. No access if NODEFDAC is zero.

C. Select and Execute.

D. Select, Insert, Update and Delete.

正確答案: D

問題7

What Informix onconfig parameter is used to enable specific user level SQL tracing?

A. SQL_XTRACE

B. SQLIDEBUG

C. SQLTRACE

D. TRACE_SQL

正確答案: C

問題8

Which Committed Read isolation level statement is correct?

A. It checks for locks before returning a row.

B. It does not check for locks.

C. It checks for locks after returning a row.

D. It locks all rows examined.

正確答案: A

問題9

When using IBM Informix JDBC Driver, which connection url should be used when making a connection using Informix SQLI protocol?

A. "jdbc:db2://hostname1:5021/storesdb:user=XXX;password=YYY"

B. "jdbc:informixsqli://hostname1:5021/storesdb:INFORMIXSERVER=myserver;user=XXX;password=YYY"

C. "jdbc:ids://hostname1:5021/storesdb:user=XXX;password=YYY"

D. "jdbc:db2j:net://hostname1:5021/storesdb:user=XXX;password=YYY"

正確答案: B

最新的IBM Informix 11.50 Application Developer - C2090-556免費考試真題

聯系我們

站內鏈接

最新更新