Page 71 - Code Craft Computer-8

Flashback Time

¨ As you know, a DBMS arranges all your data in an orderly manner so that you can retrieve
information easily whenever you need it.
¨ A database is a collection of data that is organized for easy access, retrieval and management of
its contents.
¨ A Database Management System (DBMS) is a software package that provides software
programs to control the creation, maintenance and use of a database.
¨ There are four major types of DBMS. These are– Relational database, Object-oriented
database, Hierarchical database and the Network database.
¨ MySQL is the most popular Open-Source Relational SQL database management system.
¨ MySQL is one of the best RDBMS being used for developing web-based software
applications. MySQL is a fast, easy-to-use RDBMS being used for many small and big
businesses.
¨ mysqli_connect method and its parameters are used to establish a connection with the
database.
¨ mysqli_select_db method is used to connect to the database. This method takes two
parameters, connection name and database name.
¨ mysqli_query method will execute the query with the help of the conection object.
¨ mysqli_fetch_row method is used to fetch the records returned by the query.

Knowledge Check

A. Mark the correct response.

1. Multiple-mismatching copies of the same data are known as
OMR Sheet
data ____________.
Use only blue/black ball
a. Inconsistency b. Redundancy
pen to fill the circles. It
c. Both a and b d. None of these should be darkened
completely and properly.
2. Data ____________ means duplication of data. Wrong methods

a. Redundancy b. Security Correct method
c. Both a and b d. None of these

3. ____________ software is available for personal computers, 1. a b c d
workstations and large mainframe systems.
a. Object-oriented b. DBMS 2. a b c d

c. Both a and b d. None of these
3. a b c d
4. ____________ method is used to connect to the database.

a. mysqli_select_db b. mysqli_connect 4. a b c d
c. mysqli_query d. mysqli_fetch_row

71