callicon +1 210 504 8191
whatsAppIcon +1 210 415 9856
emailIcon info@koenig-solutions.com
koenig-logo
logo-30-years
Login
koenig-logo
+1 210 415 9856
+1 210 504 8191

PostgreSQL Database Administration Quiz Questions and Answers

Answer :
  • A transaction that re-executes a query, returning a set of rows that satisfy a search condition and then finds that the set of rows that have been satisfying the condition has changed due to another recently-committed transaction.

Explanation :

A transaction that re-executes a query, returning a set of rows that satisfy a search condition and then finds that the set of rows that have been satisfying the condition has changed due to another recently-committed transaction.
Answer :
  • A transaction that re-reads the data that it has previously read and then finds that data has already been modified by another transaction (that committed since the initial read).

Explanation :

A transaction that re-reads the data that it has previously read and then finds that data has already been modified by another transaction (that committed since the initial read)
Answer :
  • The Write-Ahead Logging enhances database reliability by logging changes before any changes or updates are made to the database

Explanation :

The Write-Ahead Logging enhances database reliability by logging changes before any changes or updates are made to the database
Answer :
  • Postgres has built in functions such as hash-table, B-tree, GIST indices can be used or users can define their own indices

Explanation :

Postgres has built in functions such as hash-table, B-tree, & GIST indices can be used or users can define their own indices
Answer :
  • A transaction when reads data that is written by a concurrent uncommitted transaction is the dirty read.

Explanation :

A transaction when reads data that is written by a concurrent uncommitted transaction is the dirty read.
Answer :
  • Table partitioning in PostgreSQL is the process of splitting a large table into smaller pieces.

Explanation :

Table partitioning in PostgreSQL is the process of splitting a large table into smaller pieces
Answer :
  • MVCC in PostgreSQL is used to avoid unnecessary locking of the database

Explanation :

MVCC in PostgreSQL is used to avoid unnecessary locking of the database
Answer :
  • <p>Both</p>

Explanation :

contrib or dblink allows cross-database queries using function calls.
Answer :
  • Indexes are used by the search engine to speed up data retrieval.

Explanation :

Indexes are used by the search engine to speed up data retrieval.
Answer :
  • <p>CREATE USER &lt; user_name &gt; with password &lsquo;&lt; password_here &gt;&rsquo;</p>

Explanation :

CREATE USER < user_name > WITH password ‘< password_here >’ ;