Web Application Development 1

IT6314 Web Application Development 1
(Final Q1, Q2 & Final Exam)

Question 1

Correct

Mark 1.00 out of 1.00

Flag question

Question text

In a LIKE clause, you can could ask for any value ending in "qpt" by writing

Select one:

a.

LIKE ^.*ton$

b.

LIKE %qpt

c.

LIKE *ton

d.

LIKE ton$

Question 2

Correct

Mark 1.00 out of 1.00

Flag question

Question text

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

Select one:

a.

num_rows()

b.

new_rows()

c.

affected_rows()

d.

changed_rows()

Question 3

Correct

Mark 1.00 out of 1.00

Flag question

Question text

This is Employee table.

Select * from employee where employee_id>1009;

Which of the following employee_id will be displayed?

 

Select one:

a.

1001

b.

1009, 1018

c.

1009, 1001, 1018

d.

1018

Question 4

Correct

Mark 1.00 out of 1.00

Flag question

Question text

The ______ clause allows us to select only those rows in the result relation of the ____ clause that satisfy a specified predicate.

Select one:

a.

Select, from

b.

From, select

c.

Where, from

d.

From, where

Question 5

Correct

Mark 1.00 out of 1.00

Flag question

Question text

The INSERT INTO statement is not used to add new records to a database table?

Select one:

True

False 

Question 6

Correct

Mark 1.00 out of 1.00

Flag question

Question text

The "mysql_connect()" function opens a MySQL connection?

Select one:

True 

False

Question 7

Correct

Mark 1.00 out of 1.00

Flag question

Question text

MySQL runs on which operating systems?

Select one:

a.

Any operating system at all

b.

Linux and Mac OS-X only

c.

Unix, Linux, Windows and others

d.

Unix and Linux only

Question 8

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Which one of the following methods is responsible for sending the query to the database?

Select one:

a.

sendquery()

b.

query()

c.

query_send()

d.

send_query()

Question 9

Correct

Mark 1.00 out of 1.00

Flag question

Question text

The "mysql_close()" function allows you to close a MySQL connection?

Select one:

True 

False

Question 10

Correct

Mark 1.00 out of 1.00

Flag question

Question text

This command sends active query to the database

Select one:

a.

mysql_query()

b.

my_query();

c.

mysql_queries();

d.

query();

Question 1

Correct

Mark 1.00 out of 1.00

Flag question

Question text

The ______ clause allows us to select only those rows in the result relation of the ____ clause that satisfy a specified predicate.

Select one:

a.

From, select

b.

Where, from

c.

Select, from

d.

From, where

Question 2

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Which one of the following statements is used to create a table?

Select one:

a.

CREATE TABLE table_name (column_namecolumn_type);

b.

CREATE table_name (column_namecolumn_type);

c.

CREATE table_name (column_typecolumn_name);

d.

CREATE TABLE table_name (column_typecolumn_name);

Question 3

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Which SQL statement is used to insert a new data in a database?

Select one:

a.

INSERT INTO

b.

ADD

c.

UPDATE

d.

INSERT NEW

Question 4

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Which one of the following methods is responsible for sending the query to the database?

Select one:

a.

sendquery()

b.

send_query()

c.

query_send()

d.

query()

Question 5

Correct

Mark 1.00 out of 1.00

Flag question

Question text

A NULL value is treated as a blank or 0.

Select one:

True

False 

Question 6

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Assuming the table and fields below exists, what is wrong with the following mysql query example: mysql_query("INSERT INTO contacts (firstName, lastName, phoneNumber) VALUES ('Robert', 'Smith')");

Select one:

a.

Nothing, everything is fine

b.

There are more values than fields

c.

There are more fields than values

Question 7

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Which function used to get the current time in mysql?

Select one:

a.

NOW()

b.

Time()

c.

getTime()

Question 8

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Select * from employee where salary>10000 and dept_id=101;
Which of the following fields are displayed as output?

Select one:

a.

All the field of employee relation

b.

Employee

c.

Salary

d.

Salary, dept_id

Question 9

Incorrect

Mark 0.00 out of 1.00

Flag question

Question text

The result of a SELECT statement can contain duplicate rows.

Select one:

True 

False Correct Answer

Question 10

Correct

Mark 1.00 out of 1.00

Flag question

Question text

The "mysql_connect()" function opens a MySQL connection?

Select one:

True 

False

Question 1

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Insert into employee _____ (1002,Jeiven,2000);
In the given query which of the keyword has to be inserted ?

Select one:

a.

Relation

b.

Values

c.

Field

d.

Table

Question 2

Correct

Mark 1.00 out of 1.00

Flag question

Question text

