Crowdly

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

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

The failed statement is skipped and the remaining statements are executed

Which of the following best describes the ACID properties in PostgreSQL?

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

What is a transaction in PostgreSQL?

A physical unit of work on the database

A logical unit of work on the database

A series of incomplete actions on the database

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

Which of the following is NOT true about granting privileges in PostgreSQL?

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

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

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

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

What types of privileges are commonly NOT used in PostgreSQL?

SELECT

UPDATE

DROP

INSERT

What are Privileges in PostgreSQL?

A set of files and directories on a file system

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 relationships between tables in a database

What is the purpose of SQL roles?

To limit user access to data

To customize access based on the user's department or purpose

To manage database access and permissions

To track changes made to the database

To simplify the process of granting and revoking access

What is the purpose of transaction logs in PostgreSQL?

To limit user access to data

To customize access based on the user's department or purpose

To track changes made to the database

✅

To create SQL roles that can transfer privileges to other users

What is view materialization in PostgreSQL?

The process of creating a new view by combining data from multiple tables

The process of storing the result of a query physically and update the data periodically.

✅

The process of modifying the structure of a view without affecting the underlying tables

The process of restricting access to a view based on user permissions

Which of the following is an advantage of using views in PostgreSQL?

Increased complexity of the database schema

Reduced data independence

Improved security by limiting access to specific data

✅

Slower database performance