Computer Knowledge Quiz 12

1 / 15

What is a DBMS?

Digital Business Management System

Data Block Management System

Dynamic Binary Management System

Database Management System

2 / 15

What is the purpose of the SELECT statement in SQL?

Insert new records

Retrieve data from a database

Delete records

Update records

3 / 15

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

Hierarchical

Sequential

Spatial

Relational

4 / 15

What is SQL used for in a relational database?

System Query Language

Structured Question Language

Structured Query Language

Sequential Query Language

5 / 15

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

BOOLEAN

ALPHA

INTEGER

DECIMAL

6 / 15

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

Primary identifier for a table

Establish a relationship between tables

Unique identifier for a record

Link to an external database

7 / 15

What is normalization in the context of databases?

Increasing complexity

Reducing redundancy

Adding more tables

Increasing redundancy

8 / 15

Which statement is used to delete records in SQL?

REMOVE

ERASE

DELETE

DROP

9 / 15

What is the purpose of the JOIN operation in SQL?

Rearrange data in ascending order

Remove duplicate records

Combine rows from different tables

Split tables into smaller parts

10 / 15

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

SQL Server

Oracle

MongoDB

MySQL

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

12 / 15

What does the acronym ACID stand for in database transactions?

Atomicity, Consistency, Isolation, Durability

Allowing, Changing, Including, Deleting

Access, Control, Isolation, Distribution

Association, Compatibility, Integration, Durability

13 / 15

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

A collection of tables

A single data value

A set of attributes

A single row in a table

14 / 15

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

Lock the database

Start a new transaction

Rollback changes made in a transaction

Save changes made in a transaction

15 / 15

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

Field with duplicate values

Field with large text content

Unique identifier for a record

Field with NULL values

Your score is

Computer Knowledge Quiz 12

Republication Authorized

Leave a Comment Cancel reply