This command sends active query to the database

Select one:

a.

mysql_query()

b.

my_query();

c.

query();

d.

mysql_queries();

Question 3

Correct

Mark 1.00 out of 1.00

Flag question

Question text

The "mysql_close()" function allows you to close a MySQL connection?

Select one:

True 

False

Question 4

Correct

Mark 1.00 out of 1.00

Flag question

Question text

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

Select one:

a.

new_rows()

b.

num_rows()

c.

affected_rows()

d.

changed_rows()

Question 5

Correct

Mark 1.00 out of 1.00

Flag question

Question text

The query given below will not give an error. Which one of the following has to be replaced to get the desired output?
Select ID, name, dept name, sal * 1.1
where instructor;

Select one:

a.

WHERE

b.

ID

c.

sal *1.1

d.

Instructor

Question 6

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Which of these query will display the result, assume table name is employee ?

Select one:

a.

Select name from employee

b.

Select name

c.

Select employee from name

d.

elect employee

Question 7

Correct

Mark 1.00 out of 1.00

Flag question

Question text

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

Select one:

a.

SQL+

b.

Oracle Database

c.

SQL

d.

MYSQL

Question 8

Correct

Mark 1.00 out of 1.00

Flag question

Question text

The "I" in MySQLi stands for

Select one:

a.

improve

b.

improvement

c.

increase

d.

improved

Question 9

Correct

Mark 1.00 out of 1.00

Flag question

Question text

The "mysql_select_db()" function allows you to select a particular database ?

Select one:

True 

False

Question 10

Correct

Mark 1.00 out of 1.00

Flag question

Question text

In a LIKE clause, you can could ask for any value ending in "qpt" by writing

Select one:

a.

LIKE *ton

b.

LIKE ton$

c.

LIKE ^.*ton$

d.

LIKE %qpt

Question 1

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Returns header information

Select one:

a.

getAllResponsesHeaders()

b.

getsAllResponseHeaders()

c.

getAllResponseHeaders()

d.

getAllResponseHeader()

Question 2

Correct

Mark 1.00 out of 1.00

Flag question

Question text

It's a function that formats a timestamp to a more readable date and time.

Select one:

a.

time()

b.

dateTime()

c.

dates()

d.

date()

Question 3

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Which of the following statement is not true about MySQL DROP command?

Select one:

a.

It can be used to remove a database

b.

It can be used to remove a table with all data

c.

It can be used to delete an index

d.

It can be used to delete only data but not structure of a table

Question 4

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Find the SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = 'VA';

Select one:

a.

SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA');

b.

'V';

c.

SELECT NAME IN CUSTOMER WHERE STATE

d.

SELECT NAME IN CUSTOMER WHERE STATE

e.

SELECT NAME IN CUSTOMER WHERE STATE IN ('VA');

f.

'VA';

Question 5

Correct

Mark 1.00 out of 1.00

Flag question

Question text

AJAX is a programming language

Select one:

True

False 

Question 6

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Which of the following are the five built-in functions provided by SQL?

Select one:

a.

SUM, AVG, MIN, MAX, NAME

b.

SUM, AVG, MULT, DIV, MIN

c.

SUM, AVG, MIN, MAX, MULT

d.

COUNT, SUM, AVG, MAX, MIN

Question 7

Correct

Mark 1.00 out of 1.00

Flag question

Question text

To sort the results of a query use:

Select one:

a.

GROUP BY.

b.

None of the above is correct.

c.

ORDER BY.

d.

SORT BY.

Question 8

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Which of the following is the correct order of keywords for SQL SELECT statements?

Select one:

a.

WHERE, FROM,SELECT

b.

FROM, WHERE, SELECT

c.

SELECT, FROM, WHERE

d.

SELECT,WHERE,FROM

Question 9

Correct

Mark 1.00 out of 1.00

Flag question

Question text

JavaScript Code can be called by using

Select one:

a.

Preprocessor

b.

Trigger

c.

Function/Method

d.

Event

Question 10

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Which of the following is the original purpose of SQL?

Select one:

a.

To specify the syntax and semantics of SQL data definition language

b.

All of the above.

c.

To specify the syntax and semantics of SQL manipulation language

d.

To define the data structures

Question 1

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Which of the following is the correct order of keywords for SQL SELECT statements?

Select one:

a.

FROM, WHERE, SELECT

b.

SELECT, FROM, WHERE

c.

SELECT,WHERE,FROM

d.

WHERE, FROM,SELECT

Question 2

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Its a client-side script that communicates to and from a server/database without the need for a postback or a complete page refresh

Select one:

a.

PHP

b.

JavaScript

c.

HTML

