psql generated the following error message: psql: could not connect to server: Connection was refused Is the server running on host "server.example.com" and accepting TCP/IP connections on port 5432? Select two reasons that are NOT the cause of this error.
The table "custom" is defined below. The "id" column and "introducer" column are of
INTEGER type, and the "email" column is of TEXT type.
id | email | introducer ----+-- ---------------+-----------2 |
aaa@example.com | 1 3 |
bbb@example.com | 2 4 |
ccc@example.com | 2
Three SQL statements were executed in the following order:
UPDATE custom SET email = '' FROM custom c WHERE
custom.introducer = c.id; UPDATE custom SET introducer = NULL
WHERE introducer NOT IN (SELECT id FROM custom); DELETE
FROM custom WHERE id = 2 OR introducer = 2; Select the number of rows in the "custom" table after the execution.
Select two SQL statements which abort a transaction.
Select two incorrect descriptions regarding the following SQL statements.
CREATE TABLE cities ( name text,
population float ); CREATE
TABLE capitals ( state
char(2) ) INHERITS
(cities);
Select two incorrect statements regarding large objects.