QUESTION: 61

What happens if an SQL statement syntax error occurs while a transaction is running? Select the correct action from below.

The transaction continues.
The transaction is aborted and a new transaction is started automatically.
The transaction is stopped and you cannot issue any SQL commands other than a command to end the transaction.
The connection is terminated.
The "postmaster" process is terminated.

Answer(s): C

Reveal Solution Next Question

The table "tbl" is defined below such that it could only store non-negative integers in the column
"nn".
Select the keyword that is applicable for the underlined blank.
CREATE _______ natural_number AS DECIMAL CHECK (VALUE >= 0); CREATE TABLE tbl(nn natural_number);

VIEW
SCHEMA
RULE
TYPE
DOMAIN

Answer(s): E

Reveal Solution Next Question

QUESTION: 63

In the "customer" table, you want to change the "email" values which have an "id" value of 10000 or less, to NULL. Select the correct SQL statement to achieve this task.

UPDATE email = NULL FROM customer WHERE id <= 10000;
UPDATE customer SET email IS NULL WHERE id < 10001;
UPDATE customer SET email = NULL WHERE id <= 10000;
DELETE FROM customer.email WHERE id < 10001;
UPDATE FROM customer SET email = NULL WHERE id <= 10000;

Answer(s): C

Reveal Solution Next Question

QUESTION: 64

Select one incorrect description regarding the following SQL statement defining a function.
CREATE OR REPLACE FUNCTION get_file_list(TEXT, BOOLEAN)
RETURNS SETOF TEXT LANGUAGE C STRICT
SECURITY DEFINER AS 'myfuncs.so';

This function may be defined in 'myfuncs.so'.
This function can return multiple rows.
This SQL statement defines a function written in the C language.
If this function is called with a NULL parameter, it will return 0 when executed.
This function operates with the authority of the user who executed it.

Answer(s): E

Reveal Solution Next Question

Free PGCES-02 Exam Braindumps (page: 17)

QUESTION: 61

QUESTION: 62

QUESTION: 63

QUESTION: 64

PGCES-02 Exam Discussions & Posts