Follow and like us on our Facebook page where we post on the new release subject and answering tips and tricks to help save your time so that you can never feel stuck again.
Shortcut

Ctrl + F is the shortcut in your browser or operating system that allows you to find words or questions quickly.

Ctrl + Tab to move to the next tab to the right and Ctrl + Shift + Tab to move to the next tab to the left.

On a phone or tablet, tap the menu icon in the upper-right corner of the window; Select "Find in Page" to search a question.

Share Us

Sharing is Caring

It's the biggest motivation to help us to make the site better by sharing this to your friends or classmates.

Web Application Development

A comprehensive resource for learning and mastering the skills needed to design, build, and deploy dynamic and interactive web applications using frameworks.

web

application

development

html

css

javascript

front-end

back-end

database

frameworks

responsive

user-friendly

scalability

security

testing

The keystone of AJAX

  • XMLHttpRequest

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

  • $a_Number = 9

The concatenation operator in PHP?

  • .

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

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

  • Aggregate functions

Ajax Stands for

  • Asynchronous JavaScript And XML.

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

  • True

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

A variable declared within a function.

  • local

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

  • True

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 one of the following method is used to retrieve the number of rows affected by an INSERT, UPDATE, or DELETE query

  • affected_rows()

Returns the highest value

  • MAX()

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

  • Distinct

PHP only runs in Apache web server.

  • False

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

  • True

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

  • String

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

  • integer (a number variable)

MySQL COUNT() function returns

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

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

  • True

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

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

  • all columns of the table are to be returned.

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

  • infinite loop

PHP variables start with what symbol ?

  • A $ symbol

This command sends active query to the database

  • mysql_query()

PHP in now known as "PHP: Hypertexts Preprocessor"

  • False

PHP's numerically indexed array begin with position __.

  • 0

Which operator will check if two variables are the same?

  • ==

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

  • False

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

  • False

Function trims all spaces from the right of a value

  • RTRIM()

What will happen in this function call?

  • Call by value

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

  • Textarea

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

  • *********

PHP 3 was released in 1998.

  • True

The "I" in MySQLi stands for

  • improved

What does PHP stand for?

  • PHP: Hypertext Preprocessor

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

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

Function that select database.

  • mysql_select_db();

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

  • True

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

  • True

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

  • Some sort of client program to access the databases

Which of the following is the original purpose of SQL?

  • All of the above.

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

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

  • XMLHttpRequest

What will the following script output?

  • 78

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

  • 123456789101112

What is the correct way to end a PHP statement?

  • ;

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

  • Values

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

  • 123123

Which of the following employee_id will be displayed?

  • 1018

How do you start the shorthand form PHP scripting block?

  • <? … ?>

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

What is the function of the ucfirst and lcfirst functions?

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

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

  • False

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

  • LIKE only

represents a control that presents a menu of options.

  • select

Whitespace is not ignored in PHP?

  • False

What functions count elements in an array?

  • count

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

  • _POST

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

  • True

MYSQL can be used to:

  • All of the above can be done by MYSQL.

JavaScript Code can be called by using

  • Function/Method

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

  • error

A NULL value is treated as a blank or 0.

  • 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

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

  • div

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

  • True

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

  • 4

_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

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

  • True

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

  • False

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

  • Assignment

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

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

  • DELETE

MySQL was invented in the year of

  • 1994

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

  • CREATE TABLE table_name (column_namecolumn_type);

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

  • True

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

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

  • INSERT INTO

PHP script tags ends with ?>;

  • False

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

  • echo

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

  • True

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

The wildcard in a WHERE clause is useful when?

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

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

  • False

One of the parameters to represent the day of the month

  • d

XMLHttpRequest object function that cancel request.

  • Abort()

returns the numbers of rows in a columns.

  • count()

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

  • concatenate

Other term use for Option buttons?

  • Radio buttons

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

  • LIKE %qpt

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

  • MYSQL

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

  • False

The logical operator || stands for?

  • AND

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

  • .

What does SQL stand for?

  • Structured Query Language

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

  • Array

The result of a SELECT statement can contain duplicate rows.

  • 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

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

  • $x = $x – $y;

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

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

  • the end of a PHP statement or instruction

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

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

  • functionfumctionName(parameters) { function body }

Converts text to uppercase

  • Upper()

Which of the following statements contains an error?

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

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

  • True

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

  • Min()

Andi Gutmans was the inventor of PHP.

  • False

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

  • SELECT

MySQL runs on which operating systems?

  • Unix, Linux, Windows and others

