Help

Options

focusNode

Didn't know it?
click below

Knew it?
click below

Don't Know

Remaining cards (0)

Know

retry

shuffle

restart

0:00

Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.

Normal Size Small Size show me how

FE - AppDev

APPLICATION DEVELOPMENT AND EMERGING TECHNOLOGIES/CCS0043

Question	Answer
M1:
Language construct that use to output one or more string	Echo
PHP require to use a web browser	True
Comments can be put anywhere in the code	True
What is the default location of XAMPP?	C:\
ASP style tag	<%...%>
Which of the following is not Mac OS	Giraffe
Returns the type of the variable	gettype()
Variables are like a	Container
In what year PHP 1.0 released	1994/1995
Oracle is example of database that PHP can use	True
$num = 10; Valid or invalid?	Valid
PHP is a free of charge	True
PHP can run only in Mac OS	False
How many domains installed in PHP 5	19 million
<?php Echo ‘Welcome to PHP’; ?> What is the output	Welcome to PHP
PHP contains more libraries and thousands of functions	True
All php files must be save on htdocs folder	True
Which of the following is not a web server?	MyServ
PHP 5 vastly improved	Object Oriented capabilities
What is OS?	Operating System
To display the string that starts with $ and to display the double quote as string use the escape character \ (backslash).	True
Allow for multiple items of the same type to be aggregated under a single representative entity (Array and Objects)	Compound datatypes
Is a function also use for outputting strings	Print
Variables are like a	Container
How many types of comment php have?	3
Variables are not case sensitive	False
PHP can run only in Linux OS	False
How many domain PHP installed on May 22, 2000	3.6 million
Recursive acronym for PHP	Hypertext Preprocessor
Version of PHP that support Unicode	PHP 6
Variables in PHP must begin with	$
PHP can use in Linux	True
PHP version that has an Enterprise development	PHP 4.0
Closing tag for PHP scripts	?>
Variables in PHP is not explicitly declared	True
Presented ads character corresponding to that ASCII value	%c
Term used to combine two or more different strings	Concatenate
PHP is a loosely type language (no explicitly create, typecast, or destroy a variable)	True
Presented as a binary number	%b
PHP 4.0 Dubbed with	Zend scripting engine
_name is a valid variable	False
$ inside “ ” are interpreted as variables thus it will display the value rather than the string that starts with $	True
Is the generic name assigned to any data sharing a common set of characteristics	Datatypes
PHP means	Personal Home Page
In PHP 5 how many percent on all Apache module	54
PHP key categories are practicality, power, possibility, and _____	Price
Presented as a signed decimal number	%d
One of the Core developers of PHP 4.0	Zeev Suraski
Year that the developers joined Lerdorf	1998
New language features for PHP 6	Foreach looping
You need a subscription before you use the PHP	False
Which of the following is not a code editor?	Mspaint
First character of variable can be ‘_’ or a letter	True
Short open tag	<?…?>
PHP is an native support for SQLite	True
Presented as a floating point number	%f
Symbol used for multi-line comment	/* */
One of the Core developers of php 4.0	Andi Gutmans
What is the url is use to open your created php files	localhost
Which of the following is not Linux OS	Vista
$age is a valid variable	True
In what year PHP 3.0 released	1998
Are used as a container for the values that can be used and manipulate PHP scripts	Variable
In what year PHP 2.0 released	1997
All PHP scripts must be enclosed with	<??>
PHP created 1994/1995 to know how many visitors were reading his online resume based on	PERL/CGI script
Which of the following is not Windows OS	Cheetah
A server-side scripting language that runs its application on a Web server	PHP
Script tag	</script>
Symbol for single line comment	//
Which of the following is not an internet browser	Windows Media
PHP can put anywhere in the code	True
Statement terminator	;
PHP is based on	C
Much of the PHP syntax were derive from C programming Language	True
Variable might contain a string, numbers, arrays and objects	True
Capable of containing a single item of information (Boolean, Integer, Float, String)	Scalar datatypes
Converts a given variable to a specific type	settype()
Strings inside the ‘ and ‘ are interpreted as literal strings	True
PHP is a embedded language that is commonly embedded on	HTML
Who develops PHP?	Rasmus Lerdorf
variable can only contain ________characters and underscore (a-z,A-Z,0-9,_)	alpha-numeric
Standard tag	<?php…?>
returns the type of the variable. Possible return values are integer, double, boolean, string, array, object, resource, unknown types	gettype()
$ inside “ and “ are interpreted as variables thus it will display the value rather than the string that starts with $.	True
You need a web browser to open PHP files	True
Extension name for PHP files	.php
Symbol use for Perl style single line comment
Software used to run PHP Scripts	XAMPP
_______________________________________________________________________	_______________________________________________________________________
_______________________________________________________________________	_______________________________________________________________________
M2:
Symbol for less than or equal to	<=
Associativity for Addition, subtraction, concatenation	Left
Associativity for ternary operator	Right
$v=70;\nif($v<=70) {\n echo “hooray”;\n} else {\n Echo “hello”;\n}\nWhat is the output if the value of $v is 100?	hello
Symbol for equal to	==
$v=70;\nif($v<=70) {\n echo “hooray”;\n} else {\n Echo “hello”;\n}\nWhat is the output?	hooray
Operator for Expression subgrouping	()
Symbol for OR operator in PHP	\|\|
Assignment symbol	=
Operator for index enclosure	[]
$s=90;\nif($s==80 && $s<90) {\n echo “Rank B”;\n} else if($s>90){\n echo “Rank A”;\n}else{\n Echo “Rank C”;\n}\nWhat is the output if $s=50?	Rank C
Decrement symbol	--
continue statement causes execution of the current loop iteration to end and commence at the beginning of the next iteration.	True
Syntax for while statement	while(expr){statement}
elseif is one of the conditional statements in php	True
Increment symbol	++
Symbol for subtraction	-
Do is a looping stamen	False
$x=15;\nEcho --$x;\nWhat is the output?	14
Operator for Object instantiation	new
There is always default inside of the switch in PHP	True---
characteristic of an operator specifies how operations of the same precedence are evaluated as they are executed.	Operator associativity
$m=3;\nswitch($m){\n case 1: echo “May”; break;\n case 2: echo “June”; break;\n case 3: echo “July”; break;\n default: echo “invalid”; break;\n}\nWhat is the output if $m is one?	May
$x=0;\nfor($i=1;$i<5;$i++){$x+=$i;}\necho $x;\nWhat is the output if $x=2	12
Addition-assignment symbol	+=
$a=100;\n$b=20;\nIf($a<$b)\n{echo $a+$b;}\nQuestion: what is the output of the code	Blank
Operator for Bitwise AND, bitwise XOR, bitwise OR	& ^ \|
What do you call a condition inside of a condition?	Nested if
Associativity for Object instantiation	NA
$m=3;\nswitch($m){\n case 1: echo “May”; break;\n case 2: echo “June”; break;\n case 3: echo “July”; break;\n default: echo “invalid”; break;\n}\nWhat is the output if $m is 2?	June
$x=0;\nfor($i=1;$i<5;$i++){$i+=$i;}\necho $x;\nWhat is the output?	0
Escape Sequence for horizontal tab	\t
$x=10;\nEcho ++$x;\nWhat is the output?	11
You can only use string inside of the case statement	False
Syntax for Switch	switch($category)
$if=10;\nIf($if==$if){} \nWhat is the output?	True--
$x=15;\nEcho --$x;\nWhat is the output?	14
Symbol for addition	+
Syntax for do… while statement	do{statement}while(expr);
$s=90; if($s==80 && $s<90) { echo “Rank B”; } else if($s>90){ echo “Rank A”; }else{ echo “Rank C”; } What is the output if $s=85?	Rank C
$a=10; while($a>0){ echo $a--.” ”; } What is the output?	10 9 8 7 6 5 4 3 2 1
$a=10;$ b=20; If($a<$b) {echo $a+$b;} Else {echo $a-$b;} Question: what is the output of the code	30
Symbol for greater than or equal to	>=
Syntax for for statement	for(expr1;expr2;expr3){statement}
Symbol for identical to	===
Multiplication-assignment symbol	*=
You can only use 50 cases for the switch	False
if(7 __ 4) { echo “true”;} Else { echo “false”;} What is missing code to make the statements true?	>
Division-assignment symbol	/=
Associativity for assignment operators	Right
$m=3; switch($m){ case 1: echo “May”; break; case 2: echo “June”; break; case 3: echo “July”; break; default: echo “invalid”; break; } What is the output if $n is 1?	July
You can create multiple statements inside of an condition	True
Which of the following is not a looping statement?	Loop
$a=10; while($a>0){ echo $a--.” ”; } What is the output if $a is 5?	5 4 3 2 1
_______________________________________________________________________	_______________________________________________________________________
_______________________________________________________________________	_______________________________________________________________________
M3:
$mo = array(“jan”,”feb”,”mar”);echo “<pre>”;var_dump ($mo);echo “</pre>”; Check the code if valid or invalid?	Valid
Function can have a return value	True
Using foreach statement you can display both the keys and value of each element in the array.	True
Global Variables is declared inside a function and is only available within the function in which it is declared.	False
Syntax of a function	Function name(param){}
Local Variables is one that declared outside a function and is available to all parts of the program.	False
function a($a,$b){ return $a+$b; } echo a(5,4); what is the name of the parameter?	$a and $b - should be correct but is wrong; try a
functions that are built-in into PHP to perform some standard operations	Predefined functions
You can create a function inside of a function	True
Sorts by key	ksort($array)
is a group of PHP statements that performs a specific task. Functions are designed to allow you to reuse the same code in different locations.	Functions
You can pass values to a function and you can ask functions to return a value.	True
Sorts by value; keeps the same key	asort($array)
foreach($arr as ___ => $value){ //do something }	$key
Sorts by value in reverse order; keeps the same key	arsort($array)
ksort() and krsort() used to sort elements by values.	False(Sorted by keys)
function is used to print the array structure.	print_r
functions are commonly used for debugging. The point of this of these functions is to help you visualize what’s going on with compound data structures like arrays.	print_r() and var_dump()
We use static keyword to declare a variable inside a function that will act as accumulator variable this will let the program remember the last value of the variable that was used.	True
	$value
function a($a,$b){return $a+$b;}echo a(6,5); what is the value of $a?	6
Array index in PHP can be also called	Array keys
Array index in PHP can be also called as array storage	False
Array can be used as ordinary array same as in C and C++ arrays.	True
Functions can only have 1 parameter	False
$fruit = array(“orange”,”apple”,”grape”,”banana”); What is the value of index 1?	apple
	Array index
$g = 200; function a(){echo “5”;} function b(){echo “4”;} ab(); what is the output of the code?	error
Array can be used as ordinary array same as in	C and C++
What do you call a function inside of a function	Nested function
$g = 200; function a(){echo “5”;} function b(){echo “4”;} a(); what is the output of the code?	5
$fruit = array(“orange”,”apple”,”grape”,”banana”); What is the value of index 0?	orange
Function count($val){ static $c = 0; $c += $val; echo $c; } Count(4); Count(3); What is the output of the code?	Error
$s = “variable”; function f(){ global $s; echo “function called ”; echo “$s”; } f(); what is the output of the code?	function called variable
The foreach statement is use to iterate through the element in an array.	True
var_dump function is same as print_r function except it adds additional information about the data of each element.	True
$g = 200; function a(){echo “5”;} function b(){echo “4”;} a();b(); what is the output of the code?	54
Each member of the array index references a corresponding value and can be a simple numerical reference to the value’s position in the series, or it could have some direct correlation to the value.	True
A function that is declared inside a function is said to be hidden.	False(Nested function)
$f = array( '102' => "red", '101' => "blue", '100' => "yellow"); ksort($f); print_r($f); What is the key of the yellow?	100
$f = array( '102' => "red", '101' => "blue", '100' => "yellow"); krsort($f); print_r($f); What is the output of the code?	Array ( [102] => red [101] => blue [100] => yellow )
Function count($val){ $c = 0; $c += $val; echo $c; } count(10); count(5); What is the output of the code?	Error
$fruit = array(“orange”,”apple”,”grape”,”banana”); What is the value of index 2?	grape
function keyword is used in PHP to declare a function.	True
$num=array(1,2,3,4,5); foreach($num as $val){echo $val;} What is the output of the code?	12345
is used to retain the values calls to the same function.	Static variables
You can create your own function inside of a php code	True
To gain access to a variable that is outside from the function we use the global keyword.	True
foreach($arr as ___ => $value){ //do something }	$key
functions that are provided by the user of the program.	User defined function
is declared inside a function and is only available within the function in which it is declared.	Local variables
function disp(){function disp2(){echo “hello”;}} disp(); disp2();	hello
You use can functions in different ways.	True
Sorts by a function	usort($array)
This takes an argument of any type and prints it out, which includes printing all its parts recursively.	print_r()
function disp(){ function disp2(){ echo “hello”; } } disp(); disp2();	hello
Array is used to aggregate a series of similar items together.	True
param – is the formal parameters of the function. Parameter must follow the rule of naming dentifier.	True
Syntax for foreach	foreach($arr as $value){}
Id the keyword used to declare a function	function
$f = array( '102' => "red", '101' => "blue", '100' => "yellow"); krsort($f); print_r($f); What is the output of the code?	Array ( [102] => red [101] => blue [100] => yellow )
$t = 100; function one(){ echo “1000”; } one(); what is the value of the $t after execute the code?	100
Functions can be user defined generally defined by the user of the program and predefined that are build in using libraries.	True
function a($a,$b){return $a+$b;} echo a(5,4); what is the output of the code?	9
is used to aggregate a series of similar items together, arranging and dereferencing them in some specific way.	Array
$t = 100; function one(){echo “value”;} one(); what is the function name inside of the code?	one
foreach(____ as $value)	$arr
Sorts by value in reverse order; assign new number as the keys	rsort($array)
$g = 200; function a(){echo “5”;} function b(){echo “4”;} a(); what is the value of the $g?	200
$s = “variable”; function f(){ echo “function called ”; echo “$s”;} f(); what is the output of the code?	function called undefined variable: s
asort() and arsort() used to sort elements by keys.	False(Sorted by values)
You can use only 10 for Array elements	False
specify an array expression within a set of parenthesis following the foreach keyword.	True
$fruit = array(“orange”,”apple”,”grape”,”banana”); What is the value of index 3?	banana
Sorts by key in reverse order	krsort($array)
is a statement used to iterate or loop through the element in an array.	foreach()
Function can only do something without passing values.	True
$a[]=”mango”; $a[]=”apple”; $a[]=”banana”; Check the code if valid or invalid?	Valid
sort() and rsort() does not maintain its index reference for each values.	True
What is the keyword use to gain access a variable that is outside of the function?	Global
function disp(){ function disp2(){ echo “hello”;}} Disp(); disp2();	error
	True
sort(), asort(), and ksort() functions are used to sort elements in the array in ascending order.	True
Functions are limited to 1 per code only	False
PHP array does need to declare how many elements that the array variable have.	False
PHP has a built-in function to perform operations	True
$g = 200; function a(){echo “5”;} function b(){echo “4”;} b(); what is the output of the code?	4
$mo = array(“jan”,”feb”,”mar”);echo “<pre>”;print_r ($mo);echo “</pre>”; Check the code if valid or invalid?	Valid
Sorts by value; assign new numbers as the keys	sort($array)
Functions is a group of PHP statements that performs a specific task.	True
asort(), ksort(), arsort(), and krsort() maintains its reference for each values.	True
function disp(){function disp2(){echo “hello”;}}disp2();	error
it is required to create a function name for a function	True
Array index is also known as Array Keys.	True
rsort(), arsort(), and krsort() functions are used to sort elements in the array in descending order.	True
_______________________________________________________________________	_______________________________________________________________________
_______________________________________________________________________	_______________________________________________________________________
M4:
$x = min(7, 4.7 , 4.25 , 5);echo $x; What is the output?	4.25
$x = min(10, 5 , 3, 20);echo $x; What is the output?	3
Performs the same way as the include function. Generate a fatal error message if file not found stopping the script at that point.	require
Number format can show or hide the decimal places	True
Key word to declare a define function	define
Syntax to converts the first character of each word in a string to uppercase	string ucwords(string $str)
Syntax to stripped white spaces or other characters from the beginning and end of a string.	string trim(string $str [, string $charlist ])
Format character for a full textual representation of the day of the week	l
syntax for length of a string	int strlen (string $string)
Join array elements to form a string	Implode
Syntax to make a string’s first character uppercase	string ucfirst(string $str)
syntax for reverse a string	string strrev (string $string)
syntax to transform a string to upper case	string strtoupper (string $str)
Format character for a textual representation of the day, three letters	D
Split a string by string	Explode
Format character for a short textual representation of a month, three letters	M
Return the smallest value	min()
$val=643322.7834 echo number_format($val,3,’.’,’,’); what is the output?	643,322.783
$x = ceil(5.2);echo $x; What is the output?	6
$x = rand(5,10);echo $x; What is the minimum value of the output?	5
Which of the following is not part of function for array manipulation	Destroy
Format character for the day of the year (starting from 0)	z
Syntax for include	include("filename.inc");
Syntax to get a part of a given string	string substr ( string $string , int $start [, int $length ] )
Format character for English ordinal suffix for the day of the month, 2 characters	S
Including files can use to write their database connection and so on.	True
Same as include function except it includes the file only once.	include_once
Syntax for floor	floor()
Syntax of define	define('NAME','value');
returns the next lowest integer by rounding the value downwards	floor()
used to generate random integers	rand()
strip HTML and PHP tags from a string.	strip_tags()
Format character for number of days in the given month	t
Syntax for explode	array explode ( string $delimiter , string $string [, int $limit ] )
syntax for random	int rand(void)
Syntax to string white spaces or other characters from the beginning of a string	string ltrim ( string $str [, string $charlist ] )
Format a number with grouped thousand	Number format
Same as require function except it includes the file only once.	require_once
Most of the developers used include functions for their	Footer
Most of the developers used include functions for their header and footer.	True
Syntax for include once	Include_once("filename.inc");
Format character for whether it’s a leap year	L
String number_format(float $number,int _____;)	$decimals
$x = floor(5.2);echo $x; What is the output?	5
String number_format( float $number, int _____; )	$decimals
In including files You may write the file with an extension name of ______ rather than .php to serve as a fragment of your program code.	.inc
Syntax for require	require("filename.inc");
Format character for a full textual representation of the month, such as January or March	F
Format character for numeric representation of the day of the week	w
syntax to transform a string to lower case	string strtolower(string $str)
There will be a warning text if the include file not found	True
define(‘Max_n’,10); What is the name of the define function?	Max_n
Includes and evaluates the specified file. Generate a warning on failure message if file not found.	include
Syntax for random number with minimum and maximum value	int rand(int $min, int $max)
$x = max(5.3, 5 , 6, 3);echo $x; What is the output?	6
$val=356342.783 echo number_format($val,2,’.’,’’); what is the output?	356342.78
Return the highest value	max()
Format character for day of the month without leading zeros	j
Syntax for implode	string implode ( string $glue , array $pieces ) string implode ( array $pieces )
Format character for a two digit representation of a year	y
A constant’s value cannot be changed.	True
Return the value length of a string	strlen
Syntax for unset	void unset ( mixed $var [, mixed $...] )
Format character for a full number representation of a year, 4 digits	Y
Syntax to strip white spaces or other characters form the end of a string.	string rtrim(string $str [, string $charlist ])
Syntax for a number format	number_format
Make a string’s first character uppercase	ucfirst()
Format character for numeric representation of a month, with leading zeroes	m
Syntax for ceil	float ceil (float $value)
In some scripts, a file might be included more than once, causing function redefinitions, variable reassignments, and other possible problems.	True
returns the next highest integer by rounding the value upwards	ceil()
syntax for position of a string	int strpos (string $haystack , mixed $needle [, int $offset = 0 ])
string white spaces or other characters from the beginning of a string	ltrim()
find the position of the first occurrence of a substring in a given string	strpos
returns part of a given string	substr
Format character for ISO-8601 numeric representation of the day of the week (added in PHP 5.1.0)	N
converts string to lowercase	strtolower
$x = floor(7.2);echo $x+1; What is the output?	8
convers string to uppercase	strtoupper
Format character for lowercase Ante meridiem and Post meridiem	a
$x = max(10, 5 , 3, 20);echo $x; What is the output?	20
Number format can include thousand separator	True
reverse a given string	strrev
Syntax for maximum value	mixed max(mixed $value)
stripped white spaces or other characters from the beginning and end of a string.	trim()
used to format a local time and date	date()
Syntax for minimum value	mixed min(mixed $value)
destroys the specified variable	unset
_______________________________________________________________________	_______________________________________________________________________
_______________________________________________________________________	_______________________________________________________________________
M5:
Which of the following code will delete cookies	setcookie("name1","value1",time()-60);
Regular Expression pattern modifier for extra analysis of pattern	S
Regular Expression Meta characters symbol for any non-digits equal to [^0-9]	\D
Syntax for setting a cookie	setcookie()
Regular Expression Meta characters Symbol for white-space character	\s
You can include time in cookies	True
Regular Expression Meta characters Symbol for one or more of ‘a’	a+
Regular Expression Meta characters Symbol for not in range (every character except a,b or c)	[^abc]
Session are mechanism for storing data on the server itself.	True
Regular Expression pattern modifier for ignore case	i
Regular Expression Meta characters Symbol for zero or more of ‘a’	a*
$_GET is an associative array variables passed to the current script via	URL
an associative array of variables passed to the current script via HTTP Cookies	$_COOKIE
PCRE means Perl Compatible Regular Expression	False
Regular Expression also known as regex or regexpr	False
contains the filename of the currently executing script.	PHP_SELF
Regular Expression Meta characters symbol for between five to ten of ‘a’	a{5,10}
users can refuse to accepts cookies.	True
Regular Expression Meta characters symbol for exactly two of ‘a’	a{2}
Use to unset session variables	unset()
Sample name of a session $_SESSION[myvalue]; Check the code if it is Valid or Invalid	Invalid
are mechanism for storing data on the server itself.	Session
PCRE function starts with	preg_
$_SERVER is an entries created by the	Web server
Entries were created by the web server	$_SERVER
$_SERVER is an array containing information such as headers, paths, and script locations.	True
What is C in PCRE	Compatible
Regular Expression Meta characters Symbol for item range (a,b or c)	[abc]
Regular Expression Meta characters Symbol for mark the start of a string	^
$_POST is an associative array of variables passed to the current script via this method	HTTP POST
an associative array variables passed to the current script via the URL parameters.z	$_GET
<form action=”<?php echo $_SERVER[‘PHP_SELF’] ?>” method=”get”></form> Check the code if it is valid or invalid	Valid
$_ENV is an associative array containing session variables available to the script	False
<form action=”<?php echo $_SERVER[‘PHP_SELF’] ?>” method=”post”></form> Check the code if it is valid or invalid	Valid
are mechanism for storing data in the remote browser and thus tracking or identifying return users.	Cookies
Regular Expression Meta characters symbol for any alpha numeric character plus underscore. Equals to [A-Za-z0-9_]	\w
is the time that a user spends at your Web site.	Session
$_COOKIE is an associative array of variables passed to the current script via	HTTP
what is P in PCRE	Percl(Pearl)
Regular Expression Meta characters symbol for up to five of ‘a’	a{,5}
Regular Expression Meta characters Symbol for group elements	()
Regular expression example that will match the word hello	‘/hello/’
$_SESSION is an associative array of variables passed to the current script via the environment method	False
an associative array of variables passed to the current script via the HTTP method.	$_POST
Which of the following will show cookies after 1 minute	setcookie(“name1”,”value1”,time()+60);
'the session_destroy() statement does not affect the variables set on the current page	True
Regular Expression Meta characters symbol for any digits equal to [0-9]	\d
an associative array containing session variables available to the script	$_SESSION
Regular Expression pattern modifier for multiline mode	m
Syntax to unset session variables	unset($_SESSION[‘varname’])
Function used to close the session	session_destroy()
Regular Expression is also known as	regex
Regular Expression Meta characters symbol for any non alpha numeric characters	\W
Syntax to set Cookies	setcookie(“name1”,”value1”);
Sample name of a session $_SESSION[‘myname’]; Check the code if it is Valid or Invalid	Valid
What is E in PCRE	Expression
Regular Expression Meta characters Symbol for Zero or one ‘a’ character. Equals to a(0,1)	a?
Regular Expression Meta characters Symbol for mark the end of a string	$
Regular Expression pattern modifier for pattern is treated as UTF-8	u
_______________________________________________________________________	(1 wrong)
Regular Expression Meta characters Symbol for Boolean OR	\|
managing cookies can be done using function	setcookie()
Syntax to display cookies	print_r($_COOKIE)-----
Session is more secure than cookies and can store much more information.	True
Regular Expression Meta characters symbol for any white-space character	\s
_______________________________________________________________________
session_destroy() gets rid of all the session variable information that’s stored in the session file	True
Regular Expression Meta characters Symbol for matches any single character	.
session_start() is always set at the end of each web page	False
is an array containing information such as headers, paths, and script locations.	$_SERVER
Performs a regular expression match	preg_match()
an associative array of variables passed to the current script via the environment method	$_ENV
Cookies are mechanism for storing data in the remote browser and thus tracking or identifying return users.	True
were used to efficiently search for patterns in a given text.	Regular Expression
Cookies are small amount of information containing	variable=value
Regular Expression Meta characters symbol for any non white-space character	\S
_______________________________________________________________________	_______________________________________________________________________
_______________________________________________________________________	_______________________________________________________________________
M6:
Command for deleting a column	DROP(this is wrong apparently????)----DELETE
You can insert a values in a specific column	True
MySQL is written in	C++
Which of the following is not Command help in MySQL	Gethelp
Type of Field data types that has a small number with a floating decimal point.	FLOAT
MySQL prompts means waiting for the next line of multiple line command	->
Developments of lightweight storage tools for websites	MySQL
Command to clear in MySQL	\c
Database successfully created if display Query OK, 1 row affected as a result.	True
MySQL compiles using	GNU gcc
Type of Field data types that range of Variable length string between 1 to 65,535 characters	VARCHAR
Command to add new column	ADD
Command to change field type sizes	MODIFY
What is D in DML?	Data
One important aspect of database management is its querying capability.	True
Syntax to change field names	ALTER TABLE tblname CHANGE field char(1)
SQL has a standard data manipulation language among many database management system.	True
Syntax for creating a database	CREATE DATABASE <dbname>;
Command to delete a table	DROP
What is M in DML?	Manipulation
Command to create a table for the database	CREATE TABLE
Command in MySQL to reconnect to the server	\r
Command in MySQL to set statement delimiter	\d
Command for inserting a value to your table	INSERT INTO
SQL command to view all records in the table	SELECT * FROM <table name>
Is a field in a related table that refers to the primary key in a primary table.	Foreign key
Syntax for dropping a column	ALTER TABLE tblname DROP field
Command in MySQL to display today’s date and time	SELECT NOW();
Field data types Storage value of TIME	Varies
Send comment to mysql server	\g
Command to display the SQL version	Select version();
Command in MySQL to display the current date	Select urrent_date();
Is a field that contains a unique identifier for each record in a primary table.	Primary key
mSQL short for	mini SQL
To open a console go to the command window start/run then type	Command
MySQL is portable	True
SQL database improvement was done by a Swedish programmer	Monty Widenius
MySQL prompts means waiting for next line, waiting for completion of a string that began with single quote(‘’’)	‘>
Command to display the list of table	SHOW tables
is an ordered collection of information from which a computer program can quickly access.	Database
database that stores information in a single table.	Flat-file
INSERT INTO tblinfo (id,name) VALUES (1003,’Henry’); Check the SQL command if valid or invalid	Valid
According to the article of Ian Gilfillan in 2004, the following are the claimed features of MySQL except	High cost
What is Q in SQL?	Query
Syntax for inserting values in a specific column	INSERT INTO <table name> (column name) VALUES (value);
Command to display the structure of the table	DESCRIBE
Command getting status from the server	\s
Syntax to change field type sizes	ALTER TABLE tblname MODIFY field char(1);
MySQL prompts means ready for a new command	mysql>
Is the process of breaking tables into multiple related tables to reduce redundant information.	Normalization
MySQL prompts means waiting for next line, waiting for completion of a string that began in double quote(‘’’)	“>
DML is use for creating queries	True
Syntax to display the structure of the table	DESCRIBE tblname
Field data types Storage value of VARCHAR	Varies according to the number of bytes specified
A single complete set of related information.	Record
Command in MySQL to quit	\q
You can update multiple columns	True
Type of Field data types that range of YYYY-MM-DD	DATE
Code for showing help in MySQL	\h
Field data types Storage value of FLOAT	4 Bytes
Type of Field data types that range of HH:MM:SS	TIME
Open-sourced commercial products	InterBase
are the individual categories of information stored in a record.	Fields
Command to view your table	SELECT
Field data types Storage value of BOOL	1 Byte
mSQL was distributed as shareware	True
What is L in SQL?	Language
Type of Field data types that -2147483648 to 2147483647	INT
Command for dropping a column	DROP
Field data types Storage value of INTEGER	4 Bytes
Type of Field data types that has a large number with a floating decimal point.	DOUBLE
What is S ins SQL?	Structured
Type of Field data types that range -128 to 127; 0 is considered false	BOOL
Command to use database	USE
Syntax for inserting a value to your table	INSERT INTO <table name> VALUES (value1, value2, value3, ....);
Information stored in computer databases is actually stored in	Tables
Field data types Storage value of DATE	Varies
Command to create a database	CREATE
Syntax for updating the records	UPDATE <table name> SET <column name> = <value> WHERE <column name> = <value>;
Syntax for deleting a column	DELETE FROM <table name> WHERE <column name> = <value>;(This should be ALTER but ok)
Command to change field names	CHANGE
MySQL prompts means waiting for next line, waiting for completion of a comment that began with /*.	/*>
Syntax for using database	USE <dbname>;
Field data types Storage value of DOUBLE	4 Bytes
MySQL Command that print current command	\p
He wrote a very lightweight database engine called mSQL	David Hughes
Field data types Storage value of CHAR	Number of bytes specified
Command in MySQL to display the current user	Select user();
Command for updating the records	UPDATE
Go to the MySQL path	C:\xampp\mysql\bin\mysql -u root
Command to show database	SHOW

Created by: Jsean-Ed_DR

"Know" box contains:
Time elapsed:
Retries: