Question 1

Which SQL command is used to remove a table from a database?

Accepted Answer

DROP

Answer

DELETE

Answer

REMOVE

Answer

CLEAR

Question 2

What type of database model organizes data into tables?

Accepted Answer

Relational

Answer

Graph

Answer

Key-Value

Answer

Document

Question 3

What is the purpose of a primary key in a database table?

Accepted Answer

To uniquely identify each record

Answer

To create relationships between tables

Answer

To encrypt data

Answer

To store backup copies

Question 4

Which normalization form ensures that a relation is free from transitive dependencies?

Accepted Answer

Third Normal Form (3NF)

Answer

First Normal Form (1NF)

Answer

Second Normal Form (2NF)

Answer

Boyce-Codd Normal Form (BCNF)

Question 5

What is the purpose of the SQL JOIN clause?

Accepted Answer

To combine rows from two or more tables

Answer

To insert data into a table

Answer

To delete a table

Answer

To create a new database

Question 6

What do you call a database that is distributed across multiple locations?

Accepted Answer

Distributed Database

Answer

Centralized Database

Answer

Cloud Database

Answer

NoSQL Database

Question 7

Which of the following is not a type of SQL JOIN?

Accepted Answer

OUTER JOIN

Answer

LEFT JOIN

Answer

RIGHT JOIN

Answer

INNER JOIN

Question 8

In a relational database, what does ACID stand for?

Accepted Answer

Atomicity, Consistency, Isolation, Durability

Answer

Access, Control, Information, Design

Answer

Array, Connection, Integrity, Distribution

Answer

Association, Consistency, Integrity, Durability

Question 9

Which SQL statement is used to modify existing records in a table?

Accepted Answer

UPDATE

Answer

ALTER

Answer

SELECT

Answer

INSERT

Question 10

What is the primary purpose of indexing in a database?

Accepted Answer

To speed up data retrieval

Answer

To increase the size of the database

Answer

To ensure data integrity

Answer

To store data securely

Related quizzes

Related quizzes