Which of the following query will return PERSON first_name from table PERSON with last_name field null?

Which statement removes all rows from the "orders" table without removing the table structure?

What is the default join type if omitted?

What KEYWORD is used to filter groups?

Which of these is NOT a valid data type for a character string?

What is the function that combines two strings and returns the combined string?

Insert into is an example of ________ code.

A ____ file is a text file with a .sql extension that contains sql commands.

The syntax for the union query is ____.

In oracle, the ____ table contains information about the columns within tables.

To add data from an existing table to a new table, use a select command in a(n) ____ command.