SQL & Relational Database Basics

Keys, SELECT, joins, and relational fundamentals. Ideal for students and interview prep.

Questions

Attempts

Passed

Failed

Likes

Views

QUESTION NO 01

SQL stands for?

Answer: Structured Query Language

SQL is Structured Query Language for relational databases.

Shahzad Mahota @shahzad-mahota

302 Quizzes

2930 Questions

00 Likes

QUESTION NO 02

A primary key must be?

Answer: Unique and not null

A primary key uniquely identifies each row and cannot be NULL.

Shahzad Mahota @shahzad-mahota

302 Quizzes

2930 Questions

00 Likes

QUESTION NO 03

Which SQL command retrieves data?

Answer: SELECT

SELECT queries rows from tables.

Shahzad Mahota @shahzad-mahota

302 Quizzes

2930 Questions

00 Likes

QUESTION NO 04

Normalization mainly reduces?

Answer: Data redundancy

Normalization organizes data to minimize duplication and anomalies.

Shahzad Mahota @shahzad-mahota

302 Quizzes

2930 Questions

00 Likes

QUESTION NO 05

A foreign key references a?

Answer: Primary (or unique) key in another table

Foreign keys enforce referential integrity between tables.

Shahzad Mahota @shahzad-mahota

302 Quizzes

2930 Questions

00 Likes

QUESTION NO 06

ACID in databases stands for?

Answer: Atomicity, Consistency, Isolation, Durability

ACID properties guarantee reliable transactions.

Shahzad Mahota @shahzad-mahota

302 Quizzes

2930 Questions

00 Likes

QUESTION NO 07

Which JOIN returns matching rows from both tables?

Answer: INNER JOIN

INNER JOIN keeps rows with matching join keys in both tables.

Shahzad Mahota @shahzad-mahota

302 Quizzes

2930 Questions

00 Likes

QUESTION NO 08

An index is used primarily to?

Answer: Speed up lookups

Indexes help the engine find rows faster (at a write/storage cost).

Shahzad Mahota @shahzad-mahota

302 Quizzes

2930 Questions

00 Likes

QUESTION NO 09

DELETE vs TRUNCATE: TRUNCATE typically?

Answer: Removes all rows and resets identity (faster, DDL-like)

TRUNCATE clears the table quickly; DELETE can remove specific rows with WHERE.

Shahzad Mahota @shahzad-mahota

302 Quizzes

2930 Questions

00 Likes

QUESTION NO 10

A transaction that commits means?

Answer: Changes are permanently saved

COMMIT makes the transaction's changes durable.

Shahzad Mahota @shahzad-mahota

302 Quizzes

2930 Questions

00 Likes

Published By

Shahzad Mahota

@shahzad-mahota

WAS THIS QUIZ HELPFUL?

Please help us improve by giving us your feedback.

YOUR SCORE CARD

00

Attempts

00

Correct

00

Incorrect

01 02 03 04 05 06 07 08 09 10

WAS THIS QUIZ HELPFUL?

YOUR SCORE CARD

00

Attempts

00

Correct

00

Incorrect

01 02 03 04 05 06 07 08 09 10

Quiz complete See your shareable result poster

View result

Quiz Categories

Explore

Content

Create

Discover

Account

More

SQL & Relational Database Basics

SQL stands for?

A primary key must be?

Which SQL command retrieves data?

Normalization mainly reduces?

A foreign key references a?

ACID in databases stands for?

Which JOIN returns matching rows from both tables?

An index is used primarily to?

DELETE vs TRUNCATE: TRUNCATE typically?

A transaction that commits means?

Published By

Shahzad Mahota

00

00

00

00

00

00

SQL & Relational Database Basics

SQL stands for?

Explanation

A primary key must be?

Explanation

Which SQL command retrieves data?

Explanation

Normalization mainly reduces?

Explanation

A foreign key references a?

Explanation

ACID in databases stands for?

Explanation

Which JOIN returns matching rows from both tables?

Explanation

An index is used primarily to?

Explanation

DELETE vs TRUNCATE: TRUNCATE typically?

Explanation

A transaction that commits means?

Explanation

Published By

Shahzad Mahota

00

00

00

00

00

00

Related Quizzes

No Records Found