PHP DATABASES HANDLING QUIZ

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

$_GET[‘url’].

$_GET[‘admin’].

$_SET[‘url’].

$_SET[‘admin’].

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Which version of MySQL introduced the prepared statements?

MySQL 4.2

MySQL 4.0

MySQL 4.3

MySQL 4.1

TRUE ANSWER : ?
YOUR ANSWER : ?

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

It causes the dataset returned by the query to be sorted in descending order

It causes rows with the same ID to be sorted by NAME in descending order

It causes the result set to include a description of the NAME field

It causes rows with the same ID to be sorted by NAME in ascending order

TRUE ANSWER : ?
YOUR ANSWER : ?

Which one of the following lines need to be uncommented or added in the php.ini file so as to enable mysqli extension?

extension=mysqli.dl

extension=mysql.dll

extension=php_mysqli.dl

extension=php_mysqli.dll

TRUE ANSWER : ?
YOUR ANSWER : ?

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 __________

index.php

admin.php

function.inc.php

database

TRUE ANSWER : ?
YOUR ANSWER : ?

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

The contents of both OTHERTABLE and MYTABLE will be deleted

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

TRUE ANSWER : ?
YOUR ANSWER : ?

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

None of these

MySQL

Microsoft SQL Server

PostgreSQL

IBM DB/2

TRUE ANSWER : ?
YOUR ANSWER : ?

Which one of the following statements should be used to include a file?

#include ;

include ‘filename’;

@include ‘filename’;

#include ‘filename’;

TRUE ANSWER : ?
YOUR ANSWER : ?

Which one of the following statements instantiates the mysqli class?

$mysqli = new mysqli()

$mysqli->new.mysqli()

mysqli->new.mysqli()

mysqli = new mysqli()

TRUE ANSWER : ?
YOUR ANSWER : ?

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

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

Which version of MySQL introduced the prepared statements?

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

Which one of the following lines need to be uncommented or added in the php.ini file so as to enable mysqli extension?

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 __________

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

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

Which one of the following statements should be used to include a file?

Which one of the following statements instantiates the mysqli class?