Which character is used to end a SQL statement?

Which of the following is NOT a basic SQL statement?

Which character is used to retrieve all columns of data?

What function counts the number of rows in a column?

What function returns the highest value in a column?

What of the following is an operator for nonequality?

Transactions, if available, wrap ___ operations.

Consider two tables A and B having only one column each and having these values:

A = [0, 1, 2, 3, 4, 5]

B = [5, 6, 7, 8, 9, 10]

The number of records in result of UNION operator on these tables will be?

Which one of the following is the correct way to delete a column from a table?

Suppose a table CUSTOMERS has the following records: 

+---+--------+----------+

| ID | CUSTOMER| INCOME |

+----+---------+---------+

| 1 | Roman | 150000 |

| 2 | Andrew | 200000 |

| 3 | Christi | 240000 |

| 4 | Ivan | 240000 |

| 5 | John | 240000 |

| 6 | Ann | 240000 |

+----+---------+---------+`

Which of the following statements will select the customers with income more than 200000? (check any that apply)

If AND and OR are used after WHERE clause ...