PHP Databases Handling

PHP Databases Handling
Can joins be nested?

False

True

ANSWER DOWNLOAD EXAMIANS APP

PHP Databases Handling
Which method returns the error code generated from the execution of the last MySQL function?

errorno()

errornumber()

errno()

errnumber()

errorno()

errornumber()

errno()

errnumber()

ANSWER DOWNLOAD EXAMIANS APP

PHP Databases Handling
SQL is not case sensitive. SELECT is the same as select.

True

False

ANSWER DOWNLOAD EXAMIANS APP

PHP Databases Handling
Which one of the following statements instantiates the mysqli class?

mysqli = new mysqli()

mysqli->new.mysqli()

$mysqli->new.mysqli()

$mysqli = new mysqli()

mysqli = new mysqli()

mysqli->new.mysqli()

$mysqli->new.mysqli()

$mysqli = new mysqli()

ANSWER DOWNLOAD EXAMIANS APP

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

$_SET[‘url’].

$_GET[‘url’].

$_GET[‘admin’].

$_SET[‘admin’].

$_SET[‘url’].

$_GET[‘url’].

$_GET[‘admin’].

$_SET[‘admin’].

ANSWER DOWNLOAD EXAMIANS APP

PHP Databases Handling
Which of the methods are used to manage result sets using both associative and indexed arrays?

fetch_array() and fetch_column()

get_array() and get_row()

fetch_array() and fetch_row()

get_array() and get_column()

fetch_array() and fetch_column()

get_array() and get_row()

fetch_array() and fetch_row()

get_array() and get_column()

ANSWER DOWNLOAD EXAMIANS APP

MORE MCQ ON PHP Databases Handling

↑