Computer Knowledge Quiz 12

1 / 15

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

SQL Server

MongoDB

Oracle

MySQL

2 / 15

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

Spatial

Sequential

Hierarchical

Relational

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

Second Normal Form (2NF)

First Normal Form (1NF)

4 / 15

What is the purpose of the SELECT statement in SQL?

Retrieve data from a database

Insert new records

Update records

Delete records

5 / 15

What does the acronym ACID stand for in database transactions?

Allowing, Changing, Including, Deleting

Association, Compatibility, Integration, Durability

Atomicity, Consistency, Isolation, Durability

Access, Control, Isolation, Distribution

6 / 15

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

Field with duplicate values

Field with large text content

Field with NULL values

Unique identifier for a record

7 / 15

What is the purpose of the JOIN operation in SQL?

Remove duplicate records

Combine rows from different tables

Split tables into smaller parts

Rearrange data in ascending order

8 / 15

What is a DBMS?

Data Block Management System

Dynamic Binary Management System

Digital Business Management System

Database Management System

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

10 / 15

Which statement is used to delete records in SQL?

REMOVE

ERASE

DROP

DELETE

11 / 15

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

A collection of tables

A set of attributes

A single row in a table

A single data value

12 / 15

What is normalization in the context of databases?

Adding more tables

Increasing redundancy

Increasing complexity

Reducing redundancy

13 / 15

What is SQL used for in a relational database?

Structured Question Language

Sequential Query Language

System Query Language

Structured Query Language

14 / 15

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

Link to an external database

Establish a relationship between tables

Unique identifier for a record

Primary identifier for a table

15 / 15

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

BOOLEAN

ALPHA

DECIMAL

INTEGER

Your score is

Computer Knowledge Quiz 12

Republication Authorized

Leave a Comment Cancel reply