FURNACE TECHNOLOGY QUIZ

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

errornumber()

errorno()

errno()

errnumber()

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Microsoft SQL Server

IBM DB/2

None of these

PostgreSQL

MySQL

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following is not an SQL aggregate function?

AVG

MAX

CURRENT_DATE()

MIN

SUM

TRUE ANSWER : ?
YOUR ANSWER : ?

Which one of the following method is used to retrieve the number of rows affected by an INSERT, UPDATE, or DELETE query?

num_rows()

changed_rows()

new_rows()

affected_rows()

TRUE ANSWER : ?
YOUR ANSWER : ?

Your confirmation form submits your choice, via the _ method, to __

POST index.php

GET index.php

GET admin.php

POST admin.php

TRUE ANSWER : ?
YOUR ANSWER : ?

([w-]+) will match ___________

one or more word characters

one word characters

one or more word characters and/or hypens

one or more word characters and hypens

TRUE ANSWER : ?
YOUR ANSWER : ?

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

fetch_array() and fetch_column()

fetch_array() and fetch_row()

get_array() and get_row()

get_array() and get_column()

TRUE ANSWER : ?
YOUR ANSWER : ?

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

#include ‘filename’;

include ‘filename’;

@include ‘filename’;

#include ;

TRUE ANSWER : ?
YOUR ANSWER : ?

Which one of the following methods can be used to diagnose and display information about a MySQL connection error?

connect_errno()

mysqli_connect_errno()

connect_error()

mysqli_connect_error()

TRUE ANSWER : ?
YOUR ANSWER : ?

↑