Cassandra

All of the above

MongoDB

DynamoDB

Cassandra

Neo4j

CouchDB

Redis

Data encryption

Transaction isolation

Backup and recovery

Data validation constraints

To provide a consistent state of the database after a system crash or unexpected shutdown

To monitor and analyze database performance over time

To automatically rollback transactions that fail to commit

To log all user actions during a transaction

The failed statement is skipped and the remaining statements are executed

The failed statement is rolled back and the remaining statements are completed

The entire transaction is rolled back

The successful statements are committed and the failed statements are rolled back

A set of programming tools used to create custom data types in PostgreSQL

A set of properties that ensure database transactions are executed reliably and consistently 

A set of features that allow PostgreSQL to connect to other types of databases 

A set of security protocols that restrict access to PostgreSQL databases

A set of operations that do not need to be fully completed

A logical unit of work on the database

A series of incomplete actions on the database

A physical unit of work on the database

A user is referred to by authorization ID, typically their login name.

You may grant privileges to other users (authorization ID’s), including PUBLIC

Granting a privilege to PUBLIC makes it available to any authorization ID.

You may not grant privileges WITH GRANT OPTION, which lets the grantee also grant this privilege.

DROP

INSERT

SELECT

UPDATE

A set of relationships between tables in a database

A set of rights that allow users to perform certain actions on database objects

A set of SQL commands used to manage database objects

A set of files and directories on a file system