SQL Tutorials | 02. Syntax

Question 1

Most of the actions you need to perform on a database are done with what?

Answer 1

SQL statements

Question 2

What do SQL statements consists of?

Answer 2

Keywords that are easy to understand

Question 3

T/F | SQL keywords are case sensitive

Answer 3

FALSE

SQL keywords are NOT case sensitive: select is the same as SELECT

Question 4

T/F | Some database systems require a semicolon at the end of each SQL statement.

Answer 4

TRUE

Question 5

What is a semicolon used for in SQL statements?

Answer 5

Semicolon is the standard way to separate each SQL statement in database systems that allow more than one SQL statement to be executed in the same call to the server.

Question 6

What are 11 important SQL Commands?

Answer 6

1. SELECT - extracts data from a database
2. UPDATE - updates data in a database
3. DELETE - deletes data from a database
4. INSERT INTO - inserts new data into a database
5. CREATE DATABASE - creates a new database
6. ALTER DATABASE - modifies a database
7. CREATE TABLE - creates a new table
8. ALTER TABLE - modifies a table
9. DROP TABLE - deletes a table
10. CREATE INDEX - creates an index (search key)
11. DROP INDEX - deletes an index

Question 7

What does the SQL Command SELECT do?

Answer 7

SELECT - extracts data from a database

Question 8

What does the SQL Command UPDATE do?

Answer 8

UPDATE - updates data in a database

Question 9

What does the SQL Command DELETE do?

Answer 9

DELETE - deletes data from a database

Question 10

What does the SQL Command INSERT INTO do?

Answer 10

INSERT INTO - inserts new data into a database

Question 11

What does the SQL Command CREATE DATABASE do?

Answer 11

CREATE DATABASE - creates a new database

Question 12

What does the SQL Command ALTER DATABASE do?

Answer 12

ALTER DATABASE - modifies a database

Question 13

What does the SQL Command CREATE TABLE do?

Answer 13

CREATE TABLE - creates a new table

Question 14

What does the SQL Command ALTER TABLE do?

Answer 14

ALTER TABLE - modifies a table

Question 15

What does the SQL Command DROP TABLE do?

Answer 15

DROP TABLE - deletes a table

Question 16

What does the SQL Command CREATE INDEX do?

Answer 16

CREATE INDEX - creates an index (search key)

Question 17

What does the SQL Command DROP INDEX do?

Answer 17

DROP INDEX - deletes an index