Vendor: PostgreSQL PGCES-02

[Pages:8] 2022 Latest certbus PGCES-02 PDF and VCE dumps Download

PGCES-02Q&As

PostgreSQL CE 8 Silver

Pass PostgreSQL-CE PGCES-02 Exam with 100% Guarantee

Free Download Real Questions & Answers PDF and VCE file from:



100% Passing Guarantee 100% Money Back Assurance Following Questions and Answers are all new published by PostgreSQL-

CE Official Exam Center

PGCES-02 VCE Dumps | PGCES-02 Practice Test | PGCES-02 Braindumps

1 / 8

 2022 Latest certbus PGCES-02 PDF and VCE dumps Download

QUESTION 1 The table "foo" is defined as follows: CREATE TABLE foo (bar TEXT); Next, four SQL statements were executed in the following order. INSERT INTO foo VALUES (\\'bar\\'); -------- (1) ALTER TABLE foo ADD COLUMN c1 TEXT; ---- (2) ALTER TABLE foo ADD UNIQUE (c1); ------- (3) ALTER TABLE foo DROP COLUMN bar; ------- (4) Select the correct statement from those below. A. An error occurs when executing the (1) SQL statement. B. An error occurs when executing the (2) SQL statement. C. An error occurs when executing the (3) SQL statement. D. An error occurs when executing the (4) SQL statement. E. No error is generated. Correct Answer: E

QUESTION 2 Select the most suitable statement about PostgreSQL from below. A. There are PostgreSQL GPL license versions and commercial license versions. B. You need to be pre-registered to use PostgreSQL. C. PostgreSQL can be used by everyone free of charge for any purpose, be it private, commercial, or academic. D. You can use PostgreSQL for free; however, the source code is not open to the public. E. PostgreSQL is shareware. Correct Answer: C

QUESTION 3

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\\';

PGCES-02 VCE Dumps | PGCES-02 Practice Test | PGCES-02 Braindumps

2 / 8

 2022 Latest certbus PGCES-02 PDF and VCE dumps Download

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

QUESTION 4 I want to restore data from a text format backup file foo.dump. Select an appropriate command. A. pg_dump -R foo B. pg_restore -d foo foo.dump C. pg_restore -f foo.dump foo D. psql -f foo.dump foo E. createdb foo

Correct Answer: D

QUESTION 5 I would like to check the privileges on the "items" table in psql. Select the most appropriate command. A. \a items B. \d items C. \t items D. \p items E. \z items Correct Answer: E

QUESTION 6 Select a correct SQL command to change existing user "george"\\'s password to "foobar". A. ALTER USER george WITH PASSWORD \\'foobar\\';

PGCES-02 VCE Dumps | PGCES-02 Practice Test | PGCES-02 Braindumps

3 / 8

 2022 Latest certbus PGCES-02 PDF and VCE dumps Download

B. ALTER USER george CHANGE PASSWORD \\'foobar\\'; C. ALTER USER george SET PASSWORD \\'foobar\\'; D. SET USER george PASSWORD TO \\'foobar\\'; E. SET USER george ALTER PASSWORD \\'foobar\\'; Correct Answer: A

QUESTION 7 What phenomenon occurs if PostgreSQL is used without performing VACUUM ? Select two appropriate descriptions from those below. A. Performance is reduced. B. It gradually gets to the point where connections are denied. C. The physical size of the database increases considerably in size. D. Only SELECT queries will be accepted. E. An e-mail prompting the administrator to perform VACUUM is sent from PostgreSQL. Correct Answer: AC

QUESTION 8 What happens if an SQL statement syntax error occurs while a transaction is running? Select the correct action from below. A. The transaction continues. B. The transaction is aborted and a new transaction is started automatically. C. The transaction is stopped and you cannot issue any SQL commands other than a command to end the transaction. D. The connection is terminated. E. The "postmaster" process is terminated. Correct Answer: C

