PHP DATABASES HANDLING QUIZ

To identify entries marked for deletion, you check whether $_GET[‘page’] == ‘delete’ inside __________

.htaccess

index.ini

admin.php

index.php

TRUE ANSWER : ?
YOUR ANSWER : ?

The URLs in the administrative links won’t mean anything to admin.php unless you modify _________

.adminaccess

.htaccess

.urlaccess

.htmlaccess

TRUE ANSWER : ?
YOUR ANSWER : ?

You need to check whether ______ is set, to determine whether you’re editing an entry or creating a new one.

$_SET[‘admin’].

$_SET[‘url’].

$_GET[‘url’].

$_GET[‘admin’].

TRUE ANSWER : ?
YOUR ANSWER : ?

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

The contents of OTHERTABLE will be deleted, as will be all the contents of MYTABLE whose ID is 1

The contents of OTHERTABLE will be deleted

The database will remain unchanged

The contents of both OTHERTABLE and MYTABLE will be deleted

TRUE ANSWER : ?
YOUR ANSWER : ?

In which version of PHP was MySQL Native Driver(also known as mysqlnd) introduced?

PHP 5.0

PHP 5.1

PHP 5.2

PHP 5.3

TRUE ANSWER : ?
YOUR ANSWER : ?

Which one of the following databases has PHP supported almost since the beginning?

SQL

SQL+

Oracle Database

MySQL

TRUE ANSWER : ?
YOUR ANSWER : ?

Which version of MySQL introduced the prepared statements?

MySQL 4.0

MySQL 4.2

MySQL 4.3

MySQL 4.1

TRUE ANSWER : ?
YOUR ANSWER : ?

Transactions are used to treat sets of SQL statements atomically.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following methods is used to execute the statement after the parameters have been bound?

bind_result()

bind_param()

bound_param()

bound_result()

TRUE ANSWER : ?
YOUR ANSWER : ?

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

REMOVE TABLE

DROP TABLE

DELETE TABLE

DEL TABLE

TRUE ANSWER : ?
YOUR ANSWER : ?

↑