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

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

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

Question 2

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

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

Question 2 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 3

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

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

Question 4

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 username
B	host and database
C	database and password
D	database and host
E	username and password

Question 5

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	array
B	data set
C	loop
D	condition

Question 6

What is PHP stand for?

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

Question 7

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

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

Question 8

Can the PHP pull data from a SQL database?

A	Yes
B	No

Question 9

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

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

Question 10

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 Y
B	At position X
C	At position Z
D	At position V
E	At position W

Question 11

What is the purpose of print_r() variable?

A	It is the human-readable information print out.
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 used to pass the information from previous function to the next known as "r".

Question 12

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

A	Java
B	ASP.net
C	C#
D	VisualBasic

Question 12 Explanation:

...and they are also similar to Perl.

Question 13

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

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

Question 13 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 14

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

A	True
B	False

Question 15

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

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

Question 16

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

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

Question 17

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, as long as each website have the access to the install.
D	Yes, but both websites MUST share the same database files.

Question 18

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

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

Question 18 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 19

PHP can be installed on many different operating systems.

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

Question 19 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 20

How many variables a single function can hold?

A	2
B	1
C	5
D	Unlimited

Question 20 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 21

This module is used in PHP for image function.

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

Question 22

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 I and II
B	at II and III
C	at III and IV
D	at I and IV

Question 23

Which of the following is not true about MySQL?

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

Question 24

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()
C	mysql_affected_rows() Hint: Uh... this is the old one! Oops!
D	mysqli():affected_rows()

Question 25

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 25 Explanation:

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

Question 26

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

A	True
B	False

Question 26 Explanation:

You may also use //

Question 27

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 28

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

A	HTML
B	Java
C	Ruby
D	C#

Question 29

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

A	False
B	True

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 text string.
B	It opens the file sanuja.text and assign it to variable fopen.
C	It opens the file sanuja.text in read only mode.
D	It opens the file sanuja.text and enters LoveJam as a variable code.

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

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	.POST_ID .WHAT_EVER_CODE_ELEMENT_TO_BE_MOD { VARIABLE:ACTION; }
B	.WHAT_EVER_CODE_ELEMENT_TO_BE_MOD .POST_ID { 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 1 Explanation:

Here is an article I wrote, Resolving CSS conflicts.

Question 2

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

A	The first one is used to control an element name "sanuja". The second one is an invalid code in CSS.
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	First one is used to control all elements with id=sanuja. Second one is used to control a single element with class=sanuja

Question 3

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

A	JavaScript
B	CSS
C	MySQL
D	HTML
E	PHP

Question 4

What does HTML stand for?

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

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	always!
B	important!
C	dominate!
D	primary!

Question 6

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

A	:
B	%
C	&
D	/
E	?

Question 6 Explanation:

You can also use ::

Question 7

How many title (heading) tags are there?

A	4
B	3
C	2
D	1

Question 7 Explanation:

h1, h2 and h3

Question 8

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 @import url("file_url_here") in one of the .css files.
C	By using the $css_file("file_url_here') in one of the .css files.
D	By saving both files with the same name but one of them as .css and the other as .css2 extinctions.
E	You cannot combine two different style sheets.

Question 9

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

A	No
B	Yes

Question 9 Explanation:

But it is not ideal way to code.

Question 10

What is CSS stand for?

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

Question 11

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

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

Question 12

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 13

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

A	No
B	Yes

Question 13 Explanation:

This is a title heading.

Question 14

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

A	ita
B	br
C	ty
D	em

Question 15

What is the difference between tag br and tag p?

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

Question 16

How do you disable the text wrapping?

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

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