KEMBAR78
Module 3 Database | PDF
Scribd
Upload
41 views2 pages

Module 3 Database

The document contains exercises from a computer/cyber textbook module on databases. It includes fill in the blank, true/false, matching, multiple choice and short answer questions testing knowledge of database concepts like SQL, RDBMS, DDL, DCL and the ER model.

Uploaded by

Aadil Muhammed Saji
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
41 views2 pages

Module 3 Database

The document contains exercises from a computer/cyber textbook module on databases. It includes fill in the blank, true/false, matching, multiple choice and short answer questions testing knowledge of database concepts like SQL, RDBMS, DDL, DCL and the ER model.

Uploaded by

Aadil Muhammed Saji
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

COMPUTER / CYBER TEXT BOOK EXERCISES 2021-22

GRADE: VII Module 3 - DATABASE


__________________________________________________________________________

I. Fill in the blanks:


1. Database
2. Alter-add
3. Records / Tuples
4. Oracle Corporation
5. Entity

II. State True / False:


1. False
2. False
3. True
4. True
5. False

III. Match the following:


1. RDBMS - d. MySQL
2. Relation - e. Table
3. DDL - a. Create
4. DCL - b. Grant
5. MongoDB - c. NoSQL

IV. Multiple choice questions:


1. d. All of the above
2. d. Delete
3. c. Column
4. a. SQL
5. b. Use <database name>

1
V. Answer in one word or one sentence:
1. mysql -u root -p
2. Structured Query Language
3. a) RDBMS b) Object Oriented DBMS c) Network DBMS d) Hierarchical DBMS e) NoSQL
4. sudo apt-get install mysql-server
5. Entity-Relationship Model ( ER Model)

VI. Answer the following:


1. What is a database?
Ans: Database is a collection of information organized in such a way that a computer program can
quickly select desired pieces of data.
2. Brief the history of MySQL.
Ans: MySQL is the world’s most used open source RDBMS owned by ORACLE. It is named after
cofounder Michael Widenius’ daughter, My.
3. What is ER model?
Ans: Entity Relationship Model represents data as Entities, Attributes and Relations between entities.
A relation (table) consists of unique attributes (columns/fields) and tuples (rows/records).
4. What is DDL?
Ans: Data Definition Language (DDL) is used to define the database structure or schema. It includes
Create, Alter, Drop and Truncate commands.
5. What is DCL?
Ans: Data Control Language (DCL) is used to create roles and permissions and to control access to
database by securing it. It includes Grant and Revoke commands.
______________________________________________________________________________________

You might also like