PHP Databases Handling
What does the DESC keyword do in the following query?
SELECT * FROM MY_TABLE WHERE ID > 0 ORDER BY ID, NAME DESC

It causes the result set to include a description of the NAME field
It causes rows with the same ID to be sorted by NAME in ascending order
It causes the dataset returned by the query to be sorted in descending order
It causes rows with the same ID to be sorted by NAME in descending order

ANSWER DOWNLOAD EXAMIANS APP

PHP Databases Handling
Which one of the following statements is used to create a table?

CREATE TABLE table_name (column_name column_type);
CREATE TABLE table_name (column_type column_name);
CREATE table_name (column_type column_name);
CREATE table_name (column_name column_type);

ANSWER DOWNLOAD EXAMIANS APP