this function allows you to connect to mysql database

  • mysql_connect(),

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

  • True

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

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

  • SELECT FirstName FROM Persons

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

  • 105 as an integer value

To sort the results of a query use:

  • ORDER BY.

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

  • _POST

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

  • False

Using XAMPP server you can use SQL Server database.

  • False

All text in a multiple line comment block is ignored?

  • True

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

  • include 'filename';

The logical operator ! stands for?

  • NOT

This function allows you to close the current connection.

  • close();

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

  • INSERT

Facebook, wordpress uses php as script language.

  • True

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

  • Where, from

Symbol use as identical

  • ===

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

  • isset()

A subquery in an SQL SELECT statement

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

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

  • False

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

  • CSS

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

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

  • Comparison

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

  • False

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

  • /* .. *

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

  • mktime()

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

  • False

There are three different kind of arrays:

  • Numeric array, Associative array, Multidimensional array

Symbol use to append data or string

  • .

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

  • DELETE FROM CUSTOMER WHERE ...

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

  • Lower()

All variables in PHP start with which symbol?

  • $

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

  • False

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

  • .

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

  • php

How many single line commenting types are there?

  • 2

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

  • False

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

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

  • JavaScript

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

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

  • YYYY-MM-DD

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

  • Equality

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

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

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

  • CurDate()

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

  • arithmetic operators

Which one of the following sorts rows in SQL?

  • ORDER BY

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

  • True

Originally PHP is known as "Personal Home Pages"

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

Original developer of JavaScript?

  • Brendan Eich

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

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

  • False

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

  • /* .. */

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

Which one of these variables has an illegal name?

  • $my-VarV

Server command that calls itself

  • $_SERVER['PHP_SELF']

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

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

  • False

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

  • query()

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

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

The SQL WHERE clause:

  • limits the row data are returned.

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

  • echo "Hello World";

Original Name of JavaScript

  • LiveScript

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

  • mktime()

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

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

  • False

Element represents a control that presents a menu of options.

  • HTML select

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

  • False

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

  • $a = $a – $b;

The logical operator && stands for?

  • AND

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

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

  • DISTINCT

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

  • 200

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

  • False

PHP is proprietary software.

  • True

In which positions PHP's indexed array begin?

  • 0

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

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()

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

  • DISTINCT

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

  • False

Which function used to get the current time in mysql?

  • NOW()

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'

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

  • textarea

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

  • <?php … ?>

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

  • True

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

  • True

The HAVING clause does which of the following?

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

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

  • strtotime()

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

  • no output

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

  • False

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

  • COUNT, SUM, AVG, MAX, MIN

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

The SQL keyword BETWEEN is used:

  • for ranges.

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

  • SELECT, FROM, WHERE

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

  • include statement

The PHP syntax is most similar to:

  • Perl and C

Security is not an issue with JavaScript

  • False

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

  • string (a text variable)

Returns header information

  • getAllResponseHeaders()

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

  • False

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

  • Select

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

  • False

A line of php code must end with a ?

  • Semicolon ( ; )

Option buttons are also called Selection button

  • False

PHP server scripts are surrounded by delimiters, which?

  • <?php...?>
Comments
Paypal Donation

To keep up this site, we need your assistance. A little gift will help us alot.

Donate

- The more you give the more you receive.

Related Subject

Web Systems Technologies

Computer Information Systems

Web Enhanced Animation Graphics

Integrative Programming and Technology 2

Mobile Programming

Logic Circuit and Switching Theory

Computer Programming

Cell Theory

Psychology

Family Child Care

System Analysis Design and Development

Training and Development

Special Topics in Human Resource Management

Science Technology and Society

Mobile Application Design and Development

Introduction to Multimedia

Software Engineering 2

Web Development

Web Design

Geographic Information Systems

Relational Database Systems

Database Management System

Advanced Database Management Systems

Venture Capital

Cloud Computing and the Internet of Things

Intrusion Detection System

Operating System Functions

Network Administration

Health Information Technology

Computer Support Technician

Risk Management Applied to Safety Security and Sanitation

Property Management System

Investment and Portfolio Management

Information Assurance and Security 2

Information Assurance and Security 3

Information Management

Information Security and Management

Fundamentals of Investigation and Intelligence

Fundamentals of Database System

Cyber Security: Theories and Practice

Quality Assurance Testing

Software Development

Electronics Engineering Technology

Unified Functional Testing


Show All Subject
Affiliate Links

Shopee Helmet

Shopee 3D Floor

Lazada Smart TV Box