Structured query language (sql)

Question 1

What do Relational database management systems use?

Answer 1

Relational database management systems (RDBMS) support the use of structured query language (SQL) for control and database maintenance purposes.

Question 2

What does the statement CREATE do?

Question 3

What does the statement DROP do?

Answer 3

This can be used to delete tables

Question 4

What does the statement INSERT do?

Question 5

What does the statement UPDATE do?

Question 6

What does the statement DELETE do?

Question 7

What does the statement SELECT do?

Question 8

What does the statement INNER JOIN do?

Answer 8

An inner join between two tables will return the rows where there is a match between the two tables; for example, using the Customers and Sessions tables from above:

Question 9

What does the statement AND do?

Answer 9

Displays result if condition 1 AND condition 2 are TRUE

Question 10

What does the statement OR do?

Answer 10

Displays result if condition 1 OR condition 2 is TRUE