SQL General Concepts 2

Question 1

What does the acronym SQL stand for?

Accepted Answer

Structured Query Language

Answer

Sequential Query Logic

Answer

Standard Question Layout

Answer

System Quality Level

Question 2

Which category does the SELECT statement belong to?

Accepted Answer

DML (Data Manipulation Language)

Answer

DDL (Data Definition Language)

Answer

DCL (Data Control Language)

Answer

TCL (Transaction Control Language)

Question 3

What is a relational database primarily organized into?

Accepted Answer

Tables made of rows and columns

Answer

Nested folders

Answer

Key-value pairs only

Answer

Graph nodes

Question 4

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

Accepted Answer

WHERE

Answer

FROM

Answer

ORDER BY

Answer

GROUP BY

Question 5

What does a primary key guarantee for a table?

Accepted Answer

Each row is uniquely identifiable

Answer

Faster inserts only

Answer

Encrypted storage

Answer

Automatic backups

Question 6

Which SQL command is used to remove all rows but keep the table structure most efficiently?

Accepted Answer

TRUNCATE

Answer

DELETE

Answer

DROP

Answer

REMOVE

Question 7

What is NULL in SQL?

Accepted Answer

The absence of a value

Answer

The number zero

Answer

An empty string

Answer

A boolean false