NEW
Font size
WorksheetsDBMS - Fundamentals
Total questions: 19
Worksheet time: 21mins
What is a database?
Organized collection of information that cannot be accessed, updated, and managed
Collection of data or information without organizing
Organized collection of data or information that can be accessed, updated, and managed
Organized collection of data that cannot be updated
Which type of data can be stored in the database?
Image oriented data
Text, files containing data
Data in the form of audio or video
All of the above
Which of the following is not an example of DBMS?
MySQL
Microsoft Acess
IBM DB2
Which of the following is not a feature of DBMS?
Minimum Duplication and Redundancy of Data
High Level of Security
Single-user Access only
Support ACID Property
Which of the following is known as a set of entities of the same type that share same properties, or attributes?
Relation set
Tuples
Entity set
Entity Relation model
What does an RDBMS consist of?
Collection of Records
Collection of Keys
Collection of Tables
Collection of Fields
______________ is a set of one or more attributes taken collectively to uniquely identify a record.
Primary Key
Foreign key
Super key
Candidate key
_______ indicates the maximum number of entities that can be involved in a relationship.
Greater Entity Count
Minimum cardinality
Maximum cardinality
ERD
Which of the following is the view level database model
ER model
Relational Model
Table
File
Which of the following is not Unary operation?
Select
Project
Rename
Union
The operation which is not considered a basic operation of relational algebra is
Cross Product
Selection
Union
None of the above
Relational Algebra is a __________ query language that takes two relation as input and produces another relation as output of the query.
Relational
Structural
Procedural
Fundamental
A list of the attributes we wish to appear in the result is displayed in ___ operation.
Select
Project
Union
Rename
If there are 2 types of tuples, A & B, the ___ operation contains all the tuples that are either in A or B or both in A & B.
Project
Select
Union
Rename
In a one-to-many relationship, the entity that is on the one side of the relationship is called a(n) ________ entity.
Parent
Child
Instance
Subtype
.
In which of the following is a single-entity instance of one type of related to a single-entity instance of another type?
One-to-One Relationship
One-to-Many Relationship
Many-to-Many Relationship
Composite Relationship
Let E, and E’ be two entities in an ER diagram with simple single-valued attributes, R1 and R2 are two relationships between E and E’ where R1, is one-to-many and R2 is many-to-many. R1 and R2 do not have any attributes of their own. What is the minimum number of tables required to represent this situation in the relational model.
2
3
4
5
Consider the following relation schema pertaining to a student database:
Student (rollno, name, address)
Enroll (rollno, courseno, coursename)
where the primary keys are shown underlined. The number of tuples in the student and Enroll tables are 120 and 8 respectively. What are the maximum and minimum number of tuples that can be present in (Student Enroll), where denotes natural join?
8 , 8
120 , 8
960 , 8
960 , 180
Properties that describes the characteristics of the entities are called ................
Entities
Identifiers
Attributes
Relationships