QUESTION 9 Select two incorrect descriptions regarding the following SQL statements. CREATE TABLE cities ( name text, population float PGCES-02 VCE Dumps | PGCES-02 Practice Test | PGCES-02 Braindumps

4 / 8

 2022 Latest certbus PGCES-02 PDF and VCE dumps Download

); CREATE TABLE capitals ( state char(2) ) INHERITS (cities); A. Defines the tables called "cities" and "capitals". B. "capitals" inherits "cities". C. Searching "capitals" also searches rows in "cities". D. The columns "name" and "population" are also defined in "capitals". E. The second SQL statement results in an error, since the \\'INHERITS\\' keyword is no longer available. Correct Answer: CE

QUESTION 10

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@ | 1 3 | bbb@ | 2 4 | ccc@ | 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.

A. 0 rows

B. 1 row

C. 2 rows

D. 3 rows

E. 4 rows

Correct Answer: A

QUESTION 11 A set of tables are defined as follows: t1 t2 How many rows are returned by executing the following SQL statement? SELECT * FROM t1 WHERE EXISTS (SELECT name FROM t2 WHERE t1.id = t2.id); A. 0 rows B. 2 rows C. 3 rows D. 5 rows

PGCES-02 VCE Dumps | PGCES-02 Practice Test | PGCES-02 Braindumps

5 / 8

E. 6 rows Correct Answer: B

2022 Latest certbus PGCES-02 PDF and VCE dumps Download

QUESTION 12 Select one incorrect description about changing the settings of PostgreSQL during operation. A. The current value of a parameter can be confirmed using the SHOW command. B. All of the current settings can be displayed using the SHOW ALL command. C. Changes that can be made using the SET command have higher priority than ones in postgresql.conf. D. Values set by a superuser using the SET command are valid for different connections made later. E. There are parameters that can not be set using the SET command Correct Answer: D

QUESTION 13 Configuration file pg_hda.conf is set as below on a host currently running PostgreSQL. local all all trust host all 192.168.1.0/24 reject host all all 192.168.0.0/16 trust Select a host IP address which is authorized to connect to this database via the network. Note: INET domain socket communication is available. A. 127.0.0.1 B. 192.168.1.1 C. 192.168.0.1 D. 192.168.1.0 E. None can be connected. Correct Answer: C

QUESTION 14 Select two SQL statements which abort a transaction. A. END B. ROLLBACK C. TRUNCATE PGCES-02 VCE Dumps | PGCES-02 Practice Test | PGCES-02 Braindumps

6 / 8

D. ABORT E. DROP TRANSTACTION Correct Answer: BD

2022 Latest certbus PGCES-02 PDF and VCE dumps Download

QUESTION 15 Select two incorrect statements regarding \\'TRIGGER\\'. A. When UPDATE is executed to the table, the specified function can be called. B. When INSERT is executed to the table, the specified function can be called. C. When SELECT is executed to the table, the specified function can be called. D. A trigger can be set up to call a specified function before or after the event occurs. E. A corresponding rule is automatically created when a trigger is created. Correct Answer: CE

PGCES-02 VCE Dumps

PGCES-02 Practice Test

PGCES-02 Braindumps

PGCES-02 VCE Dumps | PGCES-02 Practice Test | PGCES-02 Braindumps

7 / 8

 2022 Latest certbus PGCES-02 PDF and VCE dumps Download

To Read the Whole Q&As, please purchase the Complete Version from Our website.

Try our product !

100% Guaranteed Success 100% Money Back Guarantee 365 Days Free Update Instant Download After Purchase 24x7 Customer Support Average 99.9% Success Rate More than 800,000 Satisfied Customers Worldwide Multi-Platform capabilities - Windows, Mac, Android, iPhone, iPod, iPad, Kindle

We provide exam PDF and VCE of Cisco, Microsoft, IBM, CompTIA, Oracle and other IT Certifications. You can view Vendor list of All Certification Exams offered:



Need Help

Please provide as much detail as possible so we can best assist you. To update a previously submitted ticket:

Any charges made through this site will appear as Global Simulators Limited. All trademarks are the property of their respective owners. Copyright ? certbus, All Rights Reserved.

PGCES-02 VCE Dumps | PGCES-02 Practice Test | PGCES-02 Braindumps

Powered by TCPDF ()

8 / 8

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download