d.

AJAX

Question 3

Correct

Mark 1.00 out of 1.00

Flag question

Question text

It's a time manipulation function that returns the current date.

Select one:

a.

date()

b.

CurDate()

c.

datesnow()

d.

currentdate()

Question 4

Correct

Mark 1.00 out of 1.00

Flag question

Question text

MySQL was invented in the year of

Select one:

a.

1994

b.

1996

c.

1999

d.

1997

Question 5

Correct

Mark 1.00 out of 1.00

Flag question

Question text

When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s):

Select one:

a.

Both IN and NOT IN.

b.

IN only.

c.

NOT IN only.

d.

LIKE only

Question 6

Correct

Mark 1.00 out of 1.00

Flag question

Question text

You can add a row using SQL in a database with which of the following?

Select one:

a.

MAKE

b.

ADD

c.

CREATE

d.

INSERT

Question 7

Correct

Mark 1.00 out of 1.00

Flag question

Question text

It refers to a client-side script that communicates to and from a server/database without the need for a postback or a complete page refresh

Select one:

a.

jQuery

b.

Ajax

c.

PHP

d.

HTML

Question 8

Correct

Mark 1.00 out of 1.00

Flag question

Question text

One of the parameters to represent the day of the month

Select one:

a.

days

b.

day

c.

D

d.

d

Question 9

Correct

Mark 1.00 out of 1.00

Flag question

Question text

The keystone of AJAX

Select one:

a.

XMLHttpsRequest

b.

XMLHttpRequests

c.

XMLsHttpRequest

d.

XMLHttpRequest

Question 10

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Function trims all spaces from the right of a value

Select one:

a.

Trims()

b.

RTRIM()

c.

RightTrim()

d.

Trim()

Question 1

Correct

Mark 1.00 out of 1.00

Flag question

Question text

The "or die()" part of a MySQL command will execute if the connection fails?

Select one:

True 

False

Question 2

Correct

Mark 1.00 out of 1.00

Flag question

Question text

To use MySQL on your computer, you'll need?

Select one:

a.

A Browser

b.

Some sort of client program to access the databases

c.

FTP and Telnet

d.

Perl, PHP or Java

Question 3

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Insert into employee _____ (1002,Jeiven,2000);
In the given query which of the keyword has to be inserted ?

Select one:

a.

Field

b.

Table

c.

Relation

d.

Values

Question 4

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Which one of the following statements is used to create a table?

Select one:

a.

CREATE TABLE table_name (column_namecolumn_type);

b.

CREATE table_name (column_typecolumn_name);

c.

CREATE TABLE table_name (column_typecolumn_name);

d.

CREATE table_name (column_namecolumn_type);

Question 5

Correct

Mark 1.00 out of 1.00

Flag question

Question text

MySQL is

Select one:

a.

A technique for writing reliable programs

b.

A Relational Database Management System

c.

A Programming language

