Web Application Development

Which SQL statement is used to delete data from a database?

• DELETE

The PHP If Else Statement can execute the code within the if and else segments at the same time?

• False

PHP's numerically indexed array begin with position __.

It's a text function that returns convert string to lowercase

• Lower()

What will happen in this function call?

• Call by value

XMLHttpRequest object function that cancel request.

• Abort()

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

• query()

MySQL COUNT() function returns

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

Can hold an unlimited number of characters, and the text renders in a fixed-width font.

• Textarea

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

• Both IN and NOT IN.

Which of the following can add a row to a table?

• Insert

Other term use for Option buttons?

• Radio buttons

What will be the output of the following PHP code ? <?php $x; for($x=-3;$x<-5;++$x) { print++$x; } ?>

• no output

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

• True

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

• INSERT INTO

What will be the output of the following PHP code ? <?php $colors=array("red","green","blue","yellow"); foreach($colors as $value) { echo "$value<br>"; }

• red green blue yellow

One of the main points of interaction between a user and a web site or application. They allow users to send data to the web site.

• HTML forms

The following condition will return TRUE or FALSE: (7 >= 7 && 9 < 2)

• False

What will be the output of the following PHP code ? <?php for($i++;$i==1;$i=2) print"In for loop "; print"After loopn"; ?>

• In for loopAfter for loop

The result of a SELECT statement can contain duplicate rows.

• True

PHP variables need to be declared before adding a value to it?

• False

For maximum compatibility, you should use the shorthand form to create PHP scripts?

• False

Option buttons are also called Selection button

• False

Area that can be specified by the cols and rows attributes, or even better; through CSS' height and width properties

• textarea

The following condition will return TRUE or FALSE: !(3 >= 3 || 8 < 1)

• False

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

• MYSQL

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')");

• Nothing, everything is fine

The following condition will return TRUE or FALSE:(4 >= 4 || 8 < 1)

• False

What is the output of the following code snippet? $str = 'asdfghyo off on off'; $replace_pairs = array('a' => 'q', 's' => 'w', 'd' => 'e', 'f' => 'r', 'y' => 'z', 'o' => 'i', 'off' => 'on', 'on' => 'off'); echo strtr($str, $replace_pairs);

• Qwerghzi on off on

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;

• No

Which of the following is the original purpose of SQL?

• All of the above.

PHP is one of the most widely used and recognizable web technology use on the internet.

• True

Identify if the statement if True or False. Write True if statement is true otherwise False php.org is the official php resource.

• False

What will be the output of the following PHP code ? <?php for($i==2;++$i==$i;++$i) print"In for loop "; print"After loopn"; ?>

• In for loop In for loop In for loop In for loop......infinitely

What will be the output of the following PHP code ? <?php for($x=0;$x<=10;$x++) { echo"The number is: $x<br>"; } ?>

• The number is: 0 The number is: 1 The number is: 2 The number is: 3 The number is: 4 The number is: 5 The number is: 6 The number is: 7 The number is: 8 The number is: 9 The number is: 10

Function that is used to check whether a variable is set or not.

• isset()

It's a function that returns the lowest value in a column.

• Min()

What will be the output of the following PHP code ? <?php for($x=1;$x<10;++$x) { print"*t"; } ?>

• *********

Which operator will check if two variables are the same?

• ==

All variables in PHP start with a $(dollar) sign?

• True

In which positions PHP's indexed array begin?

PHP server scripts are surrounded by delimiters, which?

• <?php...?>

When a variable is declared, it can only be used 1 time in your PHP source file?

• False

The wildcard in a WHERE clause is useful when?

• An exact match is not possible in a SELECT statement.

Converts text to uppercase

• Upper()

The following comparison condition would return TRUE or FALSE:(4 <> 7)

• True

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

• All the field of employee relation

A variable declared within a function.

• local

Working locally you an access php script by using http://localhosts/filename.php

• False

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

• Some sort of client program to access the databases

A line of php code must end with a ?

• Semicolon ( ; )

Element represents a control that presents a menu of options.

• HTML select

Which of the following employee_id will be displayed?

• 1018

What will the following script output?

• 78

The following condition will return TRUE or FALSE:!(4 >= 4 || 8 < 1)

• False

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

• False

Using the _POST is allowed us to collect data from the htm file and display to the php script

• _POST

Returns the highest value

• MAX()

To remove duplicate rows from the result set of a SELECT use the following keyword:

• DISTINCT

Which of the following is the incorrect way to declare a PHP variable?

• $a_Number = 9

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

• True

PHP is proprietary software.

• True

The "mysql_error()" function returns the error description for a MYSQL operation?

• True

Function that select database.

• mysql_select_db();

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

• Distinct

Multiple Choice. Select the best answer How do you start the standard form PHP scripting block?

• <?php … ?>

Which function used to get the current time in mysql?

• NOW()

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

• Aggregate functions

What will be the output of the following PHP code ? <?php for(1;$i==1;$i=2) print"In for loop "; print"After loopn"; ?>

• After for loop

