20:00

PDF|

Guide for PGCES-02: PostgreSQL CE 8 Silver

Quiz PGCES-02: PostgreSQL CE 8 Silver

Free Test
/ 10

Quiz

1/10
Argument1
SQL statements were executed in the following order. CREATE TABLE book (id VARCHAR(21),
title TEXT NOT NULL, price INT, UNIQUE (id), CHECK (price > 0) );
INSERT INTO book VALUES ('4-12345-678-9', 'SQL book', 2300); --(1) INSERT INTO book (title,
price) VALUES ('PostgreSQL', 3000); --(2) UPDATE book SET id = '4-12345-678-9' WHERE id IS NULL;
--(3)
DELETE FROM book WHERE price < 0; --(4)
While executing, select the first location that generates an error.
Select the answer
1 correct answer
A.
(1)
B.
(2)
C.
(3)
D.
(4)
E.
No error is generated.

Quiz

2/10
Argument5
Select two incorrect statements regarding 'DOMAIN'.
Select the answer
2 correct answers
A.
When defining a domain, you can add a default value and constraints to the original data.
B.
Domain is a namespace existing between databases and objects such as tables.
C.
A domain is created by 'CREATE DOMAIN'.
D.
A domain can be used as a column type when defining a table.
E.
To define a domain, both input and output functions are required.

Quiz

3/10
Argument0
I would like to be able to save log entries as shown below. Select a correct configuration setting
from statements below.
LOG: connection received: host=[local] port=
LOG: connection authorized: user=postgres database=test
Select the answer
1 correct answer
A.
log_connections = true
B.
log_hostname = true
C.
syslog = true
D.
log_authorization = true
E.
log_min_level = log

Quiz

4/10
Argument3
What does the following command do? Choose the most appropriate statement from the
selection
below.
Note: $ is the command prompt.
$ pg_dump postgres > pgsql
Select the answer
1 correct answer
A.
Writes a backup of the database postgres to the file pgsql.
B.
Writes a backup of the entire database cluster using user postgres to the file pgsql.
C.
Backs up the database postgres and writes an error message to the file pgsql.
D.
Writes a backup of the entire database cluster to the file postgres and writes an error message to
the file pgsql.
E.
Outputs all of the content of the database postgres to the screen using the user pgsql.

Quiz

5/10
Argument2
Select two correct statements about the command shown below. Note: $ is the command




prompt. $ vacuumdb -az
Select the answer
2 correct answers
A.
Recovers unused areas from all of the databases.
B.
Collects statistical information related to the table content for all of the databases.
C.
Processes the job equivalent of the VACUUM FULL command for all of the databases.
D.
Processes the job equivalent of the VACUUM VERBOSE command for all of the databases.
E.
The database can not be accessed until this command is finished.

Quiz

6/10
Argument4
The tables "t1" and "t2" are defined below.
The tables "t1" and "t2" have columns "id" which are type of INTEGER and column "name"s which
are type of TEXT.
t1
t2
The following SQL command was executed. Select the number of rows in the result. SELECT *
FROM t1 NATURAL FULL OUTER JOIN t2;
Select the answer
1 correct answer
A.
2 rows
B.
3 rows
C.
4 rows
D.
5 rows
E.
6 rows

Quiz

7/10
Argument1
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 + ________________ ;
Select the answer
1 correct answer
A.
'10 day'::timestamp
B.
'10 day'::interval
C.
10::day
D.
8640000::time
E.
age(8640000)

Quiz

8/10
Argument5
Select one incorrect statement from the below about a database cluster.
Select the answer
1 correct answer
A.
It is possible to have multiple databases within a database cluster.
B.
A database cluster is created usinginitdb command.
C.
Each host can have only one database cluster.
D.
Special databases called template0 and template1 are created in a database cluster by default.
E.
When a database cluster is created, a databasesuperuser is registered using the username of the
OS at the time of creation unless otherwise designated.

Quiz

