4.10 SQL Basic Commands

Question 1

What is SQL?

Answer 1

SQL is a declarative language that is used for querying and updating tables in a relationship database

Question 2

How is the Select statement used?

Answer 2

Select *
From * Table
Where Condition

Question 3

How do you Specify a specific order in SQL?

Answer 3

Select *
From * 
Where Condition 
AND
Order By \_\_\_\_\_\_

Question 4

How do you extract data from several Tables?

Answer 4

Syntax: tablename.fieldname

Question 5

How do you Define a Database Table?

Answer 5

To define a Data-Base table
CREATE TABLE: \_\_\_\_\_\_\_
Emp.ID (Primary key)
Emp.Name
HireDate
Salary

Question 6

How do you Insert data Using SQL?

Answer 6

INSERT INTO tableName (column1, column2)

VALUES (values1, values2)

Question 7

How do you Update data Using SQL?

Answer 7

UPDATE tableName
SET column1 = value1 column 2 = value 2
WHERE condition

Question 8

How do you Delete Data Using SQL?

Answer 8

DELETE FROM tableName

WHERE Condition

Question 9

WHEN DO YOU USE AND??

Answer 9

ONLY USE AND WITH A FOREIGN KEY