Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

PostgreSQL > Definitions > Flashcards

Definitions Flashcards

0
Q

What is the meaning of the abbreviation RDBMS?

A

Relational Database Management System

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
1
Q

What is the meaning of the abbreviation SQL?

A

Structured Query Language

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What is the meaning of the abbreviation PL/pgSQL?

A

Procedural Language PostgreSQL

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What does Atomicity refer to in a database system?

A

An atomic transaction: a series of database operations either all occur, or nothing occurs. In other words, atomicity means indivisibility and irreducibility.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What is the meaning of the abbreviation ACID?

A

Atomicity, Consistency, Isolation, Durability

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What is a table?

A

A table is a structured set of rows—also called records or tuples.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What is a transaction?

A

A transaction is a group of SQL
commands whose results will be made
visible to the rest of the system as a
unit when the transaction commits—or not at all, if the transaction aborts.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly

PostgreSQL (3 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2025 Bold Learning Solutions. Terms and Conditions