Font size
WorksheetsDatabase Systems
Total questions: 15
Worksheet time: 8mins
Which of the following is not a level of data abstraction?
Physical Level
Critical Level
Logical Level
View Level
Which of the following is not a Storage Manager Component?
Transaction Manager
Logical Manager
Buffer Manager
File Manager
Which of the following is a Data Model?
Entity-Relationship model
Relational data model
Object-Based data model
All of the above
This is an example of ________________
Data inconsistency
Data redundancy
Data security
Data consistency
Select the DBMS software
SELECT * FROM employee WHERE salary>10000 AND dept_id=101;
Which of the following fields are displayed as output?
Salary, dept_id
Employee
Salary
All the field of employee relation
What is the following data model an example of?
Conceptual Data Model
Logical Data Model
Physical Data Model
Complete Data Model
The following are examples of Non-SQL except one.
Postgre
Microsoft Excel
Microsoft Acess
Voldemort
Which of the following is true for Views?
Structure data in a way that users or groups of user find intuitive
Improve the performance of the database.
Summarise data from multiple tables
Restrict access to the data in such a way that a user can see and modify only what they need.
The conceptual model is
Dependent on hardware
Dependent on software.
Dependent on both hardware and software
Independent of both hardware and software
Creating new subclasses from an existing class is called
Generalization
Specialization
Cetegorization
Normalization
The process of minimizing the differences between entities by identifying their common characteristics is known as:
Specialization
Generalization
Multiplicity
Normalization
The minimum and maximum values of connectivity is called the __________ of the relationship.
cardinality
degree
modality
tuple
