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

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

Question 2

Which of the following is not true about MySQL?

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

Question 3

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	Yes, it can be installed on Unix, Linux, Apple and Windows operating systems.
C	No, it can only be installed on Windows Servers with IIS support.
D	No, it can only be installed on Linux servers.

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

This module is used in PHP for image function.

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

Question 5

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

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

Question 5 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 6

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

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

Question 7

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

A	C#
B	ASP.net
C	VisualBasic
D	Java

Question 7 Explanation:

...and they are also similar to Perl.

Question 8

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

A	True
B	False

Question 8 Explanation:

You may also use //

Question 9

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

Question 10

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

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 12

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

Question 13

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

Question 14

What is PHP stand for?

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

Question 15

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

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

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

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

Question 18

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 19

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

Question 20

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

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

Question 21

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

A	False
B	True

Question 22

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

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

Question 23

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

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

Question 24

Can the PHP pull data from a SQL database?

A	No
B	Yes

Question 25

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

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

Question 26

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

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

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

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

Question 28

How many variables a single function can hold?

A	2
B	1
C	Unlimited
D	5

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

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

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

Question 30

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

A	HTML
B	Ruby
C	Java
D	C#

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

How many title (heading) tags are there?

A	1
B	2
C	4
D	3

Question 2 Explanation:

h1, h2 and h3

Question 3

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	They are identical and will behave the same.
C	First one is used to control all elements with id=sanuja. Second one is used to control a single element with class=sanuja
D	The first one is used to control an element name "sanuja". The second one is an invalid code in CSS.

Question 4

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

A	ty
B	br
C	em
D	ita

Question 5

How do you disable the text wrapping?

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

Question 6

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 7

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 heavy loads off of MySQL databases.
C	...a single style sheet can be loaded for all subsequent pages.
D	...it can take over some of the php.ini functions.

Question 8

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

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

Question 9

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

A	HTML
B	MySQL
C	PHP
D	CSS
E	JavaScript

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 does HTML stand for?

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

Question 12

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

Question 13

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

Question 13 Explanation:

Here is an article I wrote, Resolving CSS conflicts.

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

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

A	No
B	Yes

Question 15 Explanation:

But it is not ideal way to code.

Question 16

What is CSS stand for?

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

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