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 UsSharing is Caring
It's the biggest motivation to help us to make the site better by sharing this to your friends or classmates.
A comprehensive resource for learning and mastering the skills needed to design, build, and deploy dynamic and interactive web applications using frameworks.
_Select * from employee where salary>10000 and dept_id=101; Which of the following fields are displayed as output?
There are three different kind of arrays:
Which SQL statement is used to insert a new data in a database?
Which of the following employee_id will be displayed?
This command sends active query to the database
Which one of the following sorts rows in SQL?
The following condition will return TRUE or FALSE: (4 >= 4 && 8 < 1)
Which is the correct way to write a multiple line PHP comment?
<?php for($x=0;$x<=10;++$x) { print++$x; } ?>
Which of the following displays the unique values of the column. Select ________ dept_name from instructor;
What will be the output of the following PHP code ? <?php $x; for($x=-3;$x<-5;++$x) { print++$x; } ?>
The concatenation operator in PHP?
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')");
What data type will PHP automatically convert the following variable to: $aVariable = "Robert";
Which of the following can add a row to a table?
Area that can be specified by the cols and rows attributes, or even better; through CSS' height and width properties
Its a client-side script that communicates to and from a server/database without the need for a postback or a complete page refresh
PHP server scripts are surrounded by delimiters, which?
PHP 3 was released in 1998.
Which one of the following method is used to retrieve the number of rows affected by an INSERT, UPDATE, or DELETE query
Function trims all spaces from the right of a value
Server command that calls itself
PHP variables need to be declared before adding a value to it?
What does PHP stand for?
The ________ clause is used to list the attributes desired in the result of a query.
Which one of the following denotes the difference between SELECT and USE command?
The following condition will return TRUE or FALSE:(4 >= 4 || 8 < 1)
The "mysql_close()" function allows you to close a MySQL connection?
Which of the following is the original purpose of SQL?
Returns the highest value
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);
returns the numbers of rows in a columns.
All variables in PHP start with which symbol?
What is the correct way to end a PHP statement?
MYSQL can be used to:
The PHP If Else Statement can execute the code within the if and else segments at the same time?
It refers to styles for your documents, including the design, layout and variations in display for different devices and screen sizes.
Converts text to uppercase
Which operator will check if two variables are the same?
If I wanted to concatenate a word to a string variable I would use which symbol?
Symbol use as identical
Security is not an issue with JavaScript
MySQL was invented in the year of
To use MySQL on your computer, you'll need?
MySQL runs on which operating systems?
Other term use for Option buttons?
All text in a multiple line comment block is ignored?
PHP variables start with what symbol ?
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.
Which of the following statements contains an error?
The logical operator && stands for?
this function allows you to connect to mysql database
What will happen in this function call?
In a LIKE clause, you can could ask for any value ending in "qpt" by writing
The SQL keyword(s) ________ is used with wildcards.
A NULL value is treated as a blank or 0.
The "I" in MySQLi stands for
The following are examples of =, +=, *=, /=, .= _______ Operators
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)
What is the output of the following? echo strcmp('first', 'second'), ", "; echo strcmp('44', '054'), ", "; echo strcmp('0x80', 'a'), ", "; echo strcmp('a', 'A');
JavaScript Code can be called by using
The following condition will return TRUE or FALSE:!(4 >= 4 || 8 < 1)
All variables in PHP start with a $(dollar) sign?
The INSERT INTO statement is not used to add new records to a database table?
Joining values together (by appending them to each other) to form a single long value.
Multiple Choice. Select the best answer How do you start the standard form PHP scripting block?
The keystone of AJAX
What is the function of the ucfirst and lcfirst functions?
Returns the status-number of a request if "OK"
It's a function returns the Unix timestamp for a date.
The command to remove rows from a table 'CUSTOMER' is:
When a variable is declared, it can only be used 1 time in your PHP source file?
What will be the output of the following PHP code ? <?php for($x=-1;$x<10;--$x) { print$x; } ?>
The date() function returns ___ representation of the current date and/or time.
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.
The following comparison condition would return TRUE or FALSE:(4 <> 7)
What data type will PHP automatically convert the following variable to:? $aVariable = 99;
PHP is one of the most widely used and recognizable web technology use on the internet.
Can hold an unlimited number of characters, and the text renders in a fixed-width font.
Object is used to exchange data with a server behind the scenes.
The logical operator || stands for?
To sort the results of a query use:
Which one of the following function is useful for producing a timestamp based on a given date and time.
This are functions that operate on a set of rows to calculate and return a single value.
What will be the output of the following PHP code ? <?php for($i++;$i==1;$i=2) print"In for loop "; print"After loopn"; ?>
_Select name, course_id from instructor, teaches where instructor_ID= teaches_ID; This Query can be replaced by which one of the following ?
What does the following MySQL command do? SELECT * FROM author WHERE auth_name LIKE 'W%';
If a source file contains PHP code, what extension should be used?
Element represents a control that presents a menu of options.
PHP script tags ends with ?>;
XMLHttpRequest object function that cancel request.
Which of the following are the five built-in functions provided by SQL?
The SQL WHERE clause:
Which one of the following methods is responsible for sending the query to the database?
How many single line commenting types are there?
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
The SQL statement that queries or reads data from a table is ________ .
Insert into employee _____ (1002,Jeiven,2000); In the given query which of the keyword has to be inserted ?
Consider the following snippet code var string1 = "123"; var intvalue = 123; alert( string1 + intvalue );
The following condition will return TRUE or FALSE: (7 >= 7 && 9 < 2)
The following example $x -= $y; is the same as?
What functions count elements in an array?
Which function used to get the current time in mysql?
Working locally you an access php script by using http://localhosts/filename.php
Whitespace is not ignored in PHP?
Which is identified as a special variable, which can store multiple values in one single variable?
Which one of the following databases has PHP supported almost since the beginning?
Which SQL statement is used to delete data from a database?
The default file extension for PHP files is ".php".
Syntax is a set of rules that must be followed to write properly structured code?
Which SQL statement is used to insert new data in a database?
In PHP, the only way to output text is with echo.
What does SQL stand for?
How do you start the shorthand form PHP scripting block?
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;
The following condition will return TRUE or FALSE: !(3 >= 3 || 8 < 1)
A way on how to print / display text on the screen.
Originally PHP is known as "Personal Home Pages"
What will be the output of the following PHP code ? < ?php $i = 0; for ($i) { print$i; } ? >
The following are examples of =, !=, === ______ Operators
Function that is used to check whether a variable is set or not.
Which of the following is the incorrect way to declare a PHP variable?
One of the parameters to represent the day of the month
Which one of the following statements should be used to include a file?
PHP is proprietary software.
Which statement will evaluate and include a file into the location where it is called.
Multiple Choice. Select the best answer How do you write "Hello World" in PHP
What will the following script output?
With SQL, how do you select a column named "FirstName" from a table named "Persons"?
The PHP If Statement will only execute the code within it's curly braces if the if condition is FALSE?
If a PHP script opens a MySQL connection, the script will automatically close the connection after the script has finished executing?
What does a semicolon signify at the end of a instruction or statement?
The logical operator ! stands for?
The following condition will return TRUE or FALSE:(7 >= 7 && 9 < 2)
Facebook, wordpress uses php as script language.
The SQL keyword BETWEEN is used:
Look at the following code and determine what will be displayed in the browser: <?php echo "Hello World 1"; // echo "Hello World 2"; ?>
Which one of the following is the right way of defining a function in PHP?
The result of a SELECT statement can contain duplicate rows.
Identification. Write your answer on the space provided. +, -, *, /, %, are all examples of what category of operators
The "mysql_error()" function returns the error description for a MYSQL operation?
PHP project originally started in 1995 by RasmusLerdorf. (1994)
With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"?
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?
The PHP syntax is most similar to:
It's a time manipulation function that returns the current date.
PHP runs on various platforms operating system such as apache and IIS
represents a control that presents a menu of options.
Symbol use to append data or string
Which is the incorrect way to start a single line PHP comment?
You can add a row using SQL in a database with which of the following?
Andi Gutmans was the inventor of PHP.
Which one of the following denotes the default mysql date format?
Consider the following code snippet : var grand_Total=eval("10*10+5");
Which one of the following statements is used to create a table?
Original developer of JavaScript?
The ______ clause allows us to select only those rows in the result relation of the ____ clause that satisfy a specified predicate.
To remove duplicate rows from the result set of a SELECT use the following keyword:
What is the output of the following code? $a=1; ++$a; $a*=$a; echo $a- -;
The HAVING clause does which of the following?
In an SQL SELECT statement querying a single table, the asterisk (*) means that:
What will be the output of the following PHP code ? <?php for($x=1;$x<10;++$x) { print"*t"; } ?>
PHP in now known as "PHP: Hypertexts Preprocessor"
For maximum compatibility, you should use the shorthand form to create PHP scripts?
It's a function that returns the lowest value in a column.
The following are examples of >, <=, >=, ==________ Operators
A subquery in an SQL SELECT statement
Ajax Stands for
It's a text function that returns convert string to lowercase
Which one of these variables has an illegal name?
When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s):
All text to the right of a single line comment is not ignored?
PHP can be run on Microsoft Windows IIS(Internet Information Server):
True or False - The following search statement will exclude any records that contain the term "poodle." (dogs OR canines) NOT cats.
The "mysql_connect()" function opens a MySQL connection?
In which positions PHP's indexed array begin?
An object-oriented computer programming language commonly used to create interactive effects within web browsers
Returns header information
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.
The "or die()" part of a MySQL command will execute if the connection fails?
This function allows you to close the current connection.
Tag is used to group block-elements to format them with CSS.
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?
Is allowed us to collect data from the htm file and display to the php script.
The wildcard in a WHERE clause is useful when?
PHP's numerically indexed array begin with position __.
The following example $a -= $b; is the same as?
A line of php code must end with a ?
AJAX is a programming language
PHP only runs in Apache web server.
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.
Option buttons are also called Selection button
The following condition will return TRUE or FALSE ( (4 >= 4 && 8 < 1) || (44 == 33 || 5 > 3) )
What will be the output of the following PHP code ? <?php for(1;$i==1;$i=2) print"In for loop "; print"After loopn"; ?>
What will be the output of the following PHP code ? <?php for($i==2;++$i==$i;++$i) print"In for loop "; print"After loopn"; ?>
Identify if the statement if True or False. Write True if statement is true otherwise False php.org is the official php resource.
Which of the following is the correct order of keywords for SQL SELECT statements?
To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included
Symbol used to combine 2 sting values to create one string.
The following comparison condition would return TRUE or FALSE:(3 <> 6)
True or False. JavaScript can be inserted into any web page regardless of the file extension.
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?
Which of the following statement is not true about MySQL DROP command?
MySQL COUNT() function returns
Find the SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = 'VA';
Using the _POST is allowed us to collect data from the htm file and display to the php script
Original Name of JavaScript
What will be the output of the following PHP code ? <?php $colors=array("red","green","blue","yellow"); foreach($colors as $value) { echo "$value<br>"; }
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;
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')");
What will be the output of the following PHP code ? <?php for($x=0;$x<=10;$x++) { echo"The number is: $x<br>"; } ?>
In PHP you can use both single quotes ( ' ' ) and double quotes ( " " ) for strings
Function that select database.
It uses spec cols and rows attributes, or even better; through CSS' height and width properties.
Function is used to convert a human readable string to a Unix time.
Using XAMPP server you can use SQL Server database.
A variable declared within a function.
When using the POST method, variables are displayed in the URL:
Originally PHP is known as PHP: Hypertext Preprocessor (Personal Home Page)
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')");
The following condition will return TRUE or FALSE ( (2 >= 2 && 8 < 1) || (11 == 33 || 5 > 3) )
Version 4 of php supports global variables $Get etc. (v4.1)
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 SubjectWeb 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
Shopee Helmet
Shopee 3D Floor
Lazada Smart TV Box