Computer Knowledge Quiz 12

1 / 15

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

ALPHA

BOOLEAN

INTEGER

DECIMAL

2 / 15

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

MySQL

MongoDB

Oracle

SQL Server

3 / 15

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

Save changes made in a transaction

Rollback changes made in a transaction

Start a new transaction

Lock the database

4 / 15

What does the acronym ACID stand for in database transactions?

Access, Control, Isolation, Distribution

Association, Compatibility, Integration, Durability

Atomicity, Consistency, Isolation, Durability

Allowing, Changing, Including, Deleting

5 / 15

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

Establish a relationship between tables

Primary identifier for a table

Unique identifier for a record

Link to an external database

6 / 15

What is the purpose of the JOIN operation in SQL?

Rearrange data in ascending order

Combine rows from different tables

Split tables into smaller parts

Remove duplicate records

7 / 15

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

Relational

Hierarchical

Sequential

Spatial

8 / 15

What is a DBMS?

Data Block Management System

Database Management System

Dynamic Binary Management System

Digital Business Management System

9 / 15

Which statement is used to delete records in SQL?

DELETE

ERASE

DROP

REMOVE

10 / 15

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

Field with large text content

Unique identifier for a record

Field with NULL values

Field with duplicate values

11 / 15

What is normalization in the context of databases?

Adding more tables

Increasing complexity

Increasing redundancy

Reducing redundancy

12 / 15

What is the purpose of the SELECT statement in SQL?

Update records

Retrieve data from a database

Delete records

Insert new records

13 / 15

What is SQL used for in a relational database?

Sequential Query Language

Structured Question Language

Structured Query Language

System Query Language

14 / 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

15 / 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)

Boyce-Codd Normal Form (BCNF)

Third Normal Form (3NF)

Your score is