SQL

Question 1

What does SQL stand for?

Answer 1

“Structured Query Language”

Question 2

What can SQL do?

Answer 2

SQL can retrieve, insert, update, and delete records in a database via executing queries against a database. You can also create new databases, as well as tables, stores procedures, and views in the database.

Question 3

What are the five major commands in SQL?

Answer 3

SELECT, UPDATE, DELETE, INSERT, and WHERE.

Question 4

How would you select all entries in the table titled “Customers”?

Answer 4

SELECT * FROM Customers;

Question 5

What is another name for a “record”?

Answer 5

A “row”. Which is a horizontal entity in a table.

Question 6

What is a column?

Answer 6

A vertical entity in a table that contains all information associated with a specific field in a table.

Question 7

Are SQL keywords case sensitive?

Answer 7

No.

Question 8

Are semicolons required after SQL statements?

Answer 8

Some versions of SQL require it, however it’s standard practice to use a semicolon to separate your statements.

Question 9

What is the SELECT keyword used for?

Answer 9

Extracting data from a database.

Question 10

What is the UPDATE keyword used for?

Answer 10

Updating data in a database.

Question 11

What is the DELETE keyword used for?

Answer 11

Deleting data from a database.

Question 12

What is the INSERT INTO keyword used for?

Answer 12

Inserting new data into a dabase.

Question 13

What is the ALTER keyword used for?

Answer 13

Modifying existing tables/databses.

Question 14

What is the DROP keyword user for?

Answer 14

Deleting existing tables/databases.

Question 15

How would you select only the “City” row from the “Customers” database.

Answer 15

SELECT City FROM Customers;

Question 16

Fill in the blank: ______ City, CustomerName FROM Customers;

Answer 16

SELECT City, CustomerName FROM Customers;

Question 17

What keyword would you use to select ONLY distinct items from a database?

Answer 17

SELECT DISTINCT columnx, columny FROM table_name;

Question 18

What is the WHERE keyword used for?

Answer 18

It is used to extract records under a specific condition.

Question 19

Write a SQL statement that will select all from the Customers database where the country equals “Mexico”.

Answer 19

SELECT * FROM Customers
Where Country = ‘Mexico’;

Question 20

What operators can be used with the WHERE clause?

Answer 20

AND, and OR.

Question 21

Write a statement using AND, and OR in a WHERE clause.

Answer 21

SELECT column1
FROM table_name
WHERE condition1 AND condition2

Question 21

Write a statement using AND in a WHERE clause.

Answer 21

SELECT column1
FROM table_name
WHERE condition1 AND condition2