A table named "sample" is defined as below. Select two statements which will generate a constraint error. CREATE TABLE sample ( i INTEGER PRIMARY KEY, j INTEGER, CHECK ( i > 0 AND j < 0 ) );
Answer(s): A,D
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.
Answer(s): B,E
Given the following two table definitions, select one SQL statement which will cause an error. CREATE TABLE sample1 (id INTEGER, data TEXT); CREATE TABLE sample2 (id INTEGER);
Answer(s): E
Select two suitable statements regarding creating a new table.
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!