Select two suitable statements regarding the data types of PostgreSQL.
Answer(s): A,D
The table "score" is defined as follows: gid | score -----+-------1 | 701 | 602 | 1003 | 803 | 50The 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;
Answer(s): C
Table "t1" is defined as follows: CREATE TABLE t1 (value VARCHAR(5)); A set of SQL statements were executed in the following order. Select the number 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;
Answer(s): B
Select two suitable statements about sequences.
Answer(s): B,E
Post your Comments and Discuss Postgresql PGCES-02 exam with other Community members:
Arun T Commented on December 21, 2024 excellent course. Helps me a lot Anonymous
Gabe Commented on January 02, 2020 easy check out UNITED STATES
Our website is free, but we have to fight against bots and content theft. We're sorry for the inconvenience caused by these security measures. You can access the rest of the PGCES-02 content, but please register or login to continue.