The "sample" table consists of the following data: How many rows are returned by executing the following SQL statement? SELECT * FROM sample WHERE v ~ 'ab';
Answer(s): C
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;
Answer(s): D
The "animal" table consists of the following data: Select the correct result returned by executing the following SQL statement: SELECT name FROM animal ORDER BY weight DESC LIMIT 2 OFFSET 1;
Answer(s): A
Four SQL statements were executed in the following order. CREATE TABLE foo (bar INT); ALTER TABLE foo ALTER bar TYPE BIGINT; ALTER TABLE foo ADD baz VARCHAR(5); ALTER TABLE foo DROP bar; Select two SQL statements that generate an error when executed.
Answer(s): B,D
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
To protect our content from bots for real learners like you, we ask you to register for free. Sign in or sign up now to continue with the PGCES-02 material!