Programming Languages and Systems

You think you can answer few questions about programing languages? How about very specific questions? The following quizzes are made to test your knowledge. As always, i is just for fun and no data will be stored by sanuja.com. Feel free to report any errors. Currently only the PHP, MySQL, CSS and HTML quizzes are up. Expect to see more before September 2013.

PHP and MySQL Quiz

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Some questions have hints and explanations. Click Start to begin.

Start

Congratulations - you have completed PHP and MySQL Quiz.

You scored %%SCORE%% out of %%TOTAL%%.

Your performance has been rated as %%RATING%%

Your answers are highlighted below.

Question 1

Can the PHP pull data from a SQL database?

A	No
B	Yes

Question 2

Input validation is the best way to prevent what type of abuse?

A	injections
B	source code attacks
C	force loads
D	MySQL database attacks

Question 3

It is impossible to migrate from one PHP version to another. You must always backup the non-core files, reload the new versions of the core and reinstall the backed up non-core files.

A	True
B	False

Question 3 Explanation:

There are many ways to migrate from one version to another without using destructive methods.

Question 4

Which of the following coding/programming languages can be embedded within PHP?

A	Java
B	C#
C	HTML
D	Ruby

Question 5

Can a single PHP install one a server can handle multiple websites?

A	No, each website will get it's own set of PHP databases and the PHP install must be independent of each other.
B	No for Windows based servers, but this can be done on a Linux or Unix server. For Windows, each site must have their own install of PHP.
C	Yes, but both websites MUST share the same database files.
D	Yes, as long as each website have the access to the install.

Question 6

The predefined $_GET variable is used to collect values in a form with method="get".

A	True
B	False

Question 7

How many variables a single function can hold?

A	Unlimited
B	1
C	5
D	2

Question 7 Explanation:

As long as the memory of a server permits the PHP to operate, it can handle multiple variables in a single function. In this modern day, there is no reason why memory should run out anyway.

Question 8

What is the best way to determine the log in state of a user?

A	Using a for or a while loops.
B	Using a if condition.
C	function.login()
D	check.login()

Question 9

This language will only be effective if the end users have the proper software installed on their client computers.

A	False, the plugin for PHP will be automatically installed when the client unit access a PHP based site.
B	True, but ONLY for mobile devices.
C	False, PHP is a server side processing language with no end user plugins.
D	True, because PHP requires a plugin much like Flash or Java on the client computer.

Question 9 Explanation:

Almost all web browsers support PHP because there is nothing new the developers have to add to the browser in order for PHP code to work.

Question 10

In the following PHP code use for connecting to a MySQL database, the I and II parameters are respectively...

$sanuja=mysqli_connect("I","II","III","IV");

A	host and database
B	username and password
C	host and username
D	database and host
E	database and password

Question 11

When connecting to a MySQL database, where do you enter the username and password in the following PHP code?

$sanuja=mysqli_connect("I","II","III","IV");

A	at II and III
B	at I and II
C	at I and IV
D	at III and IV

Question 12

What type of code is shown (assuming it is written in PHP) here?

$cars=array("Volvo","BMW","Toyota"); echo "I like " . $cars[0] . ", " . $cars[1] . " and " . $cars[2] . ".";

A	condition
B	data set
C	loop
D	array

Question 13

A pure PHP authentication system (log in/gatekeeper) is more secure than the ones that use SQL/MySQL database generated authentications.

A	True
B	False

Question 14

What is the purpose of print_r() variable?

A	It is used to pass the information from previous function to the next known as "r".
B	It prints out the program's out come for input of the next.
C	This is not a valid PHP function.
D	It is the human-readable information print out.

Question 15

Which of the following is not true about MySQL?

A	MySQL cannot support standard SQL.
B	MySQL was developed and supported by Oracle Corporation.
C	MySQL can be used on both small and large scale databases.
D	MySQL can be installed on Windows, Linux and Unix servers.
E	MySQL is a free database program.

Question 16

We use mail() function to generate emails. In the following code, where do you get the information on receiver's email address?

mail(V, W, X, Y, X)

A	At position W
B	At position V
C	At position X
D	At position Z
E	At position Y

Question 17

