PGCES-02 試験問題を無料オンラインアクセス

I would like to insert the contents of the text file users.dat into the table t1 using psql. Contents of
text file users.dat:
Definition of table t1:
CREATE TABLE t1 (uname TEXT, pass TEXT, id INTEGER); Select the most appropriate input
from those below.

• A.INSERT INTO t1 FROM file('users.dat');
• B.\copy t1 TO users.dat WITH DELIMITER ':'
• C.\copy t1 FROM users.dat WITH DELIMITER ':'
• D.\insert t1 FROM users.dat WITH DELIMITER ':';
• E.INSERT INTO t1SELECT uname, pass, id FROM file('users.dat');

Select two incorrect statements regarding 'TRIGGER'.

• A.A trigger can be set up to call a specified function before or after the event occurs.
• B.When SELECT is executed to thetable, the specified function can be called.
• C.A corresponding rule is automatically created when a trigger is created.
• D.When UPDATE is executed to thetable, the specified function can be called.
• E.When INSERT is executed to thetable, the specified function can be called.

Select three SQL statements which return NULL.

• A.SELECT NULL;
• B.SELECTNULL != NULL;
• C.SELECT NULL IS NULL;
• D.SELECT 'null'::TEXT;
• E.SELECT 0 = NULL;

Select one incorrect statement about the SQL COPY command.

• A.You can output the row data of a table to a specified client side file.
• B.The delimiter thatseparates column data can be changed from the default TAB character.
• C.Copies row data froma file into a table.
• D.Only thesuperuser can specify the output file name.
• E.It copies data between a file and a table.

SQL statements were executed in the following order:
CREATE TABLE fmaster
(id INTEGER PRIMARY KEY, name TEXT);
CREATE TABLE ftrans
(id INTEGER REFERENCES fmaster (id), stat INTEGER, date DATE);
INSERT INTO fmaster VALUES (1, 'itemA');
INSERT INTO ftrans VALUES (1, 1, CURRENT_DATE);
Select two SQL statements that will generate an error when executed next.

• A.UPDATEftrans SET id = 200 WHERE id = 1;
• B.UPDATEfmaster SET id = 100 WHERE id = 1;
• C.INSERT INTOftrans VALUES (1, 1, CURRENT_DATE);
• D.INSERT INTOftrans VALUES (2, 1, '2007-07-07');
• E.UPDATEfmaster SET name = 'itemAX' WHERE id = 1;