최신 PGCES-02 무료덤프 - PostgreSQL-CE PostgreSQL CE 8 Silver
What does the following command do? Select two correct descriptions regarding this SQL
statement.
SELECT * FROM information_schema.tables;
statement.
SELECT * FROM information_schema.tables;
정답: B,D
A pg_hba.conf file is set up as follows.
local all all md5
host all all 127.0.0.1/32 md5
host all all 172.16.1.0/24 md5
When user foo connects to database bar from host IP address 172.16.1.2, I would like password
verification to not be performed.
Select one appropriate line for the new pg_hba.conf file.
local all all md5
host all all 127.0.0.1/32 md5
host all all 172.16.1.0/24 md5
When user foo connects to database bar from host IP address 172.16.1.2, I would like password
verification to not be performed.
Select one appropriate line for the new pg_hba.conf file.
정답: E
Select two commands used to check the syntax of the ALTER TABLE statement in psql.
정답: A,C
The table "score" is defined as follows:
gid | score -----+------1 | 70 1 | 60 2 | 100 3 | 80 3 | 50 The following query was executed. Select the number of rows in the result. SELECT gid, max(score) FROM score GROUP BY gid HAVING max(score) > 60;
gid | score -----+------1 | 70 1 | 60 2 | 100 3 | 80 3 | 50 The following query was executed. Select the number of rows in the result. SELECT gid, max(score) FROM score GROUP BY gid HAVING max(score) > 60;
정답: E
Select an incorrect statement regarding the following SQL statement. Note that "user_view" is a
view.
CREATE OR REPLACE RULE rule_1 AS ON UPDATE TO user_view DO INSTEAD NOTHING;
view.
CREATE OR REPLACE RULE rule_1 AS ON UPDATE TO user_view DO INSTEAD NOTHING;
정답: B
Select two incorrect statements concerning the BOOLEAN type in PostgreSQL.
정답: A,C
You want to delete rows in the "product" table which include the value '2004' in the "name" field. Select the correct statement to achieve this task.
정답: C
The table "score" is defined as follows:
gid | score
-----+-------
1 | 70
1 | 60
2 | 100
3 | 80
3 | 50
The following query was executed. Select the correct result value.
SELECT score FROM score ORDER BY gid DESC, score ASC LIMIT 1;
gid | score
-----+-------
1 | 70
1 | 60
2 | 100
3 | 80
3 | 50
The following query was executed. Select the correct result value.
SELECT score FROM score ORDER BY gid DESC, score ASC LIMIT 1;
정답: B
Select a correct SQL command to change existing user "george"'s password to "foobar".
정답: A
Table "t1" is defined as follows:
CREATE TABLE t1 (value VARCHAR(5));
A set of SQL statements were executed in the following order.Select thenumber of rows that
table "t1" has after execution.
BEGIN;
INSERT INTO t1 VALUES ('AA');
SAVEPOINT point1;
INSERT INTO t1 VALUES ('BB');
SAVEPOINT point2;
INSERT INTO t1 VALUES ('CC');
ROLLBACK TO point1;
INSERT INTO t1 VALUES ('DD');
END;
CREATE TABLE t1 (value VARCHAR(5));
A set of SQL statements were executed in the following order.Select thenumber of rows that
table "t1" has after execution.
BEGIN;
INSERT INTO t1 VALUES ('AA');
SAVEPOINT point1;
INSERT INTO t1 VALUES ('BB');
SAVEPOINT point2;
INSERT INTO t1 VALUES ('CC');
ROLLBACK TO point1;
INSERT INTO t1 VALUES ('DD');
END;
정답: B