New ! Computer Applications MCQ Practise Tests



Connecting PHP and MYSQL 1 Mark Creative Question Paper With Answer Key

12th Standard

    Reg.No. :
  •  
  •  
  •  
  •  
  •  
  •  

Computer Applications

Time : 00:20:00 Hrs
Total Marks : 15

     Multiple Choice Question

    15 x 1 = 15
  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. _______is important to all computer and Internet related applications

    (a)

    Data

    (b)

    MySQL

    (c)

    PHP

    (d)

    None of these

  5. Which of the following is not an RDBMS?

    (a)

    Oracle

    (b)

    IBM DB2

    (c)

    Microsoft SQLSERVER

    (d)

    None of these

  6. 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( )

  7. _______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( )

  8. _______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( )

  9. A) DB2 - 1)Connect database
    B) INSERT - 2)RDBMS
    C) Mysqli_close( ) Function - 3)One of the major operation
    D) Mysqli_connect( ) Function - 4)Close an existing opened database
    (a)

    1 2 3 4

    (b)

    4 3 2 1

    (c)

    2 3 4 1

    (d)

    2 4 3 1

  10. A) DB2 - 1)Open source
    B) SQL SERVER - 2)IBM
    C) MySQL - 3)Microsoft
    D) Oracle - 4)Oracle Corporation
    (a)

    2 3 1 4

    (b)

    4 3 2 1

    (c)

    2 3 4 1

    (d)

    2 4 3 1

  11. A)MysqlLcioseO Function - 1) Four parameter
    B) MysqlLconnectO Functio - 2)Two parameters
    C)mysqli_ query Function - 3) No parameters
    D)mysqli_connect_errpr( ) - 4)One Parameter
    (a)

    2 3 1 4

    (b)

    4 3 2 1

    (c)

    2 3 4 1

    (d)

    4 1 2 3

  12. A)Mysqli_ciose( ) Function - 1) Fetches a result row
    B) Mysqli_connect( ) Function - 2)To execute the SQL query
    C) mysqli_query( ) Function - 3) To connect to database server
    D) mysqli_fetch_assoc( ) - 4)To close an existing opened database
    (a)

    2 3 1 4

    (b)

    4 3 2 1

    (c)

    2 3 4 1

    (d)

    4 1 2 3

  13. A) mysqli affected rows( ) - Returns the number of affected rows
    B) mvsqti connect error( ) - Returns the error description
    C) MySQL MAX Function - Select the highest value for a certain column
    D) MySQL MIN Function - Select the lowest value for a certain column
    (a)

    2 3 1 4

    (b)

    1 2 3 4

    (c)

    2 3 4 1

    (d)

    4 1 2 3

  14. Which growths of data need a secure and convenient environment to store and manipulate autonomously?

    (a)

    Numerous

    (b)

    Large

    (c)

    Enormous

    (d)

    Small

  15. In which Database Management System all features are available?

    (a)

    Logical

    (b)

    Arithmetic

    (c)

    Relational

    (d)

    None of these

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

Reviews & Comments about 12th Standard Computer Applications English Medium - Connecting PHP and MYSQL 1 Mark Creative Question Paper and Answer Key 2022 - 2023

Write your Comment