If the variable $x = 11; , what will $x equal if it is incremented, that is, if I write $x++; what value will $x contain after it has been incremented?

• 12

Using XAMPP server you can use SQL Server database.

• False

_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;

What is the output of the following? echo strcmp('first', 'second'), ", "; echo strcmp('44', '054'), ", "; echo strcmp('0x80', 'a'), ", "; echo strcmp('a', 'A');

• -1, 1, -1, 1

The PHP If Statement will only execute the code within it's curly braces if the if condition is FALSE?

• False

In an SQL SELECT statement querying a single table, the asterisk (*) means that:

• all columns of the table are to be returned.

Which one of the following is the right way of defining a function in PHP?

• functionfumctionName(parameters) { function body }

What is the output of the following code? $a=1; ++$a; $a*=$a; echo $a- -;

• 4

With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"?

• SELECT * FROM Persons WHERE FirstName = 'Peter'

The keystone of AJAX

• XMLHttpRequest

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

• True

Which is identified as a special variable, which can store multiple values in one single variable?

• Array

Symbol used to combine 2 sting values to create one string.

• .

PHP 3 was released in 1998.

• True

Which one of the following denotes the default mysql date format?

• YYYY-MM-DD

Which statement will evaluate and include a file into the location where it is called.

• include statement

It refers to styles for your documents, including the design, layout and variations in display for different devices and screen sizes.

• CSS

The following are examples of >, <=, >=, ==________ Operators

• Comparison

Consider the following code snippet : var grand_Total=eval("10*10+5");

• 105 as an integer value

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

• False

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

• SELECT, FROM, WHERE

Original developer of JavaScript?

• Brendan Eich

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

• AJAX

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

• True

Is allowed us to collect data from the htm file and display to the php script.

• _POST

A subquery in an SQL SELECT statement

• has a distinct form that cannot be duplicated by a join.

To sort the results of a query use:

• ORDER BY.

The following example $x -= $y; is the same as?

• $x = $x – $y;

PHP in now known as "PHP: Hypertexts Preprocessor"

• False

All variables in PHP start with which symbol?

• $

Function is used to convert a human readable string to a Unix time.

• strtotime()

The following comparison condition would return TRUE or FALSE:(3 <> 6)

• True

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

• INSERT

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

• concatenate

The PHP syntax is most similar to:

• Perl and C

The following condition will return TRUE or FALSE ( (2 >= 2 && 8 < 1) || (11 == 33 || 5 > 3) )

• True

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;

• WHERE

How many single line commenting types are there?

• 2

With SQL, how do you select a column named "FirstName" from a table named "Persons"?

• SELECT FirstName FROM Persons

What will be the output of the following PHP code ? <?php for($x=-1;$x<10;--$x) { print$x; } ?>

• infinite loop

<?php for($x=0;$x<=10;++$x) { print++$x; } ?>

• 123456789101112

The SQL statement that queries or reads data from a table is ________ .

• SELECT

What is the correct way to end a PHP statement?

• ;

Object is used to exchange data with a server behind the scenes.

• XMLHttpRequest

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

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

What is the output of the following? echo substr("abcdef", -2), ', '; echo substr("abcdef", 4), ', '; echo substr("abcdef", -3, -1), ', '; echo substr("abcdef", 4, -2), ', '; echo substr("abcdef", 2, -1)

• Ef, ef, de, , cde

Ajax Stands for

• Asynchronous JavaScript And XML.

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

• True

This command sends active query to the database

• mysql_query()

The logical operator ! stands for?

• NOT

Look at the following code and determine what will be displayed in the browser: <?php echo "Hello World 1"; // echo "Hello World 2"; ?>

• Hello World 1

Which one of the following denotes the difference between SELECT and USE command?

• SELECT checks which database is currently selected, USE selects a database

It uses spec cols and rows attributes, or even better; through CSS' height and width properties.

• textarea

The HAVING clause does which of the following?

• Acts like a WHERE clause but is used for groups rather than rows.

The SQL keyword(s) ________ is used with wildcards.

• LIKE only

this function allows you to connect to mysql database

• mysql_connect(),

It's a function returns the Unix timestamp for a date.

• mktime()

Assume you would like to sort an array in ascending order by value while preserving key associations. Which of the following PHP sorting functions would you use?

• asort()

The following example $a -= $b; is the same as?

• $a = $a – $b;

Array values are keyed by ______ values (called indexed arrays) or using ______ values (called associative arrays). Of course, these key methods can be combined as well.

• Integer, String

PHP script tags ends with ?>;

• False

Which one of these variables has an illegal name?

• $my-VarV

The following are examples of =, !=, === ______ Operators

• Equality

represents a control that presents a menu of options.

• select

True or False - The operator OR, when used to link two or concept terms will retrieve fewer records because both terms need not be present in each article.

• False

Which one of the following function is useful for producing a timestamp based on a given date and time.

• mktime()

MySQL runs on which operating systems?

• Unix, Linux, Windows and others

The logical operator || stands for?

• AND

What data type will PHP automatically convert the following variable to: $aVariable = "Robert";

