IT認証試験問題集
毎月、ITshikenは1500人以上の受験者が試験準備を助けて、試験に合格するために受験者にご協力します
 ホームページ / C2090-543 問題集  / C2090-543 問題練習

IBM C2090-543 問題練習

DB2 9.7 Application Development 試験

最新更新時間: 2020/11/17,合計80問。

いい買物の日:C2090-543 最新真題を買う時、日本語版と英語版両方を同時に獲得できます。

実際の問題集を練習し、試験のポイントを了解し、テストに申し込むするかどうかを決めることができます。

さらに試験準備時間の35%を節約するには、C2090-543 問題集を使用してください。

 / 6

Question No : 1
Given the application shown below:
DECLARE csr1 CURSOR WITH HOLD FOR SELECT * FROM employee;
OPEN csr1;
FETCH csr1;
COMMIT;
CLOSE csr1;
How long does cursor CSR1 remain open?

正解:

Question No : 2
An application contains the statements shown below:
DECLARE csr1 CURSOR WITH HOLD FOR SELECT * FROM employee;
OPEN csr1;
FETCH csr1;
DECLARE csr2 CURSOR FOR SELECT * FROM employee;
OPEN csr2;
COMMIT;
CLOSE csr1;
When will cursor CSR1 lose position?

正解:

Question No : 3
The statement below was used to create a cursor named CSR1:
DECLARE csr1 CURSOR FOR
SELECT * FROM employee FOR UPDATE OF job;
When the cursor is opened, the result set contains six rows. After fetching all of the rows in the result set associated with cursor CSR1, application TEST1 needs to fetch the third row of the result set again.
Which steps will allow application TEST1 to fetch the third row again?

正解:

Question No : 4
The scope of a cursor is limited to ____.

正解:

Question No : 5
An application uses the statement shown below to give employees in department "E11" a bonus equal to 10 of their salary:
UPDATE emp
SET bonus = (SELECT .10 * salary FROM emp y WHERE empno = y.empno) WHERE CURRENT OF c1;
Which statement should be used to define cursor C1?

正解:

Question No : 6
Which combination of statements can be used to delete qualifying rows from a table named EMP?

正解:

Question No : 7
Given the SQL statement shown below:
UPDATE address SET number_street =
(SELECT address FROM employee
WHERE address.empid = employee.empid)
WHERE number_street IS NULL
Which comment is true?

正解:

Question No : 8
Click the Exhibit button.
CONNECT TO test;
CREATE TABLE tab_a (col1 INT);
CREATE TABLE tab_b (col1 INT);
INSERT INTO tab_a VALUES (1), (2), (3), (4);
INSERT INTO tab_b VALUES (1), (2), (2), (3);
CONNECT RESET;
A DB2 Command Line Processor script file containing the commands and statements shown in the exhibit executed successfully.
If the statement shown below is executed:
DELETE FROM tab_a WHERE col1 IN (SELECT DISTINCT * FROM tab_b);
How many rows will be removed from table TAB_A?

正解:

Question No : 9
A table named INVENTORY was created by executing the SQL statement shown below:
CREATE TABLE inventory (part_no INTEGER,
quantity INTEGER,
price DECIMAL(7,2),
status CHAR(2));
If items are indicated to be out of stock by setting STATUS to NULL and QUANTITY to zero, which SQL statement updates the INVENTORY table to indicate that all items with part numbers below 150 are out of stock?

正解:

Question No : 10
Table T1 and views V1 and V2 were created by executing the statements shown below:
CREATE TABLE t1 (c1 INT, c2 CHAR(3));
CREATE VIEW v1 AS SELECT c1, c2 FROM t1 WHERE c1 > 100;
CREATE VIEW v2 AS SELECT * FROM v1 WHERE c2 IS NULL WITH
CASCADED CHECK OPTION;
Which statement will execute successfully?

正解:

Question No : 11
Table T1 and view V1 were created by executing the statements shown below:
CREATE TABLE t1 (c1 INT CHECK (c1 < 275),
c2 CHAR(3));
CREATE VIEW v1 AS SELECT c1, c2 FROM t1 WHERE c1 > 250
WITH LOCAL CHECK OPTION;
Which statement will execute successfully?

正解:

Question No : 12
Click the Exhibit button.
CONNECT TO test;
CREATE TABLE tab_a (col1 INT);
CREATE TABLE tab_b (col1 INT);
INSERT INTO tab_a VALUES (1), (2), (3), (4);
INSERT INTO tab_b VALUES (1), (1), (2), (2);
CONNECT RESET;
A DB2 Command Line Processor script file containing the commands and statements shown in the exhibit was executed successfully.
If the statement shown below is executed:
UPDATE tab_a SET col1 = 10 WHERE col1 IN (SELECT * FROM tab_b);
How many rows in table TAB_A will be modified?

正解:

Question No : 13
Given the two tables shown below:
COUNTRIES
----------
COUNTRY CONTINENT_ID
Greece 1
Germany 1
Canada 2

CONTINENTS
-----------
ID CONTINENT
1 Europe
2 North America
3 Asia

A user wants the following result:
COUNTRY CONTINENT
Greece Europe
Which query should the user submit to achieve the result?

正解:

Question No : 14
Given the two tables shown below:
TAB1
LETTER GRADE
A 80
B 70
C 60

TAB2
LETTER GPA
A 4
C 2
D 1
and the successful execution of the following query:
SELECT * FROM tab1 RIGHT OUTER JOIN tab2 ON tab1.letter = tab2.letter;
How many rows will be returned?

正解:

Question No : 15
Given the two tables shown below:
TAB1
LETTER GRADE
A 80
B 70
C 60

TAB2
LETTER GPA
A 4
C 2
D 1
and the successful execution of the following query:
SELECT * FROM tab1 FULL OUTER JOIN tab2 ON tab1.letter = tab2.letter;
How many rows will be returned?

正解:

 / 6