Font size
WorksheetsDBMS Q1
Total questions: 18
Worksheet time: 15mins
According to the principles of database systems, the data is stored in such a way that it acquires lot less space as the redundant data has been removed before storage.
(a)
Is collection of interrelated data, stored in such a way so that a user can read, insert, update and delete the data efficiently.
(a)
It is software for storing and retrieving users’ data while considering appropriate security measures.
(a)
In 1960 this person designed the first DBMS system.
(a)
An operation of users of DBMS that allows the creation of table, table schema creation, removal of table definition etc.
(a)
DBMS allows users to fetch data from the database. What operation does this refers to?
(a)
This type of database, model data is organized in a tree-like structure. Usually in top-down or bottom-up format. Data is represented using a parent-child relationship.
(a)
A type of DBMS that is the most widely used DBMS model because it is one of the easiest. This model is based on normalizing data in the rows and columns of the tables.
(a)
A user of DBMS that is responsible for managing the entire DBMS system.
(a)
TRUE/FALSE: Flat File is prone to redundancy and integrity issues.
(a)
TRUE/FALSE: DBMS does not support complicated transactions.
(a)
TRUE/FALSE: DBMS reduces application development time.
(a)
TRUE/FALSE: DBMS can’t perform sophisticated calculations.
(a)
TRUE/FALSE: Object-Oriented Model uses classes as its structural design which display data within it.
(a)
It secures the data from unauthorized access as well as corrupt data insertions. It allows multiple users to access data simultaneously while maintaining the data consistency and data integrity.
(a)
16-19: 4 TYPES OF DBMS
(ANSWERS SHOULD BE SEPARATED WITH A COMMA [,])
20-23: 4 OPERATIONS OF USERS IN DATABASE
(ANSWER SHOULD BE SEPARATED WITH COMMA[,])
24-30: 7 POPULAR DBMS SOFTWARES
(ANSWERS SHOULD BE SEPARATED WITH A COMMA[,])
