To create a database in PostgreSQL, you must have the special CREATEDB privilege or
be a superuser.
Well Done. Your Answer is Correct Keep it Up!
have a script do it.
be an admin
the special CREATETBL privilege
Category: Databases MCQs
What does the following statement do? CREATE INDEX lower_title_idx ON books ((lower(title)));
What does the following statement do? CREATE INDEX lower_title_idx ON books ((lower(title)));
Creates an index for efficient case-insensitive searches on the titles column within the books table
Well Done. Your Answer is Correct Keep it Up!
Nothing, it’s invalid SQL
Creates a non-write-locking index
Creates a new index with a special operator class ‘lower’ for case insensitive comparisons.
The value NULL, in database terminology, means?
The value NULL, in database terminology, means?
All options are correct
Well Done. Your Answer is Correct Keep it Up!
The value is undetermined at this time
The value is not relevant for this particular row.
The value is undetermined
To describe a table in PostgreSQL which of the following is correct:
To describe a table in PostgreSQL which of the following is correct:
psql> \d table_name
Well Done. Your Answer is Correct Keep it Up!
psql> DESCRIBE table_name
psql> describe table_name
psql> \D table_name
The core PostgreSQL source code includes what interfaces?
The core PostgreSQL source code includes what interfaces?
The C and embedded C interfaces
Well Done. Your Answer is Correct Keep it Up!
VB and VB.NET interfaces
C++ and Java interfaces
Ruby and PHP interfaces
Unless you specify NOT NULL, PostgreSQL will assume that a column is:
Unless you specify NOT NULL, PostgreSQL will assume that a column is:
Optional
Well Done. Your Answer is Correct Keep it Up!
Required
Integers
Text
A VACUUM operation is used:
A VACUUM operation is used:
All options are correct
Well Done. Your Answer is Correct Keep it Up!
To recover or reuse disk space occupied by updated or deleted rows
To protect against loss of very old data due to transaction ID wraparound.
To update data statistics used by the PostgreSQL query planner.
If you don’t specify ASC or DESC, PostgreSQL will assume you want to see results:
If you don’t specify ASC or DESC, PostgreSQL will assume you want to see results:
in ascending order
Well Done. Your Answer is Correct Keep it Up!
grouped together by field type
in a random order
in descending order
PostgreSQL has many modern features including:
PostgreSQL has many modern features including:
All options are correct
Well Done. Your Answer is Correct Keep it Up!
Complex SQL queries
SQL Sub-selects
Views
If you don’t specify ASC or DESC, PostgreSQL will assume you want to see results:
If you don’t specify ASC or DESC, PostgreSQL will assume you want to see results:
in ascending order
Well Done. Your Answer is Correct Keep it Up!
grouped together by field type
in a random order
in descending order