Question 6

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Assuming the table and fields below exists, what is wrong with the following mysql query example:
mysql_query("INSERT INTO contacts (firstName, lastName, phoneNumber)
VALUES ('Robert', 'Smith', '123-983-2929')");

Select one:

a.

There are more values than fields

b.

There are more fields than values

c.

Nothing, everything is fine

Question 7

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Which of the following statements contains an error?

Select one:

a.

Select * from emp where empid = 10003;

b.

Select empid where empid = 1009 and lastname = ‘JOHANN;

c.

Select empid from emp where empid = 10006;

d.

Select empid from emp;

Question 8

Correct

Mark 1.00 out of 1.00

Flag question

Question text

The "I" in MySQLi stands for

Select one:

a.

improvement

b.

improve

c.

improved

d.

increase

Question 9

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Which SQL statement is used to insert a new data in a database?

Select one:

a.

ADD

b.

INSERT NEW

c.

INSERT INTO

d.

UPDATE

Question 10

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Which of the following displays the unique values of the column.
Select ________ dept_name
from instructor;

Select one:

a.

From

b.

Distinct

c.

Name

d.

All

Question 1

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Which of the following statement is not true about MySQL DROP command?

Select one:

a.

It can be used to delete an index

b.

It can be used to remove a database

c.

It can be used to remove a table with all data

d.

It can be used to delete only data but not structure of a table

Question 2

Correct

Mark 1.00 out of 1.00

Flag question

Question text

What does the following command do?
SELECT pub_name,LENGTH(pub_name)
FROM publisher
WHERE LENGTH(pub_name)>=20;

Select one:

a.

None of the above

b.

Returns the pub_name and length of pub_name from publisher table if the length of the pub_name column (in the structure of the table) is more than or equal to 20.

c.

Returns the pub_name and length of pub_name from publisher table where the length of the publisher's name is more than or equal to 20.

d.

Returns the length of pub_name from publisher table where the length of the publisher's name is more than or equal to 20.

Question 3

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Its a client-side script that communicates to and from a server/database without the need for a postback or a complete page refresh

Select one:

a.

JavaScript

b.

PHP

c.

AJAX

d.

HTML

Question 4

Correct

Mark 1.00 out of 1.00

Flag question

Question text

An object-oriented computer programming language commonly used to create interactive effects within web browsers

Select one:

a.

PHP

b.

HTML

c.

AJAX

d.

JavaScript

Question 5

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Which of the following datatype's display format is YYYY-MM-DD HH:MM:SS

Select one:

a.

DATE
None of the above

b.

DATETIME

c.

TIMESTAMP

Question 6

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Find the SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = 'VA';

Select one:

a.

SELECT NAME IN CUSTOMER WHERE STATE

b.

SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA');

c.

'VA';

d.

SELECT NAME IN CUSTOMER WHERE STATE IN ('VA');

e.

'V';

f.

SELECT NAME IN CUSTOMER WHERE STATE

Question 7

Correct

Mark 1.00 out of 1.00

Flag question

Question text

To sort the results of a query use:

Select one:

a.

None of the above is correct.

b.

GROUP BY.

c.

SORT BY.

d.

ORDER BY.

Question 8

Correct

Mark 1.00 out of 1.00

Flag question

Question text

MYSQL can be used to:

Select one:

a.

All of the above can be done by MYSQL.

b.

query database data only.

c.

create database structures only.

d.

modify database data only

Question 9

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Its joining values together (by appending them to each other) to form a single long value.

Select one:

a.

concatenating

b.

joining

c.

adding

d.

appending

Question 10

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Which of the following are the five built-in functions provided by SQL?

Select one:

a.

SUM, AVG, MIN, MAX, NAME

b.

SUM, AVG, MIN, MAX, MULT

c.

COUNT, SUM, AVG, MAX, MIN

d.

SUM, AVG, MULT, DIV, MIN

Question 1

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Is the SQL statement correct or not.
SELECT vend_name, prod_name, prod_price, vendors.vend_id, products.vend_id
FROM vendors INNER JOINS products
ON vendors.vend_id = products.vend_id;

Select one:

a.

Yes

b.

No

Question 2

Incorrect

Mark 0.00 out of 1.00

Flag question

Question text

The command to eliminate a table from a database is:

Select one:

a.

REMOVE TABLE CUSTOMER;

b.

UPDATE TABLE CUSTOMER;

c.

DROP TABLE CUSTOMER; Correct Answer

d.

DELETE TABLE CUSTOMER;

Question 3

Correct

Mark 1.00 out of 1.00

Flag question

Question text

What will be the output of the following PHP code? If say date is 16/04/2017.

Select one:

a.

16

b.

2017

c.

April

d.

30

Question 4

Correct

Mark 1.00 out of 1.00

Flag question

Question text

It's a function that formats a timestamp to a more readable date and time.

Select one:

a.

time()

b.

dates()

c.

dateTime()

d.

date()

Question 5

Correct

Mark 1.00 out of 1.00

Flag question

Question text

The wildcard in a WHERE clause is useful when?

Select one:

a.

An exact match is necessary in a SELECT statement.

b.

An exact match is not possible in a CREATE statement.

c.

An exact match is necessary in a CREATE statement.

d.

An exact match is not possible in a SELECT statement.

Question 6

Correct

Mark 1.00 out of 1.00

Flag question

Question text

What does the following MySQL command do?
SELECT *
FROM author
WHERE auth_name LIKE 'W%';

Select one:

a.

None of the above

b.

Return those rows from the table author in which the name of the author ends with the character 'W'

c.

Return those rows from the table author in which the name of the author starts with the character 'W'

d.

Return those rows from the table author in which the name of the author contains the character 'W' somewhere in the middle of the author name

Question 7

Correct

Mark 1.00 out of 1.00

Flag question

Question text

This are functions that operate on a set of rows to calculate and return a single value.

Select one:

a.

ABS()

b.

COUNT()

c.

Aggregate functions

d.

AVG()

Question 8

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Which one of the following sorts rows in SQL?

Select one:

a.

ORDER BY

b.

SORT BY

c.

GROUP BY

d.

ALIGN BY

Question 9

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Ajax Stands for

Select one:

a.

Asynchronous JavaScripts And XML.

b.

Asynchronous JavaScript And XML.

c.

Asynchronous JavaScript And XMLs.

d.

Asynchronous JavaScript And XHML.

Question 10

Correct

Mark 1.00 out of 1.00

Flag question

Question text

MySQL COUNT() function returns

Select one:

a.

a count of number of string values of a given expression

b.

None of the above

c.

a count of number of values of a given expression

d.

a count of number of non-NULL values of a given expression

Question 1

Correct

Mark 1.00 out of 1.00

Flag question

Question text

It is a file function mode that is used to open a file for reading, writing or appending.

Select one:

a.

fopen()

b.

feof()

c.

fgetc()

d.

fgets()

Question 2

Correct

Mark 1.00 out of 1.00

Flag question

Question text

How to use the include function?

Select one:

a.

include("int.php")

b.

function include("int.php")

c.

include function("int.php")

d.

inc("int.php")

Question 3

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Sorts by value in reverse order; keeps the same key

Select one:

a.

rsort()

b.

asort()

c.

arsort()

d.

sort()

Question 4

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Is language construct that use to output one or more string.

Select one:

a.

echo

b.

;

c.

?>

d.

&

Question 5

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Determine the exact output of the code:

for($val=1; $val<=100; $val+=2) {

  $tem[] = $val*=2;

  }

echo min($tem);

Select one:

a.

2

b.

8

c.

4

d.

1

Feedback

Your answer is correct.

Question 6

Correct

Mark 1.00 out of 1.00

Flag question

Question text

It is an attribute that must be used in the form tag in specifying an input file type

Select one:

a.

enctype

b.

post

c.

method

d.

action

Question 7

Correct

Mark 1.00 out of 1.00

Flag question

Question text

This is an example of: $AngusMaximus += 100;

Select one:

a.

Logical Operator

b.

Assignment Operator

c.

Comparison Operator

d.

Arithmetic Operator

Question 8

Correct

Mark 1.00 out of 1.00

Flag question

Question text

This function searches for the first occurence of a string inside another string.

Select one:

a.

strcmp()

b.

strlen()

c.

strcasecmp()

d.

strchr()

Question 9

Correct

Mark 1.00 out of 1.00

Flag question

Question text

It is used to jump to other section of the program to support labels.

Select one:

a.

goto....label:

b.

continue

c.

else

d.

break

Question 10

Correct

Mark 1.00 out of 1.00

Flag question

Question text

FOREACH, EXPLODE and MAIL are examples of crazy functions.

Select one:

a.

None of these

b.

False

c.

Sometimes

d.

True

Question 11

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Sort Sorts by value; assign new numbers as the keys.

Select one:

a.

sort()

b.

asort()
rsort()

c.

arsort()

Question 12

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Key Categories: more libraries and thousands of functions

Select one:

a.

Practicality

b.

Power

c.

Price

d.

Possibility

Question 13

Correct

Mark 1.00 out of 1.00

Flag question

Question text

It is a function that saves the uploaded file permanently into the server.

Select one:

a.

save_uploaded_file()

b.

move_uploaded_file()

c.

store_uploaded_file()

d.

make_uploaded_file()

Question 14

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Allow for multiple items of the same type to be aggregated under a single representative entity.

Select one:

a.

Global Variable

b.

Compound Datatypes

c.

Scalar Datatypes

d.

Local Variable

Question 15

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Which one of these variables has an illegal name?

Select one:

a.

$my_Vars

b.

$my_Var

c.

$my-Var

d.

$myVar

Question 16

Correct

Mark 1.00 out of 1.00

Flag question

Question text

It is the default server name used to connect in MySQL server.

Select one:

a.

Apache

b.

server

c.

Localhost

d.

Root

Question 17

Correct

Mark 1.00 out of 1.00

Flag question

Question text

How will you able to retrive data in your table?

Select one:

a.

mysql_query("SELECT FROM table");
mysqli_query("SELECT FROM table");

b.

mysql_query("SELECT * FROM table");
mysqli_query("SELECT * FROM table");

c.

mysql_retrieve ("SELECT FROM table");
mysqli_retrieve ("SELECT FROM table");

d.

mysql_retrieve ("SELECT * FROM table");
mysqli_retrieve ("SELECT * FROM table");

Question 18

Correct

Mark 1.00 out of 1.00

Flag question

Question text

It is a function that removes an existing file from the server.

Select one:

a.

remove()

b.

drop()

c.

delete()

d.

unlink()

Question 19

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Array is special variable that can handle more than one value.

Select one:

a.

False

b.

True

c.

None of these

d.

Sometimes

Question 20

Incorrect

Mark 0.00 out of 1.00

Flag question

Question text

Format character of Date function that display the day of the month in 2 digits with leading zeros such as 01 to 31

Select one:

a.

d Correct Answer

b.

L

c.

D

d.

j

Question 21

Correct

Mark 1.00 out of 1.00

Flag question

Question text

This function is used to close the current session.

Select one:

a.

session_close()

b.

close_session()

c.

session_destroy()

d.

destroy_session()

Question 22

Correct

Mark 1.00 out of 1.00

Flag question

Question text

It is a function that ends the connection to the database.

Select one:

a.

mysql_query / mysqli_query

b.

mysql_connect / mysqli_connect

c.

mysql_close / mysqli_close

d.

mysql_error / mysqli_error

Question 23

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Generate a warning.

Select one:

a.

define()

b.

include()

c.

require()

d.

iInclude_once()

Question 24

Correct

Mark 1.00 out of 1.00

Flag question

Question text

What is the statement terminator for PHP?

Select one:

a.

print

b.

echo

c.

?>

d.

;

Question 25

Correct

Mark 1.00 out of 1.00

Flag question

Question text

A group of PHP statements that performs a specific task.

Select one:

a.

User Defined Functions

b.

Undefined Functions

c.

Predefined Functions

d.

Functions

Question 26

Correct

Mark 1.00 out of 1.00

Flag question

Question text

It is used to access submitted form values

Select one:

a.

'name'

b.

mysql_connect

c.

$_POST

d.

select

e.

Name

Question 27

Correct

Mark 1.00 out of 1.00

Flag question

Question text

This function is used for checking or searching for patterns in a given text

Select one:

a.

regex()

b.

preg_match()
check()

c.

regexp()

Question 28

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Join array elements to form a string.

Select one:

a.

implode()

b.

explode()

c.

iInclude_once()

d.

unset()

Question 29

Correct

Mark 1.00 out of 1.00

Flag question

Question text

These are keywords used with mysql_query/ mysqli_queryto update records in a table.

Select one:

a.

ALTER, ADD, COLUMN

b.

ALTER, CHANGE, COLUMN

c.

UPDATE, SET, WHERE

d.

INSERT, INTO, VALUES

Question 30

Correct

Mark 1.00 out of 1.00

Flag question

Question text

It is the symbol used to mark the end of the string in regular expressions

Select one:

a.

$

b.

.

c.

|

d.

^

Question 31

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Functions that are provide by the user of the program.

Select one:

a.

Predefined Functionsd
Undefined Functions

b.

Functions

c.

User Defined Functions

Question 32

Correct

Mark 1.00 out of 1.00

Flag question

Question text

A constant can only be assigned a scalar value, like a string or a number.

Select one:

a.

iInclude_once()

b.

define()

c.

require()

d.

include()

Question 33

Correct

Mark 1.00 out of 1.00

Flag question

Question text

What is the correct method to use in Javascript Sorting Arrays?

Select one:

a.

rsort()

b.

arsort()

c.

asort()

d.

sort()

Question 34

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Is a function also use for outputting strings.

Select one:

a.

Print

b.

;

c.

?>

d.

&

Question 35

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Date() is a function that can also access time.

Select one:

a.

False

b.

Sometimes

c.

None of these

d.

True

Question 36

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Functions that are built-in into PHP to perform some standard operations.

Select one:

a.

Undefined Functions

b.

User Defined Functions

c.

Functions

d.

Predefined Functions

Question 37

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Variables in PHP must begin with what symbol?

Select one:

a.

&

b.

$

c.

!

d.

?

Question 38

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Key Categories: free of charge.

Select one:

a.

Price

b.

Practicality

c.

Power

d.

Possibility

Question 39

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Accepted identifier for a variable in PHP except:

Select one:

a.

$Puihaha

b.

$Pui_haha

c.

& Puihaha

d.

$_Puihaha

Question 40

Correct

Mark 1.00 out of 1.00

Flag question

Question text

It is an array containing information such as headers, paths and script locations wherein it is created by the web server itself

Select one:

a.

$_SESSION

b.

$_SERVER

c.

$_REQUEST

d.

PHP_SELF

Question 41

Correct

Mark 1.00 out of 1.00

Flag question

Question text

One that declared outside a function and is available to all.

Select one:

a.

Compound Datatypes

b.

Local Variable

c.

Global Variable

d.

Scalar Datatypes

Question 42

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Software Requirements: Web Server except for :

Select one:

a.

NGiNXTM

b.

IIIS7

c.

Apache

d.

Google Web Server

Question 43

Incorrect

Mark 0.00 out of 1.00

Flag question

Question text

It reports the error message from the last failed database connection attempt.

Select one:

a.

mysql_query / mysqli_query

b.

mysql_close / mysqli_close

c.

mysql_error / mysqli_error Correct answer

d.

mysql_connect / mysqli_connect

Question 44

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Split a string by string.

Select one:

a.

unset()

b.

iInclude_once()

c.

explode()

d.

implode(

Question 45

Correct

Mark 1.00 out of 1.00

Flag question

Question text

This is what happens when you set your form method to get

Select one:

a.

Empty String

b.

$_GET

c.

Query String

d.

get()

Question 46

Correct

Mark 1.00 out of 1.00

Flag question

Question text

It specifies the parameter to be processed by the $_FILES

Select one:

a.

uploaded

b.

index

c.

file

d.

values

Question 47

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Which of the following that can be use read cookies in PHP?

Select one:

a.

cookie()

b.

$_COOKIES

c.

$_COOKIE

d.

setcookie()

Question 48

Correct

Mark 1.00 out of 1.00

Flag question

Question text

This is an example of: $Ice <= $Crown;

Select one:

a.

Assignment Operator

b.

Logical Operator

c.

Arithmetic Operator

d.

Comparison Operator

Question 49

Correct

Mark 1.00 out of 1.00

Flag question

Question text

This is an example of: $Pui % $haha;

Select one:

a.

Assignment Operator

b.

Comparison Operator

c.

Arithmetic Operator

d.

Logical Operator

Question 50

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Generate fatal error.

Select one:

a.

iInclude_once()

b.

include()

c.

require()

d.

define()

Question 1

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Determine the exact output of the code $str = "The quick brown fox jumps over the the lazy dog"; echo strpos($str, 'fox');

Select one:

a.

15

b.

17

c.

14

d.

16

Question 2

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Sorts by value; keeps the same key.

Select one:

a.

arsort()

b.

sort()

c.

rsort()

d.

asort()

Question 3

Correct

Mark 1.00 out of 1.00

Flag question

Question text

It is the symbol used to mark the start of the string in regular expressions

Select one:

a.

^

b.

$

c.

|

d.

.

Question 4

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Which of the following that can be use to access session variables in PHP?

Select one:

a.

$_SESSIONS

b.

$_SESSION

c.

session_start()

d.

start_session()

Question 5

Correct

Mark 1.00 out of 1.00

Flag question

Question text

It is a command used to add individual records in a table.

Select one:

a.

APPEND, INTO

b.

UPDATE, SET

c.

ADD, INTO

d.

INSERT, INTO

Question 6

Correct

Mark 1.00 out of 1.00

Flag question

Question text

In PHP, the only way to output text is with echo.

Select one:

True

False 

Question 7

Correct

Mark 1.00 out of 1.00

Flag question

Question text

It opens a connection to a MySQL database server

Select one:

a.

mysql_error / mysqli_error

b.

mysql_close / mysqli_close

c.

mysql_connect / mysqli_connect

d.

mysql_query / mysqli_query

Question 8

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Key Categories: offered more than 25 database products.

Select one:

a.

Power

b.

Practicality

c.

Possibility

d.

Price

Question 9

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Declared inside a function and is only available within the function in which it is declared.

Select one:

a.

Scalar Datatypes

b.

Global Variable

c.

Compound Datatypes

d.

require

Question 10

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Key Categories: a loosely type language.

Select one:

a.

Practicality

b.

Price

c.

Possibility

d.

Power

Question 11

Correct

Mark 1.00 out of 1.00

Flag question

Question text

It is placed within the code of a loop to cause the program to stop the loop statement.

Select one:

a.

break

b.

continue

c.

goto....label:

d.

else

Feedback

Your answer is correct.

Question 12

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Managing of cookies can be done using this function

Select one:

a.

setcookie()

b.

cookie()

c.

$_COOKIE

d.

$COOKIE[]

Question 13

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Determine the exact output of the code:

for($val=1; $val<=100; $val+=2) {

  $tem[] = $val*=2;

  }

echo max($tem);

Select one:

a.

188

b.

44

c.

250

d.

92

Feedback

Your answer is correct.

Question 14

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Format character of Date function that display a full textual representation of the day of the week such us Sunday to Saturday

Select one:

a.

L

b.

d

c.

D

d.

j

Question 15

Correct

Mark 1.00 out of 1.00

Flag question

Question text

This function starts a new session.

Select one:

a.

session_begin()

b.

begin_session()

c.

start_session()

d.

session_start()

Question 16

Correct

Mark 1.00 out of 1.00

Flag question

Question text

It specifies the name of the field in the form to be processed by the $_FILES

Select one:

a.

index

b.

uploaded

c.

values

d.

file

Question 17

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Determine the exact output of the code:
$num = 3.14;
echo floor($num);

Select one:

a.

3

b.

3.75

c.

3.5

d.

4

Question 18

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Capable of containing a single item of information.

Select one:

a.

Compound Datatypes

b.

Scalar Datatypes

c.

Global Variable

d.

Local Variable

Question 19

Correct

Mark 1.00 out of 1.00

Flag question

Question text

It is a field that contains a unique identifier for each record in a primary table

Select one:

a.

Index

b.

unique

c.

Primary key

d.

Foreign key

Question 20

Correct

Mark 1.00 out of 1.00

Flag question

Question text

In PHP you can use both single quotes ( ' ' ) and double quotes ( " " ) for strings:

Select one:

True 

False

Question 21

Correct

Mark 1.00 out of 1.00

Flag question

Question text

PHP can be run on Microsoft Windows IIS(Internet Information Server):

Select one:

True 

False

Question 22

Correct

Mark 1.00 out of 1.00

Flag question

Question text

The default user of your phpmyadmin

Select one:

a.

superadmin

b.

admin

c.

user

d.

root

Question 23

Correct

Mark 1.00 out of 1.00

Flag question

Question text

The Co -Developers of PHP are __________ and _________ .

Select one:

a.

ZeevSuraski&AnditGutmans

b.

ZeevZuraski&AndiGutman

c.

Zachary Leiv& Andrew Gharfield

d.

Zachary Levi & Andrew Garfieldd

Question 24

Correct

Mark 1.00 out of 1.00

Flag question

Question text

It proceeds the statement causes execution of the current loop iteration to end and commence at the beginning of the next loop.

Select one:

a.

break

b.

goto....label:

c.

continue

d.

else

Question 25

Correct

Mark 1.00 out of 1.00

Flag question

Question text

strlen("seven"); what is the output?

Select one:

a.

8

b.

6

c.

5

d.

7

Question 26

Correct

Mark 1.00 out of 1.00

Flag question

Question text

It is a function that retrieves the content of one cell from a MySQL result set.

Select one:

a.

mysql_num_rows()
mysqli_num_rows()

b.

mysql_result()
mysqli_result()

c.

mysql_affected_rows()
mysqli_affected_rows()

d.

mysql_fetch_row()
mysqli_fetch_row()

Question 27

Correct

Mark 1.00 out of 1.00

Flag question

Question text

It is a SQL keyword that creates an autoincrementing field.

Select one:

a.

AUTO

b.

AUTO_INCREMENT

c.

AUTOINCREMENT

d.

INCREMENT

Question 28

Correct

Mark 1.00 out of 1.00

Flag question

Question text

It is a function that retrieves the number of rows from a query result set.

Select one:

a.

mysql_affected_rows()
mysqli_affected_rows()

b.

mysql_fetch_row()
mysqli_fetch_row()

c.

mysql_result() mysqli_result()

d.

mysql_num_rows()
mysqli_num_rows()

Question 29

Correct

Mark 1.00 out of 1.00

Flag question

Question text

And the Founder/Developer of PHP is ____________.

Select one:

a.

RasmusLerderf

b.

Erasmus Lerdorf

c.

Erasmus Lerdurf

d.

RasmusLerdorf

Question 30

Correct

Mark 1.00 out of 1.00

Flag question

Question text

This function removes the white spaces and other predefined characters from both sides of a string

Select one:

a.

ltrim()

b.

trim()

c.

rtrim()

d.

strcmp()

Question 31

Correct

Mark 1.00 out of 1.00

Flag question

Question text

In what year does PHP was developed?

Select one:

a.

1997

b.

1996

c.

1998

d.

1994

Question 32

Correct

Mark 1.00 out of 1.00

Flag question

Question text

PHP is based on C rather than ______.

Select one:

a.

JAVA

b.

PERL

c.

COBOL

d.

PEARL

Question 33

Correct

Mark 1.00 out of 1.00

Flag question

Question text

This is an example of: $AngusMaximus += 100;

Select one:

a.

Assignment Operator

b.

Comparison Operator

c.

Logical Operator

d.

Arithmetic Operator

Question 34

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Format character of Date function that display the day of the month in 2 digits with leading zeros such as 01 to 31

Select one:

a.

j

b.

L

c.

D

d.

d

Question 35

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Sorts by value in reverse order; keeps the same key

Select one:

a.

arsort()

b.

sort()

c.

rsort()

d.

asort()

Question 36

Correct

Mark 1.00 out of 1.00

Flag question

Question text

This function is used for checking or searching for patterns in a given text

Select one:

a.

regex()

b.

regexp()

c.

preg_match()
check()

Question 37

Correct

Mark 1.00 out of 1.00

Flag question