New ! Computer Applications MCQ Practise Tests



Connecting PHP and MYSQL Book Back Questions

12th Standard

    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.

*****************************************

Reviews & Comments about 12th Computer Applications Unit 9 Connecting PHP and MYSQL Book Back Questions

Write your Comment