New ! Computer Applications MCQ Practise Tests



  1. Home
  2. 12th Standard
  3. Computer Applications
  4. 12th Standard Computer Applications - Connecting PHP and MYSQL Model Question Paper

Updated 12th Standard Computer Applications Study Materials 2022-2023 Exams

12th Standard Computer Applications - Connecting PHP and MYSQL Model Question Paper Oct-16 , 2019

Connecting PHP and MYSQL

12th Standard Computer Applications - Connecting PHP and MYSQL Model Question Paper

Connecting PHP and MYSQL Model Question Paper

12th Standard

    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 MYSQLi Close function in PHP ?

    (a)

    1

    (b)

    2

    (c)

    3

    (d)

    5

    6. 5 x 1 = 5

  6. RDMS stands_________

    A PHP Error was encountered

    Severity: Warning

    Message: A non-numeric value encountered

    Filename: material/details.php

    Line Number: 1002

    ()

    Relational Database Management System

  7. SQL stands __________

    A PHP Error was encountered

    Severity: Warning

    Message: A non-numeric value encountered

    Filename: material/details.php

    Line Number: 1002

    ()

    Structure query language

  8. MySQLi extension was introduced version__________

    A PHP Error was encountered

    Severity: Warning

    Message: A non-numeric value encountered

    Filename: material/details.php

    Line Number: 1002

    ()

    5.0.0

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

    A PHP Error was encountered

    Severity: Warning

    Message: A non-numeric value encountered

    Filename: material/details.php

    Line Number: 1002

    ()

    MySQLi

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

    A PHP Error was encountered

    Severity: Warning

    Message: A non-numeric value encountered

    Filename: material/details.php

    Line Number: 1002

    ()

    four

    11. 2 x 2 = 4

  11. a) MySQL
    b) Java
    c) DB2
    d) Oracle

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

    13. 6 x 2 = 12

  13. What are the MySQLi function available PHP?

  14. Difference between Connection and Close function?

  15. What is Connection string?

  16. What is web Database?

  17. Define mysqli_affected_rows() Function.

  18. What is MySQLi?

    19. 3 x 3 = 9

  19. Write the Syntax for MySQLi Queries.

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

  21. Write MySQL Connection Syntax with example.

    22. 3 x 5 = 15

  22. Discuss in detail about MySQL functions with example.

  23. Explain MySQLi Queries with examples.

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

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

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

Write your Comment