100% Pass Guarantee with PostgreSQL-CE PGCES-02 Dumps!

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);

A. SELECT id AS data, data FROM sample1;

B. SELECT id, id FROM sample1;

C. SELECT s1.id, s2.id FROM sample1 AS s1, sample1 AS s2;

D. SELECT s1.id, s2.id FROM sample1 s1, sample2 s2;

E. SELECT s1.id, s2.data FROM sample1 s1, sample2 s2;

Select one incorrect statement about the SQL COPY command.

A. It copies data between a file and a table.

B. You can output the row data of a table to a specified client side file.

C. Copies row data from a file into a table.

D. Only the superuser can specify the output file name.

E. The delimiter that separates column data can be changed from the default TAB character.

Select two commands used to check the syntax of the ALTER TABLE statement in psql.

A. \h ALTER TABLE

B. \h ALTER

C. \ ALTER TABLE

D. \ ALTER

E. HELP ALTER TABLE;