• string (a text variable)

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

• Where, from

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

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

Symbol use to append data or string

• .

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

• INSERT INTO

What functions count elements in an array?

• count

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

• CREATE TABLE table_name (column_namecolumn_type);

A NULL value is treated as a blank or 0.

• False

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

• COUNT, SUM, AVG, MAX, MIN

One of the parameters to represent the day of the month

• d

The logical operator && stands for?

• AND

To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included

• DISTINCT

The following condition will return TRUE or FALSE: (4 >= 4 && 8 < 1)

• False

True or False. JavaScript can be inserted into any web page regardless of the file extension.

• True

Facebook, wordpress uses php as script language.

• True

When using the POST method, variables are displayed in the URL:

• False

The concatenation operator in PHP?

• .

If I wanted to concatenate a word to a string variable I would use which symbol?

• .

True or False - Using the operator AND to combine concept terms is a good way to increase the number of records retrieved in a search.

• False

Tag is used to group block-elements to format them with CSS.

• div

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

• CurDate()

Version 4 of php supports global variables $Get etc. (v4.1)

• False

Which is the incorrect way to start a single line PHP comment?

• /* .. */

A way on how to print / display text on the screen.

• echo

What does a semicolon signify at the end of a instruction or statement?

• the end of a PHP statement or instruction

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

• True

Which of the following statements contains an error?

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

Returns the status-number of a request if "OK"

• 200

Whitespace is not ignored in PHP?

• False

What will be the output of the following PHP code ? < ?php $i = 0; for ($i) { print$i; } ? >

• error

Multiple Choice. Select the best answer How do you write "Hello World" in PHP

• echo "Hello World";

What is the function of the ucfirst and lcfirst functions?

• To make the string's first character uppercase or lowercase, respectively

Which one of the following sorts rows in SQL?

• ORDER BY

The SQL keyword BETWEEN is used:

• for ranges.

All text to the right of a single line comment is not ignored?

• False

The following condition will return TRUE or FALSE:(7 >= 7 && 9 < 2)

• False

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

• affected_rows()

Returns header information

• getAllResponseHeaders()

The date() function returns ___ representation of the current date and/or time.

• String

The following are examples of =, +=, *=, /=, .= _______ Operators

• Assignment

True or False - The following search statement will exclude any records that contain the term "poodle." (dogs OR canines) NOT cats.

• False

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

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

Original Name of JavaScript

• LiveScript

What does PHP stand for?

• PHP: Hypertext Preprocessor

The "I" in MySQLi stands for

• improved

This function allows you to close the current connection.

• close();

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

• LIKE %qpt

PHP variables start with what symbol ?

• A $ symbol

If a source file contains PHP code, what extension should be used?

• php

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')");

• There are more fields than values

MYSQL can be used to:

• All of the above can be done by MYSQL.

If a PHP script opens a MySQL connection, the script will automatically close the connection after the script has finished executing?

• True

The command to remove rows from a table 'CUSTOMER' is:

• DELETE FROM CUSTOMER WHERE ...

MySQL was invented in the year of

• 1994

How do you start the shorthand form PHP scripting block?

• <? … ?>

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

• JavaScript

Security is not an issue with JavaScript

• False

If the variable $x = 10; , what will $x equal if it is incremented, that is, if I write $x++; what value will $x contain after it has been incremented?

• 11

Consider the following snippet code var string1 = "123"; var intvalue = 123; alert( string1 + intvalue );

• 123123

All text in a multiple line comment block is ignored?

• True

Originally PHP is known as "Personal Home Pages"

• False

PHP runs on various platforms operating system such as apache and IIS

• False

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

• include 'filename';

returns the numbers of rows in a columns.

• count()

Symbol use as identical

• ===

What data type will PHP automatically convert the following variable to:? $aVariable = 99;

• integer (a number variable)

The following condition will return TRUE or FALSE ( (4 >= 4 && 8 < 1) || (44 == 33 || 5 > 3) )

• True

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

• There are more values than fields

AJAX is a programming language

• 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

Identification. Write your answer on the space provided. +, -, *, /, %, are all examples of what category of operators

• arithmetic operators

The ________ clause is used to list the attributes desired in the result of a query.

• Select

Andi Gutmans was the inventor of PHP.

• False

Function trims all spaces from the right of a value

• RTRIM()

Originally PHP is known as PHP: Hypertext Preprocessor (Personal Home Page)

• False

JavaScript Code can be called by using

• Function/Method

The SQL WHERE clause:

• limits the row data are returned.

PHP project originally started in 1995 by RasmusLerdorf. (1994)

• False

PHP only runs in Apache web server.

• False

There are three different kind of arrays:

• Numeric array, Associative array, Multidimensional array

Which is the correct way to write a multiple line PHP comment?

• /* .. *

Syntax is a set of rules that must be followed to write properly structured code?

• True

Server command that calls itself

• $_SERVER['PHP_SELF']

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

• Values

The default file extension for PHP files is ".php".

• True

What does SQL stand for?

• Structured Query Language