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.

Related Posts:

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’.

Related Posts:

To restore a PostgreSQL backup created with pg_dump, the following may be used:

administrator
To restore a PostgreSQL backup created with pg_dump, the following may be used:
$ psql -f database_dump.psql database_name
Well Done. Your Answer is Correct Keep it Up!
$ psql -r database_dump.psql database_name
$ psql -R database_dump.psql database_name
$ psql -F database_dump.psql database_name

Related Posts:

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

Related Posts:

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

Related Posts:

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.

Related Posts:

What command allows you to edit PostgreSQL queries in your favorite editor ?

administrator
What command allows you to edit PostgreSQL queries in your favorite editor ?
\e
Well Done. Your Answer is Correct Keep it Up!
\edit
edit sql #go
\ed

Related Posts:

To create a database in PostgreSQL, you must have the special CREATEDB privilege or

administrator
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

Related Posts:

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.

Related Posts:

The value NULL, in database terminology, means?

administrator
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

Related Posts:

Page 1 of 3
1 2 3