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.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- add column with foreign key postgres
- psql v12 sp1 known issues general release june
- codified postgresql schema pgcon
- spring boot postgresql create database if not exists
- add column if not exists postgres
- pg stat statements does not exist
- introduction to hacking postgresql
- tda357 dit621 databases
- known issues psql11sp3 actian
- postgresql tuning for oracle dbas
Related searches
- postgresql if not exist
- postgresql execute sql script
- postgresql execute format
- postgresql list users
- postgresql execute using
- postgresql execute query
- postgresql show all users
- postgresql database does not exist
- postgresql execute into
- create a local postgresql database
- create user postgresql 9 5
- postgresql function execute sql