Chapter1 Flashcards

1
Q

What does DBMS stand for?

A

Database Management System

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

True or False: A DBMS is used to manage databases.

A

True

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

Fill in the blank: A DBMS provides a systematic way to __________ data.

A

create, retrieve, update, and delete

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

What is the primary purpose of a DBMS?

A

To allow users to efficiently manage and manipulate data.

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

Name one advantage of using a DBMS.

A

Data integrity

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

Which of the following is NOT a type of DBMS? (a) Hierarchical (b) Network (c) Linear (d) Relational

A

c) Linear

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

What type of DBMS uses a table-based format?

A

Relational DBMS

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

True or False: A NoSQL database is a type of DBMS.

A

True

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

What does SQL stand for?

A

Structured Query Language

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

In a relational DBMS, what is a primary key?

A

A unique identifier for a record in a table.

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

What is data normalization?

A

The process of organizing data to reduce redundancy.

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

Fill in the blank: The __________ model organizes data into a tree-like structure.

A

Hierarchical

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

What is the main function of a database schema?

A

To define the structure of a database.

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

Which SQL command is used to retrieve data from a database?

A

SELECT

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

True or False: A database can have multiple tables.

A

True

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

What does ACID stand for in the context of database transactions?

A

Atomicity, Consistency, Isolation, Durability

17
Q

What is a foreign key?

A

A field in one table that uniquely identifies a row of another table.

18
Q

Which type of database is designed to handle large volumes of unstructured data?

A

NoSQL database

19
Q

Fill in the blank: Data __________ is the practice of ensuring data is accurate and consistent.

A

validation

20
Q

What is a database index?

A

A data structure that improves the speed of data retrieval.

21
Q

True or False: A view in a database is a virtual table.

22
Q

What is the purpose of database backup?

A

To protect data from loss or corruption.

23
Q

Which of the following is a popular relational database management system? (a) MongoDB (b) MySQL (c) Cassandra (d) Redis

24
Q

What is the role of a database administrator (DBA)?

A

To manage and maintain database systems.

25
Q

Fill in the blank: __________ is the process of copying data from one location to another for backup or recovery.

A

Data replication

26
Q

What is a stored procedure?

A

A set of SQL statements that can be stored and executed in the database.