SQL General Concepts 2

Question 1

What does the acronym SQL stand for?

Accepted Answer

Structured Query Language

Answer

SQL stands for Structured Query Language, used to manage relational databases.

Question 2

Which category does the SELECT statement belong to?

Accepted Answer

DML (Data Manipulation Language)

Answer

SELECT retrieves data and is part of DML, though some classify it as DQL.

Question 3

What is a relational database primarily organized into?

Accepted Answer

Tables made of rows and columns

Answer

Relational databases store data in tables consisting of rows and columns.

Question 4

Which clause is used to filter rows in a SELECT query?

Accepted Answer

WHERE

Answer

The WHERE clause filters rows based on a specified condition.

Question 5

What does a primary key guarantee for a table?

Accepted Answer

Each row is uniquely identifiable

Answer

A primary key uniquely identifies each row and cannot contain NULLs.

SQL Practice Test