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

Choose a Study Format

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>

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.

Download on App Store Get it on Google Play Get it on Chrome Web Store