QUESTION: 21

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

INSERT INTO sample VALUES (1, 0);
INSERT INTO sample VALUES (2, -2);
INSERT INTO sample VALUES (3, NULL);
INSERT INTO sample VALUES (NULL, -4);
INSERT INTO sample VALUES (5, -5);

Answer(s): A,D

Reveal Solution Next Question

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.

The procedural language plpgsql is installed in the database mydb using the above command.
The procedural language plpgsql can be used in the database mydb.
plpgsql is a trusted language, so it can execute the OS commands on the server side.
plpgsql is a trusted language, so it can read/write OS files on the server side.
plpgsql is a safe language with restricted operations.

Answer(s): B,E

Reveal Solution Next Question

QUESTION: 23

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