New ! Computer Applications MCQ Practise Tests



Connecting PHP and MYSQL Model Questions

12th Standard

    Reg.No. :
  •  
  •  
  •  
  •  
  •  
  •  

Computer Applications

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

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

  3. _______is important to all computer and Internet related applications

    (a)

    Data

    (b)

    MySQL

    (c)

    PHP

    (d)

    None of these

  4. Which of the following is not an RDBMS?

    (a)

    Oracle

    (b)

    IBM DB2

    (c)

    Microsoft SQLSERVER

    (d)

    None of these

  5. Connection to the Database Server machine via PHP scripting language using _______ Function

    (a)

    mysqlLaffected_rows( )

    (b)

    myvscu connect_.erron( )

    (c)

    mysqlLfetch_assoc( )

    (d)

    mysqli_connect( )

  6. 6 x 2 = 12
  7. Define mysqli_connect_error() Function

  8. Define mysqli_affected_rows() Function.

  9. Expand RDBMS.

  10. What are the major operations of database?

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

  12. What is the main goal of MySQL and PHP connectivity?

  13. 6 x 3 = 18
  14. Differentiate mysqli_affected_rows( ) Function and mysqli_fetch_assoc( ) Function.

  15. Write MySQL Connection Syntax with example.

  16. Write a note PHP MySQL database connection.

  17. Wha is MySQL?

  18. What is the main goal of MySQL and PHP connectivity?

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

  20. 3 x 5 = 15
  21. Discuss in detail about MySQL functions with example.

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

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

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

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

Write your Comment