SQL

Question 1

What does SQL stand for?

Answer 1

Structured Query Language

Question 2

True or False: SQL is a programming language used for managing relational databases.

Answer 2

True

Question 3

Fill in the blank: The command used to retrieve data from a database is called _____.

Answer 3

SELECT

Question 4

What is the basic syntax for a SELECT statement?

Answer 4

SELECT column1, column2 FROM table_name;

Question 5

Which SQL command is used to insert new records into a table?

Answer 5

INSERT INTO

Question 6

True or False: The DELETE command can be used to remove rows from a table.

Answer 6

True

Question 7

What is the purpose of the WHERE clause in SQL?

Answer 7

To filter records based on specified conditions.

Question 8

Multiple Choice: Which of the following is used to update existing records in a table? A) MODIFY B) UPDATE C) CHANGE

Answer 8

B) UPDATE

Question 9

What is the syntax for creating a new table in SQL?

Answer 9

CREATE TABLE table_name (column1 datatype, column2 datatype, …);

Question 10

Fill in the blank: To remove a table from a database, you use the _____ command.

Answer 10

DROP TABLE

Question 11

True or False: SQL is case-sensitive.

Answer 11

False

Question 12

What does the ORDER BY clause do?

Answer 12

It sorts the result set in either ascending or descending order.

Question 13

What is the primary key in a database table?

Answer 13

A unique identifier for each record in a table.

Question 14

Multiple Choice: Which SQL function is used to count the number of rows in a SELECT query? A) COUNT() B) SUM() C) TOTAL()

Answer 14

A) COUNT()

Question 15

What is the purpose of the JOIN clause in SQL?

Answer 15

To combine rows from two or more tables based on a related column.