PostgreSQL-CE PGCES-02 Online Practice Questions and Exam Preparation

PostgreSQL-CE PGCES-02 Online Questions & Answers

• Question 111:

  The following question concerns the use of multibyte characters in PostgreSQL. Select two correct items about character encoding in PostgreSQL.

  A. "./configure --enable-multibyte" must be designated at time of build.
  B. When the database cluster is initialized, the or --multibyte option must be specified.
  C. Character encoding can be set on a per database basis.
  D. Only a single character encoding can be specified for each database cluster.
  E. Different character encodings can be specified for server and clients.
  C. Character encoding can be set on a per database basis.
  E. Different character encodings can be specified for server and clients.

• Question 112:

  The table "tbl" is defined below such that it could only store non-negative integers in the column "nn".

  Select the keyword that is applicable for the underlined blank. CREATE natural_number AS DECIMAL CHECK (VALUE >= 0); CREATE TABLE tbl(nn natural_number);

  A. VIEW
  B. SCHEMA
  C. RULE
  D. TYPE
  E. DOMAIN
  E. DOMAIN

• Question 113:

  A table named "sample" is defined as below. Select two statements which will generate a constraint error.

  CREATE TABLE sample (

  i INTEGER PRIMARY KEY, j INTEGER,

  CHECK ( i > 0 AND j < 0 )

  );

  A. INSERT INTO sample VALUES (1, 0);
  B. INSERT INTO sample VALUES (2, -2);
  C. INSERT INTO sample VALUES (3, NULL);
  D. INSERT INTO sample VALUES (NULL, -4);
  E. INSERT INTO sample VALUES (5, -5);
  A. INSERT INTO sample VALUES (1, 0);
  D. INSERT INTO sample VALUES (NULL, -4);

• Question 114:

  Select two incorrect descriptions regarding the following SQL statements. CREATE TABLE cities ( name

  text, population

  float

  );

  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.
  C. Searching "capitals" also searches rows in "cities".
  E. The second SQL statement results in an error, since the 'INHERITS' keyword is no longer available.

• Question 115:

  Which psql command do you need to execute to display the list of tables in the currently connected database?

  A. SELECT * FROM pg_table_list;
  B. SHOW tables;
  C. \dT
  D. \dt "database_name"
  E. \dt
  E. \dt

• Question 116:

  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.
  C. PostgreSQL can be used by everyone free of charge for any purpose, be it private, commercial, or academic.

• Question 117:

  The table "score" is defined as follows: gid | score -----+------1 | 70 1 | 60 2 | 100 3 | 80 3 | 50 The following query was executed. Select the correct result value. SELECT score FROM score ORDER BY gid DESC, score ASC LIMIT 1;

  A. 50
  B. 60
  C. 70
  D. 80
  E. 100
  A. 50

• Question 118:

  The "sample" table consists of the following data:

  How many rows are returned by executing the following SQL statement? SELECT i FROM sample GROUP BY i HAVING count(*) = 2;

  A. 0 rows
  B. 1 row
  C. 2 rows
  D. 3 rows
  E. 4 rows
  C. 2 rows

• Question 119:

  The "sample" table consists of the data below. The column "x" is of type INTEGER. How many rows are returned by executing the following SQL statement? SELECT 6 / x FROM sample WHERE CASE WHEN x = 0 THEN FALSE ELSE TRUE END;

  A. "ERROR division by zero" and no rows are returned.
  B. 0 rows with no errors.
  C. 1 row
  D. 2 rows
  E. 3 rows
  D. 2 rows

• Question 120:

  Based on the following request, select the most appropriate command for creating a database cluster.

  ?Character encoding of the template database needs to be EUC_JP ?Locale is not used

  A. initdb --locale=EUC_JP --no-encoding
  B. initdb --default-encoding=EUC_JP
  C. pg_ctl init --locale=EUC_JP
  D. initdb --encoding=EUC_JP --no-locale
  E. pg_ctl init --encoding=EUC_JP
  D. initdb --encoding=EUC_JP --no-locale