Category: PostgreSQL MCQs

Which statement is true about PostgreSQL data types?

administrator
Which statement is true about PostgreSQL data types?
There is a non-standard PostgreSQL data type, called Geometric data type, which handles 2-dimensional data.
Well Done. Your Answer is Correct Keep it Up!
n’in CHARACTER(n) represents the number of bytes.
Only the INTEGER type can be declared as an array.
A large object data type can be used to store data of unlimited size.

Which statement is not true about a PostgreSQL domain?

administrator
Which statement is not true about a PostgreSQL domain?
Domain is a namespace existing between databases and objects such as tables.
Well Done. Your Answer is Correct Keep it Up!
When defining a domain, you can add a default value and constraints to the original data.
A domain can be used as a column type when defining a table.
A domain is created by ‘CREATE DOMAIN’.

The __________ database model has the advantage of being able to quickly discover all of the records of one type that are related to a specific record of another type by following the pointers from the starting record.

administrator
The __________ database model has the advantage of being able to quickly discover all of the records of one type that are related to a specific record of another type by following the pointers from the starting record.
network
Well Done. Your Answer is Correct Keep it Up!
relational
hierarchical
structured

To copy a database from server1 to server2, you might use which of the following:

administrator
To copy a database from server1 to server2, you might use which of the following:
pg_dump -h server1 database | psql -h server2 database
Well Done. Your Answer is Correct Keep it Up!
pg_copy -h server1 database | psql -h server2 database
pg_dump -h server1 database > pgsql -h server2 database
pg_mv -h server1 database | pgsql -h server2 database

What is “index bloat”?

administrator
What is “index bloat”?
No-longer-needed keys in an index aren’t reclaimed, therefore increasing space required to store an index, as well as time it takes to scan.
Well Done. Your Answer is Correct Keep it Up!
Index filling up with keys.
Indexing inefficiently, like choosing to index timestamps in a table.
Indexing too many tables, resulting in inefficient database performance.

What does the following statement do? CREATE INDEX lower_title_idx ON books ((lower(title)));

administrator
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.
Page 1 of 3
1 2 3