Connecting PHP and MYSQL Additional Practice Test

12th Standard Computer Applications — Connecting PHP and MYSQL: Additional 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 — 15 questions available.

Set up your test

Number of questions

Time limit

Time remaining00:00

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

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

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

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

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

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

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

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

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

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

Q10

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%

Q11

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

Q12

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

Q13

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

Q14

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

Q15

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