IBM A2090-556 問題集

質問 1：
Which two statements will search text data stored in the column brands of the table products for the string century? (Choose two.)
A. SELECT id FROM products WHERE bts_exists(brands, 'century');
B. SELECT id FROM products WHERE brands MATCHES '*century*';
C. SELECT id FROM products WHERE bts_contains(brands, 'century');
D. SELECT id FROM products WHERE brands LIKE '*century*';
E. SELECT id FROM products WHERE brands = 'century';
正解：B,C

質問 2：
How can you prevent concurrency problems when other users are modifying a nonlogging or raw table?
A. Lock the table in exclusive mode for the whole transaction OR use committed read isolation level for the whole transaction.
B. Lock the table in exclusive mode for the whole transaction OR use repeatable read isolation level for the whole transaction.
C. Lock the table in shared mode for the whole transaction OR use committed read isolation level for the whole transaction.
D. Lock the table in shared mode for the whole transaction OR use repeatable read isolation level for the whole transaction.
正解：B

質問 3：
When passing parameters to a function written in Informix SPL, which statement does NOT occur?
A. Call the function with integer data type when the function declaration expects a char data type.
B. Specify a list datatype as a function parameter.
C. Define a single function to accept a varying number of parameters.
D. Specify a simple large object literal (byte and text data type) as a function parameter.
正解：D

質問 4：
Using the following statements to insert new rows into an empty table:
INSERT INTO customer(name,cc) VALUES ("Alice", encrypt_aes("1234567890123456"));
INSERT INTO customer(name,cc) VALUES ("Bob", encrypt_aes("1234567890123478"));
What are the two valid answers for the following SQL? (Choose two.)
SELECT * FROM customer WHERE decrypt_char(cc) MATCHES "1234*";
A. Two rows but only the name fields are returned.
B. Two rows if SET ENCRYPTION PASSWORD has been set.
C. Zero rows if SET ENCRYPTION PASSWORD has been not set.
D. Two rows but the cc field will be decrypted.
E. Two rows containing NULL data.
正解：B,C

質問 5：
When using IBM Data Server Driver for JDBC to connect to Informix Server, which URL should be used when making a connection using Distributed Relational Database Architecture protocol?
A. "jdbc:db2j:net://hostname1:5021/storesdb:user=XXX;password=YYY"
B. "jdbc:informixsqli://hostname1:5021/storesdb:INFORMIXSERVER=myserver;user=XXX;password=YYY"
C. "jdbc:drda://hostname1:5021/storesdb:user=XXX;password=YYY"
D. "jdbc:ids://hostname1:5021/storesdb:user=XXX;password=YYY"
正解：D

質問 6：
Which statement is NOT a characteristic of a sequence?
A. It has a lower level of concurrency than a serial column.
B. It specifies a negative value.
C. Rolling back a generated value is not allowed.
D. It specifies an initial value.
正解：A

質問 7：
Which of the following statements about indexes is NOT true?
A. It is possible to create an index with a different ordering than the default one.
B. It is possible to create an index based on the output of a VARIANT function.
C. It is possible to create an index with a different fragmentation strategy than the table it is based upon.
D. It is possible to create an index with a different access method than the default one.
正解：B