Computer Knowledge Quiz 12

1 / 15

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

SQL Server

MySQL

MongoDB

Oracle

2 / 15

What is normalization in the context of databases?

Increasing complexity

Reducing redundancy

Adding more tables

Increasing redundancy

3 / 15

What is a DBMS?

Dynamic Binary Management System

Database Management System

Data Block Management System

Digital Business Management System

4 / 15

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

Unique identifier for a record

Field with large text content

Field with NULL values

Field with duplicate values

5 / 15

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

DECIMAL

BOOLEAN

INTEGER

ALPHA

6 / 15

What is SQL used for in a relational database?

Structured Question Language

Sequential Query Language

Structured Query Language

System Query Language

7 / 15

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

Rollback changes made in a transaction

Start a new transaction

Lock the database

Save changes made in a transaction

8 / 15

What does the acronym ACID stand for in database transactions?

Access, Control, Isolation, Distribution

Atomicity, Consistency, Isolation, Durability

Association, Compatibility, Integration, Durability

Allowing, Changing, Including, Deleting

9 / 15

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

Third Normal Form (3NF)

Boyce-Codd Normal Form (BCNF)

First Normal Form (1NF)

Second Normal Form (2NF)

10 / 15

What is the purpose of the SELECT statement in SQL?

Retrieve data from a database

Delete records

Insert new records

Update records

11 / 15

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

Relational

Sequential

Hierarchical

Spatial

12 / 15

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

Link to an external database

Primary identifier for a table

Establish a relationship between tables

Unique identifier for a record

13 / 15

Which statement is used to delete records in SQL?

DELETE

DROP

ERASE

REMOVE

14 / 15

What is the purpose of the JOIN operation in SQL?

Combine rows from different tables

Rearrange data in ascending order

Remove duplicate records

Split tables into smaller parts

15 / 15

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

A collection of tables

A single data value

A single row in a table

A set of attributes

Your score is