Take Test

What does SQL stand for?

Structured Query Language

Sequential Query Language

Simple Query Language

Structured Question Language

Which command is used to retrieve data from a database?

SELECT

INSERT

UPDATE

DELETE

What is a primary key?

A unique identifier for a table record

A key used for encryption

A key to access the database

A key to create a new table

Which of the following is a NoSQL database?

MySQL

PostgreSQL

MongoDB

Oracle

What is a “foreign key”?

A field that links two tables together

A key used for authentication

A key that is used to store passwords

A key used to encrypt data

Which command is used to delete a table from a database?

DROP TABLE

DELETE TABLE

REMOVE TABLE

ERASE TABLE

What is normalization?

The process of organizing data to minimize redundancy

The process of backing up data

The process of encrypting data

The process of restoring data

Which SQL function is used to count the number of rows in a table?

SUM()

COUNT()

MAX()

AVG()

What is the purpose of an index in a database?

To speed up data retrieval

To store data securely

To backup data

To create tables

What is a stored procedure?

A precompiled set of SQL statements

A method to store data

A method to create tables

A method to backup data

Skill Assessment Test