Page 72 - Code Craft Computer-8

5. ____________ method will execute the query with the help of
the connection object.
a. mysqli_query b. mysqli_fetch_row 5. a b c d

c. mysqli_select_db d. mysqli_connect
6. There are ____________ major types of DBMS. 6. a b c d

a. Three b. Four
c . Five d. Six

B. Gap-fill exercise.

1. A _____ is a collection of data that is organized for easy access, retrieval and
management of its contents.
2. _______ is the most popular open-source Relational SQL database management system.
3. __________ method is used to fetch the records returned by the query.

4. __________ method and its parameters are used to establish a connection with the
database.

5. A database has one or more related ________ of data.
6. DBMS ensures _________ by storing data at one place and ensuring that there is no
duplication of data.

C. True and False assessment.
1. MySQL is a fast, easy-to-use RDBMS being used for many small and big businesses.

2. The mysqli_select_db method will execute the query with the help of the conection
object.
3. MySQL is very costly.

4. A database has one or more related tables of data.
5. Every table in a database has a key field which uniquely identifies the each record.

6. Relational database concepts are concurrency control, transactions, etc.
D. Give appropriate responses to the questions.

1. What do you mean by a database?
2. Define the term DBMS.

3. How many types of DBMS are there? Name them.
4. What is MySQL?

5. What is the use of mysqli_query method?
6. What is the use of mysqli_fetch_row method?

Analyt ical Skills

Write the steps to connect the web page to the database in the boxes given on the next page.

72
Computer-8