When creating a trusted connection in CLI/ODBC, it is necessary to set a connection attribute. What is the connection attribute?
A. SQL_ATTR_USE_TRUSTED_CONTEXT
B. SQL_ATTR_ENABLE_TRUSTED_CONTEXT
C. SQL_ATTR_TRUSTED_CONTEXT_USERID
D. SQL_ATTR_TRUSTED_CONTEXT_PASSWORD
正解:A
質問 2:
An ODBC/CLI application invokes the SQLFetch() API resulting in the return code
SQL_SUCCESS_WITH_INFO.
Which two APIs could be used to retrieve the message text explaining the return code? (Choose
two.)
A. SQLGetInfo()
B. SQLGetDiagRec()
C. SQLGetWarning()
D. SQLGetDiagField()
正解:B,D
質問 3:
Click the Exhibit button.
<personinfo>
<name>John Smith</name>
<address type="private">
<city>New York</city>
<country>US</country>
<phone>850-734-6672</phone>
</address>
<phone type="mobile">796-858-1272 </phone>
<phone type="security">646-252-1053</phone>
</personinfo>
The table PERSON is declared as shown below:
CREATE TABLE person (id BIGINT, info XML)
The document shown in the exhibit is successfully inserted into the table.
How many rows will be returned for the following statement?
SELECT t.* FROM
xmlapp.PERSON,
XMLTABLE (
'$INFO/personinfo'
COLUMNS
name VARCHAR(30) PATH './name',
phone VARCHAR(30) PATH './phone'
) AS t
A. 0
B. 4
C. 6
D. 2
正解:A
質問 4:
A database contains a table and a view declared as shown below:
CREATE TABLE s1.t1 ( c1 INTEGER, c2 CHAR(20) );
CREATE VIEW s1.v1 AS SELECT * FROM s1.t1;
A system administrator successfully executes the following code:
GRANT CONNECT, IMPLICIT_SCHEMA ON DATABASE TO user1;
GRANT INSERT ON TABLE s1.t1 TO user1;
GRANT CONTROL ON s1.v1 TO user1;
Which SQL statement does user USER1 have privileges to execute?
A. CREATE VIEW user1.v2 AS SELECT * FROM s1.v1
B. UPDATE s1.t1 SET c1 = 2 WHERE c1 IS NULL
C. CREATE PUBLIC ALIAS a1 FOR s1.v1
D. SELECT * FROM s1.t1 WHERE c2 < 100
正解:A
質問 5:
An application must insert values into a column that has a TIMESTAMP data type. What is a valid string representation of a TIMESTAMP?
A. 07/08/2009-12:22:22:0000
B. 2009-08-07 12:22:22.0000
C. 2009.08.07.12.22.22.0000
D. 07-08-2009 12.22.22.0000
正解:B
質問 6:
Given the table COURSES shown below: COURSES
ID CODE NAME 1 ECE100 Operating Systems 2 ECE101 Programming Languages 3 ECE102 Intro to Databases User USER1 executes the following statements: DECLARE GLOBAL TEMPORARY TABLE tempcourses LIKE db2user.courses ON COMMIT PRESERVE ROWS; INSERT INTO session.tempcourses SELECT * FROM db2user.courses; SELECT max(ID) FROM session.tempcourses; Assuming autocommit is on, which result will user USER1 obtain?
A. no value
B. value 2
C. value 3
D. value 1
正解:C
Koinuma -
A2090-543問題集は図表が多く、説明も丁寧で読み込むことにより合格に必要な知識を得ることができます。