QUESTION: 65

The following SQL defines an INSERT with respect to item_view.
Select the keyword that is applicable in the underlined blank.
CREATE _______ foo AS ON INSERT TO item_view
DO INSTEAD INSERT INTO item_table VALUES (NEW.id, NEW.itemname);

RULE
VIEW
TRIGGER
FUNCTION
CONSTRAINT

Answer(s): A

Reveal Solution Next Question

QUESTION: 66

The tables "s1" and "s2" are defined below.
The column "id" for tables "s1" and "s2" is of INTEGER type. The column "enable" for table "s1" is
of
BOOLEAN type, and the column "name" for table "s2" is of TEXT type. s1:
id | enable
----+--------
1 | t
2 | f

s2:
id | name
----+------
1 | post
2 | gre
3 | SQL

The following SQL was executed. Select the correct number of rows in the result. SELECT * FROM s2 WHERE id IN (SELECT id FROM s1);

1 row
2 rows
3 rows
4 rows
5 rows

Answer(s): B

Reveal Solution Next Question

QUESTION: 67

A table is defined as below. Select the most suitable description about the foreign key constraint.
CREATE TABLE master (id INTEGER PRIMARY KEY, name TEXT);
CREATE TABLE record (id INTEGER REFERENCES master (id), count INTEGER);

If any row exists in the "record" table, no change can be made to the "master" table.
If the "record" table contains a row with an "id", no change can be made at all to the
corresponding "id" row in the "master" table.
If the "record" table contains a row with an "id", the corresponding "id" row in the "master"
table cannot be deleted.
The "record" table cannot have duplicate "id"s.
These SQL statements are invalid; no constraints are created.

Answer(s): C

Reveal Solution Next Question

QUESTION: 68

You want to create a cursor that will SELECT the "customer" table. The created cursor must be able to move in any direction and reference data even after the end of the transaction.
Select one answer containing the correct keyword(s) to fill in the underlined blank below.
DECLARE cursor1 __________ FOR SELECT * FROM customer;

CURSOR
SCROLL CURSOR WITH HOLD
INSENSITIVE CURSOR
NO SCROLL CURSOR WITH HOLD
CURSOR WITHOUT HOLD

Answer(s): B

Reveal Solution Next Question

Free PGCES-02 Exam Braindumps (page: 18)

QUESTION: 65

QUESTION: 66

QUESTION: 67

QUESTION: 68

PGCES-02 Exam Discussions & Posts