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

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

A	False
B	True

Question 2

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

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

Question 3

How many variables a single function can hold?

A	1
B	5
C	Unlimited
D	2

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

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 5

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	No, because you cannot have white space (space) inside a variable name
D	Yes, but it is a print statement, not a variable.

Question 6

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

A	False
B	True

Question 6 Explanation:

You may also use //

Question 7

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

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

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

Question 8 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 9

Can the PHP pull data from a SQL database?

A	No
B	Yes

Question 10

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

A	C#
B	Java
C	HTML
D	Ruby

Question 11

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

Question 12

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	mysqli():affected_rows()
D	mysql():affected_rows()

Question 13

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

Question 14

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

A	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.
B	Yes, but both websites MUST share the same database files.
C	No, each website will get it's own set of PHP databases and the PHP install must be independent of each other.
D	Yes, as long as each website have the access to the install.

Question 15

This module is used in PHP for image function.

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

Question 16

PHP can be installed on many different operating systems.

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

Question 16 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 17

Which of the following is not true about MySQL?

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

Question 18

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

Question 19

What is PHP stand for?

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

Question 20

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 21

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

Question 22

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 23

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

A	VisualBasic
B	ASP.net
C	C#
D	Java

Question 23 Explanation:

...and they are also similar to Perl.

Question 24

What is the purpose of print_r() variable?

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

Question 25

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

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

Question 26

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

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

Question 27

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

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

Question 27 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 28

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	FileName.php
B	php.ini
C	php.exe
D	_.php

Question 29

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

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

Question 30

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

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

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

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

A	ty
B	ita
C	br
D	em

Question 2

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

Question 3

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	.WHAT_EVER_CODE_ELEMENT_TO_BE_MOD .POST_ID { VARIABLE:ACTION; }
C	.POST_ID .WHAT_EVER_CODE_ELEMENT_TO_BE_MOD { VARIABLE:ACTION; }
D	.WHAT_EVER_CODE_ELEMENT_TO_BE_MOD { VARIABLE:ACTION; POST_ID }

Question 3 Explanation:

Here is an article I wrote, Resolving CSS conflicts.

Question 4

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

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

Question 5

How do you disable the text wrapping?

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

Question 6

What does HTML stand for?

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

Question 7

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

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

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	True
B	False

Question 9

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

A	Yes
B	No

Question 9 Explanation:

But it is not ideal way to code.

Question 10

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

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

Question 11

What is CSS stand for?

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

Question 12

How many title (heading) tags are there?

A	2
B	3
C	1
D	4

Question 12 Explanation:

h1, h2 and h3

Question 13

What is the difference between tag br and tag p?

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

Question 14

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

A	:
B	/
C	%
D	&
E	?

Question 14 Explanation:

You can also use ::

Question 15

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

A	CSS
B	HTML
C	MySQL
D	JavaScript
E	PHP

Question 16

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

A	Yes
B	No

Question 16 Explanation:

This is a title heading.

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