Connecting PHP and MYSQL Model Question Paper

12th Standard EM

    Reg.No. :
  •  
  •  
  •  
  •  
  •  
  •  

Computer Applications

Time : 01:30:00 Hrs
Total Marks : 50
    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. How many parameter are required for MYSQLi connect function in PHP ?

    (a)

    2

    (b)

    3

    (c)

    4

    (d)

    5

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

    (a)

    2

    (b)

    3

    (c)

    4

    (d)

    5

  4. Which version of PHP supports MySQLi fuctions ?

    (a)

    Version 2.0

    (b)

    Version 3.0

    (c)

    Version 4.0

    (d)

    Version 5.0

  5. How many parameter are required for MYSQLiClosefunction in PHP ?

    (a)

    1

    (b)

    2

    (c)

    3

    (d)

    5

  6. 5 x 1 = 5
  7. RDMS stands_________

    ()

    Relational Database Management System

  8. SQL stands __________

    ()

    Structure query language

  9. MySQLi extension was introduced version__________

    ()

    5.0.0

  10. ______is extension in PHP scripting language which gives access to the MYSQL database.

    ()

    MySQLi

  11. Connect function requires ___________ number of parameters to connect to database server.

    ()

    four

  12. 2 x 2 = 4
  13. a) MySQL
    b) Java
    c) DB2
    d) Oracle

  14. a) TRUNCATE
    b) SELECT
    c) UPDATE
    d) INSERT

  15. 6 x 2 = 12
  16. What are the MySQLi function available PHP?

  17. Difference between Connection and Close function?

  18. What is Connection string?

  19. What is web Database?

  20. Define mysqli_affected_rows() Function.

  21. What is MySQLi?

  22. 3 x 3 = 9
  23. Write the Syntax for MySQLi Queries.

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

  25. Write MySQL Connection Syntax with example.

  26. 3 x 5 = 15
  27. Discuss in detail about MySQL functions with example.

  28. Explain MySQLi Queries with examples.

  29. Write a short note on paramet rs of mysqli_connect( ) function?

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

TN 12th Standard EM Computer Applications free Online practice tests

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

Write your Comment