A. mysqlconnect() function
B. mysql-connect() function
C. mysql_connect() function
D. sql_connect() function
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?
Where is metadata stored in MySQL?
________ is an open source DBMS product that runs on UNIX, Linux and Windows.