Connecting PHP and MYSQL Practice Test

12th Standard Computer Applications — Connecting PHP and MYSQL: Online Practice Test

Pick how many questions you want and set a time limit, then start. You'll get your score at the end with the correct answer and an explanation for every question. Free, in Tamil and English — 25 questions available.

Set up your test

Number of questions

Time limit

Time remaining00:00

Which is the correct function to execute the SQL queries in PHP ?

A.mysqli_query("Connection Object","SQL Query") B.query("Connection Object","SQL Query") C.mysql_query("Connection Object","SQL Query") D.mysql_query("SQL Query")

Which is the correct function Closing Connection in PHP ?

A.mysqli_close("Connection Object"); B.close("Connection Object"); C.mysql_close("Connection Object"); D.mysqli_close("Database Object");

Which is the correct function to establish Connection in PHP ?

A.mysqli_connect("Server Name ","User Name","Password","DB Name"); B.connect("Server Name ","User Name","Password","DB Name"); C.mysql_connect("Server Name ","User Name","Password","DB Name"); D.mysqli_connect ("Database Object");

Which is the not a correct MySQL Function in PHP ?

A.Mysqli_connect() Function B.Mysqli_close() Function C.mysqli_select_data() Function D.mysqli_affected_rows() Function

How many parameter are required for MYSQLi connect function in PHP ?

A.2 B.3 C.4 D.5

How many parameter are required for MYSQLi query function in PHP ?

A.2 B.3 C.4 D.5

How many parameter are required for MYSQLi Close function in PHP ?

A.1 B.2 C.3 D.5

Which version of PHP supports MySQLi fuctions ?

A.Version 2.0 B.Version 3.0 C.Version 4.0 D.Version 5.0

According to the points to remember, what percentage of websites has been built using PHP and MySQL?

A.50% B.60% C.70% D.80%

Q10

Which PHP function is used to find the number of rows returned from a MySQL query execution?

A.mysqli_num_rows() B.mysqli_affected_rows() C.mysqli_fetch_array() D.mysqli_connect_error()

Q11

Which PHP function is used to retrieve the descriptive error message from the last connection error in MySQLi?

A.mysqli_error() B.mysqli_connect_error() C.mysqli_connect_errno() D.mysqli_get_error()

Q12

In which year was the survey conducted that estimated approximately 544 million websites were running the PHP stack?

A.2015 B.2016 C.2018 D.2020

Q13

Which alternative version of PHP or compiler did Facebook develop to turn its PHP code into native C++ code?

A.HipHop's HPHP'c B.PHP-to-C++ Transpiler C.FaceCompiler D.C++ PHP Engine

Q14

Which of the following is NOT listed as a PHP software framework in the textbook?

A.Symfony B.Laravel C.PRADO D.Django

Q15

What is the purpose of the mysqli_num_rows() function in a PHP MySQLi script?

A.To count the number of columns in a table B.To get the number of rows returned by a query C.To fetch a specific database row D.To list all databases in the server

Q16

Which function is used in PHP to fetch a query result row as an associative and numeric array?

A.mysqli_fetch_array() B.mysqli_get_row() C.mysqli_result_fetch() D.mysqli_data_seek()

Q17

In the textbook connection script, which function is used to terminate program execution and display an error if the database connection fails?

A.stop() B.die() C.exit_connection() D.terminate()

Q18

Which of the following database management systems is NOT mentioned as a Relational Database Management System (RDBMS) in the textbook?

A.Oracle B.IBM DB2 C.MongoDB D.Microsoft SQL Server

Q19

Which PHP function is used to retrieve the specific error code from the last database connection attempt?

A.mysqli_connect_error() B.mysqli_connect_errno() C.mysqli_get_error_code() D.mysqli_connect_code()

Q20

What percentage of websites are built using the combination of PHP and MySQL according to the textbook?

A.50% B.60% C.70% D.80%

Q21

In the mysqli_connect() function, which parameter represents the fourth argument in the parameter list?

A.Server Name B.User Name C.Password D.Database Name

Q22

Which framework mentioned in the textbook is designed to promote rapid application development (RAD) for PHP?

A.Django B.Yii Framework C.Spring Boot D.Flask

Q23

What is the primary purpose of the MySQLi extension introduced in PHP version 5.0.0?

A.To design client-side web layouts B.To give access to the MySQL database C.To compile C++ code into HTML D.To manage local server configurations

Q24

In the program examples of the textbook, which variable is typically used to store the connection object returned by mysqli_connect()?

A.$servername B.$result C.$conn or $connection D.$sql_stmt

Q25

Which SQL select query statement is assigned to the variable in the Chapter 9 practical program example to retrieve contacts?

A.SELECT ALL FROM my_contacts B.SELECT * FROM my_contacts C.GET * FROM my_contacts D.FETCH * FROM my_contacts

More for this chapter

About this Connecting PHP and MYSQL test

This free online practice test covers Connecting PHP and MYSQL from the 12th Standard Computer Applications (Samacheer Kalvi) syllabus. Choose the number of questions and an optional time limit, then answer and submit — everything is checked in your browser, with the correct answers and a worked explanation shown at the end. For the full solutions to every question in this set, see the solved MCQs page.

More chapters in Computer Applications

View all