最新なIBM 000-543問題集（100題）、真実試験の問題を全部にカバー！

質問 1：
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?
A. INSERT INTO v1 VALUES (NULL,abc)
B. INSERT INTO t1 VALUES (260, 'abc')
C. INSERT INTO t1 VALUES (275, 'abc')
D. INSERT INTO v1 VALUES (250, 'abc')
正解：B

質問 2：
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?
A. INSERT INTO v2 VALUES (100, 'abc')
B. INSERT INTO v2 VALUES (125, NULL)
C. INSERT INTO v2 VALUES (100, NULL)
D. INSERT INTO v2 VALUES (125, 'abc')
正解：B

質問 3：
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?
A. When the last row is read from the CSR1 result set.
B. When the application issues the COMMIT statement.
C. When cursor CSR2 is opened.
D. When cursor CSR1 is closed.
正解：D

質問 4：
In a query, which clause can reference a CLOB data type?
A. a GROUP BY clause
B. an ORDER BY clause
C. a WHERE clause
D. a DISTINCT clause
正解：C

質問 5：
Click the Exhibit button. CREATE FUNCTION deptemployees (idept VARCHAR(3)) RETURNS TABLE (empno CHAR(6), firstnameVARCHAR(12), lastnameVARCHAR(15)) LANGUAGE SQL READS SQL DATA NO EXTERNAL ACTION DETERMINISTIC RETURN SELECT empno, firstnme, lastname FROM employee WHERE workdept = deptemployees.idept; Referring to the exhibit, what contains the proper way to invoke the DEPTEMPLOYEES() user-defined function to return all of the employees that work in department D11?
A. SELECT * FROM TABLE(deptemployees('D11')) AS D11dept
B. SELECT * FROMdeptemployees('D11') AS D11dept
C. SELECT * FROMdeptemployees('D11')
D. SELECT * FROM TABLE(deptemployees('D11'))
正解：A

質問 6：
Using the default lock timeout and isolation level, user USER1 drops table TABLE1 however, the transaction is not committed. Subsequently, user USER2 attempts to access table TABLE1 using the default isolation level. What will occur?
A. User USER1 will receive an error.
B. User USER2 will be able to access the table successfully.
C. User USER2 will wait until user USER1 issues a COMMIT or ROLLBACK statement.
D. User USER2 receives an error immediately.
正解：C

質問 7：
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?
A. SELECTcountries.country, continents.continent FROM countries, continents WHERE
countries.continent_id=
continents.id AND country = 'Greece';
B. SELECT * FROM countries LEFT OUTER JOIN continents ONcountries.continent_id =
continents.id
AND
countries.country= 'Greece';
C. SELECTcountries.country, continents.continent FROM countries RIGHT OUTER JOIN
continents
ON
countries.continent_id= continents.id AND continents.id = 1;
D. SELECT * FROM countries LEFT OUTER JOIN continents ONcountries.continent_id =
continents.id
AND
continents.id = 1 FETCH FIRST 1 ROWS ONLY;
正解：A

質問 8：
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?
A. 4
B. 1
C. 3
D. 2
正解：C