Select the correct SQL statement which concatenates strings 'ABC' and 'abc' to form 'ABCabc'.
A. SELECT 'ABC' + 'abc' FROM pg_operator;
B. SELECT 'ABC' + 'abc';
C. SELECTcat('ABC', 'abc') FROM pg_operator;
D. SELECT 'ABC' || 'abc';
E. SELECT'ABC' . 'abc';
正解:D
質問 2:
You want to create a cursor that will SELECT the "customer" table. The created cursor must be able to move in any direction and reference data even after the end of the transaction.
Select one answer containing the correct keyword(s) to fill in the underlined blank below.
DECLARE cursor1 __________ FOR SELECT * FROM customer;
A. SCROLL CURSOR WITH HOLD
B. CURSOR WITHOUT HOLD
C. CURSOR
D. INSENSITIVE CURSOR
E. NO SCROLL CURSOR WITH HOLD
正解:A
質問 3:
The present time is noon of July 7th, 2007, and the result of the following
SQL sentence was '2007-07-17 12:00:00'.
Select the correct expression to fill in the blank below.
SELECT CURRENT_TIMESTAMP::timestamp + ________________ ;
A. age(8640000)
B. '10 day'::timestamp
C. 10::day
D. 8640000::time
E. '10 day'::interval
正解:E
質問 4:
A table named "sample" is defined as below. Select two statements which will generate a
constraint error.
CREATE TABLE sample (
i INTEGER PRIMARY KEY,
j INTEGER,
CHECK ( i > 0 AND j < 0 )
);
A. INSERT INTO sample VALUES (3, NULL);
B. INSERT INTO sample VALUES (1, 0);
C. INSERT INTO sample VALUES (NULL, -4);
D. INSERT INTO sample VALUES (2, -2);
E. INSERT INTO sample VALUES (5, -5);
正解:B,C
質問 5:
From the SQL commands below, select one that is generally classified as "DDL".
A. CREATE TABLE
B. INSERT
C. START TRANSACTION
D. DELETE
E. SELECT
正解:A
質問 6:
Select two correct statements that describe what occurs on the client side when the following command is executed. pg_ctl -m smart stop
A. Clients will not be able to make new connections.
B. The running transaction for a connected client is rolled back and the connection is disconnected forcibly.
C. The processes of currently connected clients are processed normally.
D. Connections are terminated after the currently running transactions have finished.
E. Connected clients receive a message saying that the server will soon be shutdown.
正解:A,C
Tachibana -
図表を多用して、PGCES-02のわかりにくい概念や仕組みの理解を助ける。しかも広大な試験分野を1冊でカバーしてる!