InstaQB

Home
Institutions
- Institutions
  
  Polytechnic Colleges
  
  Medical Colleges
  
  Arts & Science Colleges
  
  Universities
  
  Engineering Colleges
  
  Agricultural Colleges
  
  Research Institute
  
  Law Colleges
  
  Audiology and Speech Colleges
  
  Business & Management colleges
  
  Nursing colleges
  
  Hotel Management institutes
  
  Aeronautical Colleges
  
  Bachelor's Degree
Syllabus
Courses
Stateboard
- 12th Standard English Medium
  
  Maths
  
  Physics
  
  Chemistry
  
  Biology
  
  Computer Science
  
  Business Maths
  
  Economics
  
  Commerce
  
  Accountancy
  
  History
  
  Computer Applications
  
  Computer Technology
  12th Standard Tamil Medium
  
  உயிரியல்
  
  கணினி பயன்பாடுகள்
  
  கணினி அறிவியல்
  
  வணிகக் கணிதம்
  
  வணிகவியல்
  
  பொருளியல்
  
  கணிதவியல்
  
  வேதியியல்
  
  இயற்பியல்
  
  கணினி தொழில்நுட்பம்
  
  வரலாறு
  
  கணக்குப்பதிவியல்
  11th Standard English Medium
  
  Maths
  
  Commerce
  
  Economics
  
  Biology
  
  Business Maths
  
  Accountancy
  
  Computer Science
  
  Physics
  
  Chemistry
  
  Computer Applications
  
  History
  
  Computer Technology
  
  Bio - Zoology
  11th Standard Tamil Medium
  
  கணிதவியல்
  
  உயிரியல்
  
  பொருளியல்
  
  இயற்பியல்
  
  வேதியியல்
  
  வணிகக் கணிதம்
  
  கணினி அறிவியல்
  
  கணக்குப்பதிவியல்
  
  வணிகவியல்
  
  கணினி பயன்பாடுகள்
  10th Standard English Medium
  
  Mathematics
  
  Science
  
  Social Science
  
  9th Standard English Medium
  
  Mathematics
  
  Science
  
  Social Science
  
  8th Standard English Medium
  
  Mathematics
  
  Science
  
  Social Science
  7th Standard English Medium
  
  Mathematics
  
  Science
  
  Social Science
ICSE/ISC
- Class XII
  
  Mathematics
  
  Physics
  
  Accountancy
  
  Biology
  
  History
  
  Geography
  
  Psychology
  
  chemistry
  
  Economics
  
  Computer Science
  
  Political Science
  
  Business Studies
  Class XI
  
  Accountancy
  
  Chemistry
  
  Mathematics
  
  Biology
  
  Geography
  
  Physics
  
  History
CBSE
- 12Th Standard
  
  Physics
  
  Chemistry
  
  Maths
  
  Biology
  
  History
  
  Economics
  
  Commerce
  
  Geography
  
  Socialogy
  
  Business Studies
  
  Computer Science
  
  Biotechnology Class
  
  Political Science
  
  Home Science
  11Th Standard
  
  Physics
  
  Chemistry
  
  Maths
  
  Biology
  
  History
  
  Economics
  
  Commerce
  
  Socialogy
  
  Business Studies
  
  Geography
  
  Home Science
  
  Computer Science
  
  Biotechnology Class
  
  Political Science
  10Th Standard
  
  Physics
  
  Chemistry
  
  Biology
  
  Mathematics
  
  Economics
  
  Geography
  
  History & Civics
  
  Computer Application
  9Th Standard
  
  Physics
  
  Chemistry
  
  Biology
  
  mathematics
  
  Computer Application
  
  Economics
  
  Geography
  
  History & Civics

12th Computer Applications Weekly Test -3 ( Connecting PHP and MYSQL )

St. Britto Hr. Sec. School - Madurai

12th Computer Applications Weekly Test -3 ( Connecting PHP and MYSQL )-Aug 2020

Time : 1.00 Hours

Part - A

Multiple Choice Question - Answer All Question

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

1 2 3 4
4 3 2 1
2 3 4 1
2 4 3 1

Which of the following is not an RDBMS?

Oracle
IBM DB2
Microsoft SQLSERVER
None of these

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

2
3
4
5

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

2 3 1 4
4 3 2 1
2 3 4 1
4 1 2 3

which one is correct way, we can retrieve the data in the result set of MySQL using PHP?

mysql_fetch_row.
mysql_fetch_array
mysql_fetch_object
All the above

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

2 3 1 4
1 2 3 4
2 3 4 1
4 1 2 3

Which is the not a correct MySQL Function in PHP ?

Mysqli_connect() Function
Mysqli_close() Function
mysqli_select_data() Function
mysqli_affected_rows() Function

_______IS a function, helps to execute the SQL query statements in PHP scripting language

mysqli_closet( )
mysqlLconnect_error( )
mysqli_query( )
mysqli_connect( )

_______Function is used to close an existing opened database connection between PHP scripting and MySQL Database Server.

mysqli_close( )
mysqli_connect error( )
rnysqli_query( )
mysqli_connect( )

_______is important to all computer and Internet related applications

Data
MySQL
PHP
None of these

Which version of PHP supports MySQLi fuctions ?

Version 2.0
Version 3.0
Version 4.0
Version 5.0

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

2
3
4
5

Which is the correct function to execute the SQL queries in PHP ?

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

Which is the correct function to establish Connection in PHP ?

mysqli_connect(“Server Name “,”User Name”,”Password”,”DB Name”);
connect(“Server Name “,”User Name”,”Password”,”DB Name”);
mysql_connect(“Server Name “,”User Name”,”Password”,”DB Name”);
mysqli_connect (“Database Object”);

Which one of the following statements instantiates the mysqli class?

mysqli = new mysqli()
\($\)mysqli = new mysqli()
\($\)mysqli - > new.mysqli()
mysqli - > new.mysqli()

Part - B

Generic 2 - Answer All Question

What are the major operations of database?

What is Connection string?

Define mysqli_affected_rows() Function.

What is MySQLi?

Difference between Connection and Close function?

Expand RDBMS.

Give few examples of MySQLi Queries.

What is MySQLi function?

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

Define mysqli_connect_error() Function

Comment

Add Comment

Tamilnadu Stateboardszs - Class