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

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

Question 2

This module is used in PHP for image function.

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

Question 3

What is the purpose of print_r() variable?

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

Question 4

What is PHP stand for?

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

Question 5

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

A	Java
B	ASP.net
C	C#
D	VisualBasic

Question 5 Explanation:

...and they are also similar to Perl.

Question 6

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 V
D	At position W
E	At position Z

Question 7

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

Question 8

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

A	Java
B	HTML
C	C#
D	Ruby

Question 9

Can the PHP pull data from a SQL database?

A	No
B	Yes

Question 10

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	False, the plugin for PHP will be automatically installed when the client unit access a PHP based site.
C	True, but ONLY for mobile devices.
D	False, PHP is a server side processing language with no end user plugins.

Question 10 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 11

How many variables a single function can hold?

A	Unlimited
B	5
C	2
D	1

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

Question 13

PHP can be installed on many different operating systems.

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

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

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	php.exe
D	FileName.php

Question 15

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

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

Question 16

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

A	False
B	True

Question 17

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

Question 18

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

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

Question 19

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

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

Question 20

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

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

Question 21

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

Question 21 Explanation:

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

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

Question 23

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

A	True
B	False

Question 23 Explanation:

You may also use //

Question 24

Which of the following is not true about MySQL?

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

Question 25

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	No, each website will get it's own set of PHP databases and the PHP install must be independent of each other.
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 26

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 27

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

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

Question 28

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

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

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

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 "php" at the start should be capitalized to "PHP"
C	The start and end should have ?php and ? tags
D	There is no output command for the operation hence the script is useless.

Question 29 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 30

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()

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

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

Question 3

What does HTML stand for?

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

Question 4

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

A	JavaScript
B	PHP
C	MySQL
D	CSS
E	HTML

Question 5

How do you disable the text wrapping?

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

Question 6

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	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 second one is no longer in use. All current (as of MAY-2013) versions of CSS use "dot" version
D	They are identical and will behave the same.

Question 7

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 8

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	...it is a server side programming language.
C	...a single style sheet can be loaded for all subsequent pages.
D	...it can take over heavy loads off of MySQL databases.

Question 9

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

A	By using the $css_file("file_url_here') in one of the .css files.
B	By using the @import url("file_url_here") in one of the .css files.
C	By using functions_css("file_url_here") at the top of the .php file.
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 10

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

A	Yes
B	No

Question 10 Explanation:

This is a title heading.

Question 11

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 move the data to the next line.
C	They are the same. They create a new paragraph.
D	They are different. The br tag creates a new paragraph while the p tag creates a new line.

Question 12

What is CSS stand for?

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

Question 13

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

A	Yes
B	No

Question 13 Explanation:

But it is not ideal way to code.

Question 14

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

A	em
B	ty
C	br
D	ita

Question 15

How many title (heading) tags are there?

A	1
B	2
C	3
D	4

Question 15 Explanation:

h1, h2 and h3

Question 16

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

A	:
B	/
C	%
D	?
E	&

Question 16 Explanation:

You can also use ::

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