PHP can be run on Microsoft Windows IIS(Internet Information Server):
TrueCorrect
PHP in now known as "PHP: Hypertexts Preprocessor"
FalseCorrect
PHP is one of the most widely used and recognizable web technology use on the internet.
TrueCorrect
PHP is proprietary software.
TrueCorrect
PHP only runs in Apache web server.
FalseCorrect
PHP project originally started in 1995 by RasmusLerdorf. (1994)
FalseCorrect
PHP runs on various platforms operating system such as apache and IIS
FalseCorrect
PHP script tags ends with ?>;
FalseCorrect
PHP server scripts are surrounded by delimiters, which?
<?php...?>Correct
PHP variables need to be declared before adding a value to it?
FalseCorrect
PHP variables start with what symbol ?
A $ symbolCorrect
PHP's numerically indexed array begin with position __.
0Correct
represents a control that presents a menu of options.
selectCorrect
Returns header information
getAllResponseHeaders()Correct
Returns the highest value
MAX()Correct
returns the numbers of rows in a columns.
count()Correct
Returns the status-number of a request if "OK"
200Correct
Security is not an issue with JavaScript
FalseCorrect
Select * from employee where salary>10000 and dept_id=101; Which of the following fields are displayed as output?
All the field of employee relationCorrect
Select name, course_id from instructor, teaches where instructor_ID= teaches_ID; This Query can be replaced by which one of the following ?
Select name, course_id from instructor natural join teaches;Correct
Server command that calls itself
$_SERVER['PHP_SELF']Correct
Symbol use as identical
===Correct
Symbol use to append data or string
.Correct
Symbol used to combine 2 sting values to create one string.
.Correct
Syntax is a set of rules that must be followed to write properly structured code?
TrueCorrect
Tag is used to group block-elements to format them with CSS.
divCorrect
The ______ clause allows us to select only those rows in the result relation of the ____ clause that satisfy a specified predicate.
Where, fromCorrect
The ________ clause is used to list the attributes desired in the result of a query.
SelectCorrect
The "I" in MySQLi stands for
improvedCorrect
The "mysql_close()" function allows you to close a MySQL connection?
TrueCorrect
The "mysql_connect()" function opens a MySQL connection?
TrueCorrect
The "mysql_error()" function returns the error description for a MYSQL operation?
TrueCorrect
The "or die()" part of a MySQL command will execute if the connection fails?
TrueCorrect
The command to remove rows from a table 'CUSTOMER' is:
DELETE FROM CUSTOMER WHERE ...Correct
The concatenation operator in PHP?
.Correct
The date() function returns ___ representation of the current date and/or time.
StringCorrect
The default file extension for PHP files is ".php".
TrueCorrect
The following are examples of =, !=, === ______ Operators
EqualityCorrect
The following are examples of =, +=, *=, /=, .= _______ Operators
AssignmentCorrect
The following are examples of >, <=, >=, ==________ Operators
ComparisonCorrect
The following comparison condition would return TRUE or FALSE:(3 <> 6)
TrueCorrect
The following comparison condition would return TRUE or FALSE:(4 <> 7)
TrueCorrect
The following condition will return TRUE or FALSE ( (2 >= 2 && 8 < 1) || (11 == 33 || 5 > 3) )
TrueCorrect
The following condition will return TRUE or FALSE ( (4 >= 4 && 8 < 1) || (44 == 33 || 5 > 3) )
TrueCorrect
The following condition will return TRUE or FALSE: !(3 >= 3 || 8 < 1)
FalseCorrect
The following condition will return TRUE or FALSE: (7 >= 7 && 9 < 2)
FalseCorrect
The following condition will return TRUE or FALSE:(4 >= 4 || 8 < 1)
FalseCorrect
The following example $a -= $b; is the same as?
$a = $a – $b;Correct
The following example $x -= $y; is the same as?
$x = $x – $y;Correct
The HAVING clause does which of the following?
Acts like a WHERE clause but is used for groups rather than rows.Correct
The INSERT INTO statement is not used to add new records to a database table?
FalseCorrect
The keystone of AJAX
XMLHttpRequestCorrect
The logical operator ! stands for?
NOTCorrect
The logical operator && stands for?
ANDCorrect
The PHP If Else Statement can execute the code within the if and else segments at the same time?
FalseCorrect
The PHP If Statement will only execute the code within it's curly braces if the if condition is FALSE?
FalseCorrect
The PHP syntax is most similar to:
Perl and CCorrect
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;
WHERECorrect
The result of a SELECT statement can contain duplicate rows.
TrueCorrect
The SQL keyword BETWEEN is used:
for ranges.Correct
The SQL keyword(s) ________ is used with wildcards.
LIKE onlyCorrect
The SQL statement that queries or reads data from a table is ________ .
SELECTCorrect
The SQL WHERE clause:
limits the row data are returned.Correct
The wildcard in a WHERE clause is useful when?
An exact match is not possible in a SELECT statement.Correct
This are functions that operate on a set of rows to calculate and return a single value.
Aggregate functionsCorrect
This command sends active query to the database
mysql_query()Correct
This function allows you to close the current connection.
close();Correct
this function allows you to connect to mysql database
mysql_connect(),Correct
To remove duplicate rows from the result set of a SELECT use the following keyword:
DISTINCTCorrect
To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included
DISTINCTCorrect
To sort the results of a query use:
ORDER BY.Correct
To use MySQL on your computer, you'll need?
Some sort of client program to access the databasesCorrect
True or False - The following search statement will exclude any records that contain the term "poodle." (dogs OR canines) NOT cats.
FalseCorrect
True or False - The operator AND, when used to link two concept terms (e.g. children and violence) will retrieve only those records that contain both concept terms