CSE :: PHP - CS
- In PHP in order to access MySQL database you will use:
- 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?
Whatsapp
Facebook
|
A.
It causes the dataset returned by the query to be sorted in descending order |
|
B.
It causes rows with the same ID to be sorted by NAME in ascending order |
|
C.
It causes rows with the same ID to be sorted by NAME in descending order |
|
D.
It causes rows to be sorted by NAME first and then by ID |
|
E.
It causes the result set to include a description of the NAME field |
|
A.
The contents of OTHERTABLE will be deleted |
|
B.
The contents of both OTHERTABLE and MYTABLE will be deleted |
|
C.
The contents of OTHERTABLE will be deleted, as will be all the contents of MYTABLE whose ID is 1 |
|
D.
The database will remain unchanged to all users except the one that executes these queries. |
|
E.
The database will remain unchanged |