QUESTION: 53

The present time is noon of July 7th, 2007, and the result of the following
SQL sentence was '2007-07-17 12:00:00'.
Select the correct expression to fill in the blank below.
SELECT CURRENT_TIMESTAMP::timestamp + ________________ ;

'10 day'::timestamp
'10 day'::interval
10::day
8640000::time
age(8640000)

Answer(s): B

Reveal Solution Next Question

QUESTION: 54

You want to set a constraint so that the "item_id" in the "sales" table will always have a value that
already exists as "id" in the "item_master" table. Select the correct SQL statement to fill in the
underlined blank of the "sales" table. Definitions:
CREATE TABLE item_master (
id INTEGER PRIMARY KEY,
name TEXT
);
CREATE TABLE sales (
sales_id INTEGER,
item_id INTEGER,
num INTEGER,
);

FOREIGN KEY (id) REFERENCES item_master (item_id)
FOREIGN KEY (item_id) REFERENCES item_master (id)
REFERENCES item_master (item_id)
REFERENCES item_master (id)
REFERENCES item_master (id) TO item_id

Answer(s): B

Reveal Solution Next Question

QUESTION: 55

You want to delete rows in the "product" table which include the value '2004' in the "name" field. Select the correct statement to achieve this task.

DELETE product WHERE name ~ '2004';
DELETE product WHERE contain(name, '2004');
DELETE FROM product WHERE name IN '2004';
DELETE FROM product WHERE name LIKE '%2004%';
DELETE FROM product WHERE name SIMILAR TO '2004';

Answer(s): D

Reveal Solution Next Question

QUESTION: 56

There is a table "tb1" that has a column "c1" defined as type TEXT. The following SQL is executed while client "A" is connected.
BEGIN;
LOCK TABLE tb1 IN ACCESS EXCLUSIVE MODE; SELECT * FROM tb1;
While the above 'SELECT' statement is being executed, client "B" connects to the same database and executes the following SQL.
Select two correct statements describing the behavior of PostgreSQL.
INSERT INTO tb1 (c1) VALUES ('new line');
Note: the default transaction isolation level is set to "read committed".

The process for client "B" is blocked until the current connection for client "A" is finished.
The process for client "B" is blocked until the current transaction for client "A" is finished.
The process for client "B" will be deleted regardless of the condition of client "A".
The process of client "B" will affect the SELECT result of client "A".
The process of client "B" will not affect the SELECT result of client "A".

Answer(s): B,E

Reveal Solution Next Question

Free PGCES-02 Exam Braindumps (page: 15)

QUESTION: 53

QUESTION: 54

QUESTION: 55

QUESTION: 56

PGCES-02 Exam Discussions & Posts