Back to Library

Database Management and SQL Fundamentals

Computer Science

A comprehensive guide covering SQL commands, database table creation, data manipulation, and query operations.

SQL Databases Programming

20 Questions Medium Ages 16+ May 7, 2026

Practice Test PDF Answer Key PDF

Choose a Study Format

Quiz

Test your knowledge with multiple-choice questions and instant feedback.

Flashcards

Flip through cards to review terms, definitions and key concepts.

True or False

Quickly decide if statements are true or false to reinforce understanding.

Match Game

Race against time to match questions with their correct answers.

Study Guide

Read through all topics and answers as a comprehensive study reference.

Listen Mode

Listen to questions and answers read aloud — great for audio learners on the go.

Embed This Study Set

Add this interactive study set to your website or blog — all 6 formats included.

<div data-quixly-id="2520"></div>
<script src="https://www.quixlylearn.com/assets/embed/widget.js"></script>

Learn more about embedding →

About this Study Set

This study set covers Computer Science through 20 practice questions. A comprehensive guide covering SQL commands, database table creation, data manipulation, and query operations. Every question includes the correct answer so you can learn as you go — pick any format above to get started.

Questions & Answers

Browse all 20 questions from the Database Management and SQL Fundamentals study set below. Each question shows the correct answer — select a study format above to practice interactively.

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

A REMOVE TABLE
B DELETE TABLE
C DROP TABLE
D CLEAR TABLE

2 Which keyword is used to add a new column to an existing table?

A INSERT
B ADD
C ALTER TABLE
D UPDATE

3 What is the correct syntax to retrieve all records from a table named 'Employee'?

A SELECT * FROM Employee;
B GET ALL FROM Employee;
C READ Employee;
D SELECT ALL Employee;

4 Which SQL function is used to calculate the average value of a numeric column?

A TOTAL()
B AVG()
C MEAN()
D SUM()

5 How do you define a column that must contain a unique value and acts as a record identifier?

A FOREIGN KEY
B INDEX
C UNIQUE KEY
D PRIMARY KEY

6 Which command is used to modify existing data within a table?

A MODIFY
B CHANGE
C UPDATE
D SET

7 What does the WHERE clause do in an SQL query?

A Sorts the results
B Filters records based on conditions
C Joins two tables
D Groups the results

8 Which SQL clause is used to arrange the result-set in ascending or descending order?

A SORT BY
B GROUP BY
C ORDER BY
D ARRANGE BY

9 What is the purpose of the COUNT() function?

A To sum all values
B To return the number of rows that match a criteria
C To count the characters in a string
D To find the highest value

10 Which keyword is used to specify a default value for a column during table creation?

A SET DEFAULT
B DEFAULT
C INITIAL
D ASSIGN

11 What is the primary function of the GROUP BY clause?

A To filter groups
B To aggregate data based on shared values
C To join tables
D To delete duplicate records

12 Which operator is used to search for values within a specified range?

A RANGE
B BETWEEN
C WITHIN
D LIMIT

13 Which SQL command is used to remove all records from a table while keeping the table structure?

A TRUNCATE
B DROP
C DELETE ALL
D CLEAR

14 What is a FOREIGN KEY used for?

A To identify a record uniquely
B To link two tables together
C To encrypt data
D To hide a column

15 Which keyword is used to return only distinct (different) values?

A UNIQUE
B DISTINCT
C DIFFERENT
D SINGLE

16 What is the correct SQL query to find the maximum value in a 'Salary' column?

A MAX(Salary)
B SELECT MAX(Salary) FROM table;
C GET MAX(Salary);
D TOP(Salary);

17 Which SQL command is used to add new data rows into a table?

A ADD INTO
B INSERT INTO
C INPUT
D NEW ROW

18 What is the purpose of the LIKE operator in a WHERE clause?

A To match a pattern
B To compare two numbers
C To check if a value is null
D To sort strings

19 Which of these is a valid data type for storing variable-length character strings?

A INT
B DECIMAL
C VARCHAR
D DATE

20 What does the MIN() function return?

A The smallest value in a column
B The total count
C The average value
D The first row

📱

Study on the go

Download Quixly and access all study formats on your phone — anywhere, anytime.