" /> -->

Connecting PHP and MYSQL Book Back Questions

12th Standard EM

Reg.No. :
•
•
•
•
•
•

Computer Applications

Time : 00:45:00 Hrs
Total Marks : 30
5 x 1 = 5
1. Which one of the following statements instantiates the mysqli class?

(a)

mysqli = new mysqli()

(b)

mysqli = new mysqli()

(c)

mysqli - > new.mysqli()

(d)

mysqli - > new.mysqli()

2. which one is correct way, we can retrieve the data in the result set of MySQL using PHP?

(a)

mysql_fetch_row.

(b)

mysql_fetch_array

(c)

mysql_fetch_object

(d)

All the above

3. How Can we Create a Database Using PHP and MySQL?

(a)

mysqli_create_db(“Database Name”)

(b)

mysqli_create_db(“Data”)

(c)

create_db(“Database Name”)

(d)

create_db(“Data”)

4. 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

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

(a)

2

(b)

3

(c)

4

(d)

5

6. 4 x 2 = 8
7. What is web Database?

8. What is mysqli_fetch_assoc() Function?

9. Define mysqli_connect_error() Function

10. Define mysqli_affected_rows() Function.

11. 4 x 3 = 12
12. Write is the purpose of MySQLi function available.

13. Differentiate mysqli_affected_rows( ) Function and mysqli_fetch_assoc( ) Function.

14. Write MySQL Connection Syntax with example.

15. Write a note PHP MySQL database connection.

16. 1 x 5 = 5
17. Explain MySQLi Queries with examples.