Component of a database is responsible for ensuring atomicity and durability.
recovery management
Well Done. Your Answer is Correct Keep it Up!
concurrency control
storage management
query evaluation engine
Category: Databases MCQs
Which protocol permits release of exclusive locks only at the end of transaction?
Which protocol permits release of exclusive locks only at the end of transaction?
Two phase locking protocol
Well Done. Your Answer is Correct Keep it Up!
Graph based protocol
Strict two phase locking protocol
Rigorous Two phase locking protocol
Who developed Python Programming Language?
Who developed Python Programming Language?
Guido van Rossum
Well Done. Your Answer is Correct Keep it Up!
Rasmus Lerdorf
Wick van Rossum
Niene Stom
Which statement is true about PostgreSQL data types?
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?
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’.
To restore a PostgreSQL backup created with pg_dump, the following may be used:
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
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.
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:
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”?
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 command allows you to edit PostgreSQL queries in your favorite editor ?
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