Computer Knowledge Quiz 12

1 / 15

What is the purpose of the COMMIT statement in database transactions?

Rollback changes made in a transaction

Save changes made in a transaction

Start a new transaction

Lock the database

2 / 15

What is the purpose of the SELECT statement in SQL?

Insert new records

Delete records

Update records

Retrieve data from a database

3 / 15

Which of the following is not a data type in SQL?

DECIMAL

INTEGER

ALPHA

BOOLEAN

4 / 15

What is SQL used for in a relational database?

Sequential Query Language

System Query Language

Structured Question Language

Structured Query Language

5 / 15

What is a DBMS?

Dynamic Binary Management System

Database Management System

Data Block Management System

Digital Business Management System

6 / 15

Which of the following is an example of a NoSQL database?

MySQL

Oracle

MongoDB

SQL Server

7 / 15

In a relational database, what does the term "tuple" refer to?

A collection of tables

A single row in a table

A set of attributes

A single data value

8 / 15

Which of the following is not a type of database model?

Spatial

Relational

Hierarchical

Sequential

9 / 15

What is normalization in the context of databases?

Adding more tables

Increasing complexity

Increasing redundancy

Reducing redundancy

10 / 15

What is the role of a foreign key in a relational database?

Primary identifier for a table

Unique identifier for a record

Link to an external database

Establish a relationship between tables

11 / 15

What is the purpose of the JOIN operation in SQL?

Remove duplicate records

Rearrange data in ascending order

Combine rows from different tables

Split tables into smaller parts

12 / 15

Which of the following is a primary key in a relational database?

Field with large text content

Field with NULL values

Unique identifier for a record

Field with duplicate values

13 / 15

What does the acronym ACID stand for in database transactions?

Atomicity, Consistency, Isolation, Durability

Association, Compatibility, Integration, Durability

Allowing, Changing, Including, Deleting

Access, Control, Isolation, Distribution

14 / 15

Which normalization form ensures that non-prime attributes are fully functionally dependent on the primary key?

First Normal Form (1NF)

Second Normal Form (2NF)

Third Normal Form (3NF)

Boyce-Codd Normal Form (BCNF)

15 / 15

Which statement is used to delete records in SQL?

DELETE

REMOVE

ERASE

DROP

Your score is