最新的PostgreSQL-CE PostgreSQL CE 8 Silver - PGCES-02免費考試真題
問題1
Select two suitable statements about the BSD license from below.
正確答案: C,E
問題2
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
問題3
The following is the result of executing the createlang command which is installed with
PostgreSQL.
$ createlang -U postgres --list mydb
Procedural Languages
Name | Trusted?
---------+----------
plpgsql | yes
Select two correct statements from below.
PostgreSQL.
$ createlang -U postgres --list mydb
Procedural Languages
Name | Trusted?
---------+----------
plpgsql | yes
Select two correct statements from below.
正確答案: A,C
問題4
Select two incorrect statements concerning the system catalog.
正確答案: A,B
問題5
The tables "s1" and "s2" are defined below.
The column "id" for tables "s1" and "s2" is of INTEGER type. The column "enable" for table "s1" is
of
BOOLEAN type, and the column "name" for table "s2" is of TEXT type.
s1:
id | enable
----+--------
1 | t
2 | f
s2:
id | name
----+-----
1 | post
2 | gre
3 | SQL
The following SQL was executed. Select the correct number of rows in the result. SELECT * FROM s2 WHERE id IN (SELECT id FROM s1);
The column "id" for tables "s1" and "s2" is of INTEGER type. The column "enable" for table "s1" is
of
BOOLEAN type, and the column "name" for table "s2" is of TEXT type.
s1:
id | enable
----+--------
1 | t
2 | f
s2:
id | name
----+-----
1 | post
2 | gre
3 | SQL
The following SQL was executed. Select the correct number of rows in the result. SELECT * FROM s2 WHERE id IN (SELECT id FROM s1);
正確答案: D
問題6
What does the following command do? Select the correct description from below. Note: "text=#" is
the command prompt for psql.
test=# ANALYZE foo;
the command prompt for psql.
test=# ANALYZE foo;
正確答案: A
