New ! Computer Applications MCQ Practise Tests



Connecting PHP and MYSQL Model Question Paper 1

12th Standard

    Reg.No. :
  •  
  •  
  •  
  •  
  •  
  •  

Computer Applications

Time : 01:00:00 Hrs
Total Marks : 50
    5 x 1 = 5
  1. 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

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

    (a)

    2

    (b)

    3

    (c)

    4

    (d)

    5

  3. Which version of PHP supports MySQLi fuctions ?

    (a)

    Version 2.0

    (b)

    Version 3.0

    (c)

    Version 4.0

    (d)

    Version 5.0

  4. _______IS a function, helps to execute the SQL query statements in PHP scripting language

    (a)

    mysqli_closet( )

    (b)

    mysqlLconnect_error( )

    (c)

    mysqli_query( )

    (d)

    mysqli_connect( )

  5. _______Function is used to close an existing opened database connection between PHP scripting and MySQL Database Server.

    (a)

    mysqli_close( )

    (b)

    mysqli_connect error( )

    (c)

    mysqli_query( )

    (d)

    mysqli_connect( )

  6. 5 x 2 = 10
  7. What are the MySQLi function available PHP?

  8. What is web Database?

  9. What is mysqli_fetch_assoc() Function?

  10. What is MySQLi?

  11. How many parameters to connect to database server, in Mysqli_connect( ) Function?

  12. 5 x 3 = 15
  13. Write the Syntax for MySQLi Queries.

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

  15. Write a note PHP MySQL database connection.

  16. What is the use of SQL statements in PHP?

  17. How the connection will get success in mysqli_connect( ) function?

  18. 4 x 5 = 20
  19. Discuss in detail about MySQL functions with example.

  20. Explain in details types of MySQL connection method in PHP.

  21. Explain MySQLi Queries with examples.

  22. Write a short note on parameters of mysqli_connect( ) function?

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

Reviews & Comments about 12th Computer Applications - Connecting PHP and MYSQL Model Question Paper 1

Write your Comment