A2090-556問題集、IBM実際の試験問題

質問 1

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:ids://hostname1:5021/storesdb:user=XXX;password=YYY"

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

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

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

正解: A

質問 2

Which datatype is a synonym for NUMERIC?

A. INTEGER

B. FLOAT

C. Floating point DECIMAL

D. Fixed point DECIMAL

正解: D

質問 3

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;

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

B. The CREATE TABLE statement fails with syntax error.

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

D. The BLOB is stored with the table data.

正解: C

質問 4

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

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

B. Select and Execute.

C. Select, Insert, Update and Delete.

D. No access if NODEFDAC is zero.

正解: C

質問 5

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

A. DATETIME

B. SMALLINT

C. DECIMAL

D. SMALLFLOAT

正解: B

質問 6

What does the TRACE PROCEDURE statement do when debugging stored procedures?

A. Traces the routine calls and return values, but not the body of the stored procedure.

B. Traces the routine calls and return values, and every parsed statement in the stored procedure.

C. Traces the routine calls and return values, automatically setting the debug file to the name of the stored procedure.

D. Activates the TRACE statements embedded in the stored procedure.

正解: A

質問 7

What are user created temporary tables used for?

A. To persistently write temporary data to disk.

B. To access a temporary result set within one session.

C. To share result sets across multiple sessions.

D. To automatically delete data based on a time policy.

正解: B

質問 8

Given the following program code: What is the minimum privilege required to successfully execute the program?

A. RESOURCE

B. DBA

C. CONNECT

D. CREATE

正解: A

質問 9

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;

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

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

C. Average salary and standard deviation for all rows.

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

正解: A

質問 10

Overloading of built-in functions provides which of the following benefits?

A. Allows built-in functions to operate on new data types.

B. Allows built-in functions to function as operator functions.

C. Allows change in the functionality of existing built-in functions.

D. Allows built-in functions to generate aggregate results.

正解: A

IBM Assessment: Informix 11.50 Application Developer - A2090-556 模擬練習