New ! Computer Applications MCQ Practise Tests



12th Standard Computer Applications Connecting PHP and MYSQL English Medium Free Online Test 1 Mark Questions with Answer Key 2020 - 2021

12th Standard

    Reg.No. :
  •  
  •  
  •  
  •  
  •  
  •  

Computer Applications

Time : 00:10:00 Hrs
Total Marks : 10

    Answer all the questions

    10 x 1 = 10
  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. Which is the correct function to execute the SQL queries in PHP ?

    (a)

    mysqli_query(“Connection Object”,”SQL Query”)

    (b)

    query(“Connection Object”,”SQL Query”)

    (c)

    mysql_query(“Connection Object”,”SQL Query”)

    (d)

    mysql_query(“SQL Query”)

  3. Which is the correct function to establish Connection in PHP ?

    (a)

    mysqli_connect(“Server Name “,”User Name”,”Password”,”DB Name”);

    (b)

    connect(“Server Name “,”User Name”,”Password”,”DB Name”);

    (c)

    mysql_connect(“Server Name “,”User Name”,”Password”,”DB Name”);

    (d)

    mysqli_connect (“Database Object”);

  4. How many parameter are required for MYSQLi connect function in PHP ?

    (a)

    2

    (b)

    3

    (c)

    4

    (d)

    5

  5. Which version of PHP supports MySQLi fuctions ?

    (a)

    Version 2.0

    (b)

    Version 3.0

    (c)

    Version 4.0

    (d)

    Version 5.0

  6. Which of the following is not an RDBMS?

    (a)

    Oracle

    (b)

    IBM DB2

    (c)

    Microsoft SQLSERVER

    (d)

    None of these

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

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

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

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

Reviews & Comments about 12th Standard Computer Applications Connecting PHP and MYSQL English Medium Free Online Test 1 Mark Questions with Answer Key 2020 - 2021

Write your Comment