9/10
Argument0
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';
Select the answer
1 correct answer
A.
This function may bedefined in 'myfuncs.so'.
B.
This function can return multiple rows.
C.
This SQL statementdefines 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 functionoperates with the authority of the user who executed it.

Quiz

10/10
Argument3
Select two statements that the command below DOES NOT do.
Note: $ is the command prompt. $ pg_dump -b -F c b > d
Select the answer
2 correct answers
A.
Backs up the "b" database to the "c" file, and stores error messages to the "d" file.
B.
Backs up the "b" database to the "d" file.
C.
Backs up large objects.
D.
Backs up the "c" database to the "d" file as the "c" user.
E.
Creates a backup, which is restorable with thepg_restore command.
Looking for more questions?Buy now

PGCES-02: PostgreSQL CE 8 Silver Practice test unlocks all online simulator questions

Thank you for choosing the free version of the PGCES-02: PostgreSQL CE 8 Silver practice test! Further deepen your knowledge on PostgreSQL-CE Simulator; by unlocking the full version of our PGCES-02: PostgreSQL CE 8 Silver Simulator you will be able to take tests with over 144 constantly updated questions and easily pass your exam. 98% of people pass the exam in the first attempt after preparing with our 144 questions.

BUY NOW

What to expect from our PGCES-02: PostgreSQL CE 8 Silver practice tests and how to prepare for any exam?

The PGCES-02: PostgreSQL CE 8 Silver Simulator Practice Tests are part of the PostgreSQL-CE Database and are the best way to prepare for any PGCES-02: PostgreSQL CE 8 Silver exam. The PGCES-02: PostgreSQL CE 8 Silver practice tests consist of 144 questions and are written by experts to help you and prepare you to pass the exam on the first attempt. The PGCES-02: PostgreSQL CE 8 Silver database includes questions from previous and other exams, which means you will be able to practice simulating past and future questions. Preparation with PGCES-02: PostgreSQL CE 8 Silver Simulator will also give you an idea of the time it will take to complete each section of the PGCES-02: PostgreSQL CE 8 Silver practice test . It is important to note that the PGCES-02: PostgreSQL CE 8 Silver Simulator does not replace the classic PGCES-02: PostgreSQL CE 8 Silver study guides; however, the Simulator provides valuable insights into what to expect and how much work needs to be done to prepare for the PGCES-02: PostgreSQL CE 8 Silver exam.

BUY NOW

PGCES-02: PostgreSQL CE 8 Silver Practice test therefore represents an excellent tool to prepare for the actual exam together with our PostgreSQL-CE practice test . Our PGCES-02: PostgreSQL CE 8 Silver Simulator will help you assess your level of preparation and understand your strengths and weaknesses. Below you can read all the quizzes you will find in our PGCES-02: PostgreSQL CE 8 Silver Simulator and how our unique PGCES-02: PostgreSQL CE 8 Silver Database made up of real questions:

Info quiz:

  • Quiz name:PGCES-02: PostgreSQL CE 8 Silver
  • Total number of questions:144
  • Number of questions for the test:50
  • Pass score:80%

You can prepare for the PGCES-02: PostgreSQL CE 8 Silver exams with our mobile app. It is very easy to use and even works offline in case of network failure, with all the functions you need to study and practice with our PGCES-02: PostgreSQL CE 8 Silver Simulator.

Use our Mobile App, available for both Android and iOS devices, with our PGCES-02: PostgreSQL CE 8 Silver Simulator . You can use it anywhere and always remember that our mobile app is free and available on all stores.

Our Mobile App contains all PGCES-02: PostgreSQL CE 8 Silver practice tests which consist of 144 questions and also provide study material to pass the final PGCES-02: PostgreSQL CE 8 Silver exam with guaranteed success. Our PGCES-02: PostgreSQL CE 8 Silver database contain hundreds of questions and PostgreSQL-CE Tests related to PGCES-02: PostgreSQL CE 8 Silver Exam. This way you can practice anywhere you want, even offline without the internet.

BUY NOW