In PHP 5 (older versions it was different), which of the following we used for number of affected entries by q query? (Make sure you pay attention to every single character in the answer!)

A	mysqli():affected_rows()
B	mysql_affected_rows() Hint: Uh... this is the old one! Oops!
C	mysql():affected_rows()
D	mysqli_affected_rows()

Question 18

A string can be denoted by which of the following characters?

A	€
B	[...]
C	$
D	{...}

Question 19

You were given the task to customize the behavior of the language for a client. What is the best file to edit that would impact core PHP behaviors?

A	_.php
B	php.ini
C	FileName.php
D	php.exe

Question 20

A valid variable name should NOT contain which of the following character(s)?

A	numbers
B	white space
C	capital letters
D	mix of simple and capital letters

Question 20 Explanation:

White space is like space or tab in which there is a gap between two set of phrases. For example, Manuja Senanayake is not allowed because there is a space between Manuja and Senanayake. But, Manuja_Senanayake, ManujaSenanayake, manujasenanayake, manuja152, etc are allowed.

Question 21

Which of the following tags can be used to produce an output with one or more stings?

A	str()
B	strings()
C	echo()
D	command()
E	print()

Question 22

PHP can be installed on many different operating systems.

A	No, it can only be installed on Linux servers.
B	No, it can only be installed on Windows Servers with IIS support.
C	Yes, it can be installed on Unix, Linux, Apple and Windows operating systems.
D	No, it can be installed on any server, but cannot be installed on non-server units.

Question 22 Explanation:

The reason why PHP is very popular, because it is fairly easy language to learn and it can be installed on many different platforms.

Question 23

What is fundamentally (in other words, by default) wrong with the following PHP code? (Choose the most suitable answer!)

A	The commenting tags /* and */ are in backwards order.
B	The start and end should have ?php and ? tags
C	There is no output command for the operation hence the script is useless.
D	The "php" at the start should be capitalized to "PHP"

Question 23 Explanation:

I asked for the most suitable because you can modify the php.ini file to accept the current tags as valid. However, by default it is invalid.

Question 24

PHP syntax can be compared to which of the following programing languages?

A	VisualBasic
B	Java
C	C#
D	ASP.net

Question 24 Explanation:

...and they are also similar to Perl.

Question 25

Imagine the following variable inside a php function.
$name = "Sanuja Senanayake";
Is it a valid variable name?

A	No, because you cannot use an undefined arbitrary words in variables. PHP won't known what is Sanuja Senanayake.
B	Yes
C	Yes, but it is a print statement, not a variable.
D	No, because you cannot have white space (space) inside a variable name

Question 26

Which of the following can be used to communicate image width?

A	imagesw()
B	imagesy()
C	imageswidth()
D	imagesx()

Question 27

What is PHP stand for?

A	Processed Hypertext Prone
B	Hypertext Preprocessor
C	Preloaded Hypertext Programming
D	Preconfigured Hypertext Programming

Question 28

