Shortcut Navigation:

PHP Quiz (SQL, ID, XA0)

Which of the following DBMSs do not have a native PHP extension?

In PHP in order to access MySQL database you will use:

Transactions are used to treat sets of SQL statements atomically.

SQL is not case sensitive. SELECT is the same as select.

Which of the following is not an SQL aggregate function?

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

The ............. statement is used to delete a table.

What will happen at the end of the following sequence of SQL commands?  
BEGIN TRANSACTION
DELETE FROM MYTABLE WHERE ID=1
DELETE FROM OTHERTABLE
ROLLBACK TRANSACTION
 

Use the .............. to delete the data inside the table, and not the table itself?

Can joins be nested?

Tagged as: sql
Home | About | Create | Register | Privacy | Terms | Sitemap | [Facebook] [Twitter] [Google+]