Evaluate the following SQL commands:

The command to create a table fails. Identify the reason for the SQL statement failure.

Examine thestructureof the members table:

You want to display details of all members who reside in states starting with the letter A followed by exactly one character.
Which SQL statement must you execute?

Which two are true about global temporary tables?

You want to write a query that prompts for two column names and the WHERE condition each time it is executed in a session but only prompts for the table name the first time it is executed.
The variables used in your query are never undefined in your session?
Which query can be used?

Examine the structure of the INVOICEtable.

Which two SQL statements would execute successfully?