PostgreSQL-CE PostgreSQL CE 8 Silver - PGCES-02무료 덤프문제 풀어보기
A set of tables are defined as follows:
t1 t2 How many rows are returned by executing the following SQL statement?
SELECT * FROM t1 LEFT OUTER JOIN t2 USING (id);
t1 t2 How many rows are returned by executing the following SQL statement?
SELECT * FROM t1 LEFT OUTER JOIN t2 USING (id);
정답: B
I would like to be able to save log entries as shown below. Select a correct configuration setting
from statements below.
LOG: connection received: host=[local] port=
LOG: connection authorized: user=postgres database=test
from statements below.
LOG: connection received: host=[local] port=
LOG: connection authorized: user=postgres database=test
정답: E
Select one incorrect statement about the SQL COPY command.
정답: B
The table "tbl" is defined below such that it could only store non-negative integers in the column
"nn".
Select the keyword that is applicable for the underlined blank.
CREATE _______ natural_number AS DECIMAL CHECK (VALUE >= 0); CREATE TABLE tbl(nn
natural_number);
"nn".
Select the keyword that is applicable for the underlined blank.
CREATE _______ natural_number AS DECIMAL CHECK (VALUE >= 0); CREATE TABLE tbl(nn
natural_number);
정답: A
Select an appropriate command to check the PostgreSQL version in psql.
정답: E
Select the most appropriate setting to output the log messages of the database to syslog.
정답: B