When you are building administrative links you’ll need to accept two arguments, which of the following are they?
Select an option to see the answer and solution.
PHP · all questionsDatabases Handling
Databases Handling
practice.
Practice every MCQ with options. Use Show answers when you want the correct option and solution.
39
Questions
2/2
Page
Pick an option on a question to see the right answer and solution.
Once your application can generate administrative links, you need to load those links into _________
Select an option to see the answer and solution.
The URLs in the administrative links won’t mean anything to admin.php unless you modify _________
Select an option to see the answer and solution.
The (|/) tells the server to match ___________
Select an option to see the answer and solution.
([w-]+) will match ___________
Select an option to see the answer and solution.
You need to check whether ______ is set, to determine whether you’re editing an entry or creating a new one.
Select an option to see the answer and solution.
To identify entries marked for deletion, you check whether $_GET[‘page’] == ‘delete’ inside __________
Select an option to see the answer and solution.
Your confirmation form submits your choice, via the _______ method, to ________
Select an option to see the answer and solution.
When a user confirms that he wishes to delete an entry, that entry’s URL is passed to a function which removes the entry from the __________
Select an option to see the answer and solution.
Which of the following DBMSs do not have a native PHP extension?
Select an option to see the answer and solution.
In PHP in order to access MySQL database you will use:
Select an option to see the answer and solution.
Transactions are used to treat sets of SQL statements atomically.
Select an option to see the answer and solution.
SQL is not case sensitive. SELECT is the same as select.
Select an option to see the answer and solution.
Which of the following is not an SQL aggregate function?
Select an option to see the answer and solution.
What does the DESC keyword do in the following query?
SELECT *
FROM MY_TABLE
WHERE ID > 0
ORDER BY ID, NAME DESC"
Select an option to see the answer and solution.
The ............. statement is used to delete a table.
Select an option to see the answer and solution.
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
Select an option to see the answer and solution.
Use the .............. to delete the data inside the table, and not the table itself?
Select an option to see the answer and solution.
Can joins be nested?
Select an option to see the answer and solution.