QUESTION: 29

Select the most suitable statement about PostgreSQL from below.

PostgreSQL is a card-type database management system.
PostgreSQL is a hierarchical database management system.
PostgreSQL is a network-type database management system.
PostgreSQL is an XML database management system.
PostgreSQL is a relational database management system.

Answer(s): E

Reveal Solution Next Question

QUESTION: 30

Select the most suitable statement about the PostgreSQL license from below.

PostgreSQL is distributed under the GPL license.
PostgreSQL is distributed under the PostgreSQL license.
PostgreSQL is distributed under the LGPL license.
PostgreSQL is distributed under the BSD license.
PostgreSQL is distributed under the X11(MIT) license.

Answer(s): D

Reveal Solution Next Question

QUESTION: 31

Select one incorrect statement regarding psql.

psql is an interactive SQL interpreter that enables a user to enter queries.
For system security, only the PostgreSQL administrator account is allowed to use psql.
"psql -l" displays a database list.
"psql -U jan" will connect to the database called jan.
Commands that begin with a backslash are processed internally in psql.

Answer(s): B

Reveal Solution Next Question

I would like to insert the contents of the text file users.dat into the table t1 using psql. Contents of text file users.dat:
Definition of table t1:
CREATE TABLE t1 (uname TEXT, pass TEXT, id INTEGER); Select the most appropriate input from those below.

\copy t1 FROM users.dat WITH DELIMITER ':'
\copy t1 TO users.dat WITH DELIMITER ':'
INSERT INTO t1 FROM file('users.dat');
INSERT INTO t1 SELECT uname, pass, id FROM file('users.dat');
\insert t1 FROM users.dat WITH DELIMITER ':';

Answer(s): A

Reveal Solution Next Question

Free PGCES-02 Exam Braindumps (page: 8)

QUESTION: 29

QUESTION: 30

QUESTION: 31

QUESTION: 32