QUESTION: 57

The "sample" table consists of the following data.
How many rows are returned by executing the following SQL statement?
SELECT i FROM sample GROUP BY i;

1 row
2 rows
3 rows
4 rows
5 rows

Answer(s): C

Reveal Solution Next Question

The tables "t1" and "t2" are defined below.
Tables "t1" and "t2" have columns "id" that are of INTEGER type, and columns "name" that are of TEXT type.
t1
t2
The following SQL command was executed. Select the number of rows in the result. SELECT * FROM t1 RIGHT OUTER JOIN t2 ON t1.id = t2.id;

2 rows
3 rows
4 rows
5 rows
6 rows

Answer(s): B

Reveal Solution Next Question

QUESTION: 59

Select the SQL command that must be executed prior to executing the EXECUTE command.

CREATE FUNCTION
PREPARE
DECLARE
LOAD
ALLOCATE

Answer(s): B

Reveal Solution Next Question

QUESTION: 60

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

SELECT s1.id FROM sample1 s1;
SELECT s1.id FROM sample1 AS s1;
SELECT data FROM sample1 AS s1, sample2 AS s2
WHERE s1.id = 1 AND s2.id = 2;
SELECT id, data FROM sample1 AS s1, sample2 AS s2
WHERE s1.id = s2.id;
SELECT s1.id, s1.data FROM sample1 AS s1, sample2 AS s2
WHERE s1.id = s2.id;

Answer(s): D

Reveal Solution Next Question

Free PGCES-02 Exam Braindumps (page: 16)

QUESTION: 57

QUESTION: 58

QUESTION: 59

QUESTION: 60

Exam Discussions & Posts