최신PostgreSQL-CE PostgreSQL CE 8 Silver - PGCES-02무료샘플문제
문제1
Select two SQL statements which abort a transaction.
Select two SQL statements which abort a transaction.
정답: A,C
문제2
Select two suitable statements regarding creating a new table.
Select two suitable statements regarding creating a new table.
정답: B,D
문제3
Select two incorrect statements concerning the BOOLEAN type in PostgreSQL.
Select two incorrect statements concerning the BOOLEAN type in PostgreSQL.
정답: B,D
문제4
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.
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.
정답: D
문제5
I would like to enable all users to SELECT the "item" table.
Select the most appropriate SQL statement from below.
I would like to enable all users to SELECT the "item" table.
Select the most appropriate SQL statement from below.
정답: A
문제6
Configuration file pg_hda.conf is set as below on a host currently running PostgreSQL. local all all trust host all all 192.168.1.0/24 reject
host all all 192.168.0.0/16 trust Select a host IP address which is authorized to connect to this database via the network. Note: INET domain socket communication is available.
Configuration file pg_hda.conf is set as below on a host currently running PostgreSQL. local all all trust host all all 192.168.1.0/24 reject
host all all 192.168.0.0/16 trust Select a host IP address which is authorized to connect to this database via the network. Note: INET domain socket communication is available.
정답: D
문제7
Select one correct command to shutdown the postmaster AFTER all the clients have disconnected.
Select one correct command to shutdown the postmaster AFTER all the clients have disconnected.
정답: B
문제8
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;
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;
정답: D
문제9
The "sample" table consists of the following data:
How many rows are returned by executing the following SQL statement? SELECT i FROM sample
GROUP BY i HAVING count(*) = 2;
The "sample" table consists of the following data:
How many rows are returned by executing the following SQL statement? SELECT i FROM sample
GROUP BY i HAVING count(*) = 2;
정답: B