Every programming language have a commenting system. You can start a comment on a PHP source code by using /*.

A	False
B	True

Question 28 Explanation:

You may also use //

Question 29

This module is used in PHP for image function.

A	GD Library
B	GB Library
C	GU Library
D	PHP-img Library

Question 30

What does the following code do (assuming it is written in PHP)?

$LoveJam=fopen("sanuja.txt","r");

A	It opens the file sanuja.text and enters LoveJam as a variable code.
B	It opens the file sanuja.text in read only mode.
C	It opens the file sanuja.text and enters LoveJam as a text string.
D	It opens the file sanuja.text and assign it to variable fopen.

Once you are finished, click the button below. Any items you have not completed will be marked incorrect. Get Results

There are 30 questions to complete.

←

List

→

Return

Shaded items are complete.

1	2	3	4	5
6	7	8	9	10
11	12	13	14	15
16	17	18	19	20
21	22	23	24	25
26	27	28	29	30
End

Return

CSS and HTML Quiz

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Some questions have hints and explanations. Click Start to begin.

Start

Congratulations - you have completed CSS and HTML Quiz.

You scored %%SCORE%% out of %%TOTAL%%.

Your performance has been rated as %%RATING%%

Your answers are highlighted below.

Question 1

How do you disable the text wrapping?

A	text-wrap:black;
B	white-space:nowrap;
C	wrap:none;
D	white-space:blank;

Question 2

Which language primarily should be used for styling a mobile version of a large scale website?

A	MySQL
B	PHP
C	CSS
D	JavaScript
E	HTML

Question 3

What is CSS stand for?

A	Cascading Style Sheets
B	Computer Style Sheets
C	Cheat Style Sheets
D	Casting Style Sheets

Question 4

What is the difference between tag br and tag p?

A	They are the same. They create a new paragraph.
B	They are different. The br tag creates a new line and p tag creates a new paragraph.
C	They are the same. They move the data to the next line.
D	They are different. The br tag creates a new paragraph while the p tag creates a new line.

Question 5

If you entered a code at the end of a CSS file, but you want to force the program to run it no matter what, what command must be added?

A	primary!
B	always!
C	important!
D	dominate!

Question 6

How do you combine two different .css files to create a single entity?

A	By using functions_css("file_url_here") at the top of the .php file.
B	By using the $css_file("file_url_here') in one of the .css files.
C	By using the @import url("file_url_here") in one of the .css files.
D	You cannot combine two different style sheets.
E	By saving both files with the same name but one of them as .css and the other as .css2 extinctions.

Question 7

Instead of having a .css separate file, can a CSS code be written into the HTML file itself?

A	No
B	Yes

Question 7 Explanation:

But it is not ideal way to code.

Question 8

It is better to load all CSS codes in a single style file than to load separate CSS files for different elements on a web page.

A	False
B	True

Question 9

The pseudo-elements in CSS 3 and up are added after what character?

A	:
B	%
C	&
D	/
E	?

Question 9 Explanation:

You can also use ::

Question 10

What does HTML stand for?

A	Hash Tag Markup Language
B	Hyper Text Markup Language
C	Hash Text Markup Language
D	Hyperlinks and Text Markup Language

Question 11

Can you make a heading tag bold, italic and underline?

A	Yes
B	No

Question 11 Explanation:

This is a title heading.

Question 12

How many title (heading) tags are there?

A	3
B	1
C	2
D	4

Question 12 Explanation:

h1, h2 and h3

Question 13

CSS can reduce the server load and improve the performance of the website because...

A	...it can take over some of the php.ini functions.
B	...a single style sheet can be loaded for all subsequent pages.
C	...it is a server side programming language.
D	...it can take over heavy loads off of MySQL databases.

Question 14

In CMS programs like Drupal and WordPress, what is the most effective method to apply a style only to a single page/post?
(Without creating a separate style sheet.)

A	.WHAT_EVER_CODE_ELEMENT_TO_BE_MOD .POST_ID { VARIABLE:ACTION; }
B	.POST_ID .WHAT_EVER_CODE_ELEMENT_TO_BE_MOD { VARIABLE:ACTION; }
C	.WHAT_EVER_CODE_ELEMENT_TO_BE_MOD { VARIABLE:ACTION; POST_ID }
D	.WHAT_EVER_CODE_ELEMENT_TO_BE_MOD { POST_ID VARIABLE:ACTION; }

Question 14 Explanation:

Here is an article I wrote, Resolving CSS conflicts.

Question 15

What other tag can be use in addition to the tag i to italicized text?

A	ty
B	ita
C	br
D	em

Question 16

In CSS, what is the difference between .sanuja {something here} and #sanuja {something here}?

A	First one is used to control all elements with id=sanuja. Second one is used to control a single element with class=sanuja
B	The second one is no longer in use. All current (as of MAY-2013) versions of CSS use "dot" version
C	They are identical and will behave the same.
D	The first one is used to control an element name "sanuja". The second one is an invalid code in CSS.

Once you are finished, click the button below. Any items you have not completed will be marked incorrect. Get Results

There are 16 questions to complete.

←

List

→

Return

Shaded items are complete.

1	2	3	4	5
6	7	8	9	10
11	12	13	14	15
16	End

Return

PHP and MySQL Quiz

CSS and HTML Quiz

This is a title heading.

Print/Share:

Standing on the shoulders of giants