Worksheetsviva cum quiz
Total questions: 55
Worksheet time: 27mins
What is the primary purpose of a file system?
To encrypt data on storage devices
To provide a user interface for applications
To increase the speed of data retrieval
The primary purpose of a file system is to manage and organize data on storage devices.
How does a DBMS manage data compared to a file system?
A DBMS only stores data in a single file format without any structure.
A DBMS provides structured data management, supports complex queries, and ensures data integrity, while a file system offers unstructured data storage with limited management capabilities.
A DBMS does not provide any data integrity features compared to a file system.
A file system is more efficient for handling complex queries than a DBMS.
What are the advantages of using a DBMS over a file system?
Increased data duplication
Advantages of using a DBMS over a file system include improved data integrity, enhanced security, support for concurrent access, reduced data redundancy, and better data management capabilities.
Limited user access control
Slower data retrieval speeds
Can a file system support concurrent access? Why or why not?
Yes, but only if the file system is not in use by any other process.
No, a file system cannot support concurrent access due to data corruption risks.
No, concurrent access is only possible with cloud storage solutions.
Yes, a file system can support concurrent access.
What is data redundancy, and how is it handled in a DBMS?
Data redundancy is the process of deleting duplicate data from a database.
Data redundancy is the efficient use of storage in a database.
Data redundancy is the unnecessary duplication of data in a database, handled in a DBMS through normalization and integrity constraints.
Data redundancy is managed by increasing the size of the database without constraints.
Explain the concept of normalization in databases.
Normalization is the process of deleting all data from a database.
Normalization in databases is the process of organizing data to reduce redundancy and improve data integrity.
Normalization is a method to encrypt sensitive data in databases.
Normalization increases data redundancy for better performance.
What types of data models are commonly used in DBMS?
Hierarchical, Network, Relational, Object-Oriented
Key-Value
Flat File
Document Store
How do file systems and DBMS handle data integrity?
File systems rely solely on encryption; DBMSs use only indexing.
File systems use checksums and journaling; DBMSs use constraints, transactions, and validation rules.
File systems do not require any integrity checks; DBMSs use only backups.
File systems and DBMSs both use only manual data entry for integrity.
What is the role of SQL in a DBMS?
SQL is a programming language for creating operating systems.
SQL is used for designing user interfaces in a DBMS.
SQL is primarily used for hardware management in a DBMS.
SQL is the language used to manage and manipulate data in a DBMS.
In what scenarios would you prefer a file system over a DBMS?
When dealing with simple data storage needs, large binary files, performance-critical applications, or minimal data integrity requirements.
For applications requiring high data integrity and consistency
When needing complex queries and relationships between data
When managing structured data with frequent updates
What is a Database Management System (DBMS)?
A software application that manages databases
A computer hardware component used for data storage
A programming language for creating databases
A network protocol for database communication
Which of the following is not a function of a DBMS?
Data storage
Data retrieval
Data manipulation
Data transmission
What is the primary purpose of a DBMS?
To store and manage data efficiently
To analyze and visualize data
To create data backups
To secure data from unauthorized access
Which of the following is an advantage of using a DBMS?
Reduced data redundancy
Increased data security
Improved data integrity
All of the above
Which data model is commonly used in modern DBMS?
Hierarchical model
Network model
Relational model
Object-oriented model
What is the key difference between a Flat File System and a DBMS?
Flat File System stores data in a single file, while a DBMS stores data in multiple interconnected files.
Flat File System is faster in data retrieval than a DBMS.
Flat File System uses a relational data model, while a DBMS uses a hierarchical data model.
Flat File System can only handle small amounts of data, while a DBMS can handle large amounts of data.
Which of the following is a disadvantage of using a Flat File System compared to a DBMS?
Limited data storage capacity
Slower data retrieval and updates
Lack of data security and integrity mechanisms
All of the above
In a Flat File System, data redundancy refers to:
The ability to store multiple copies of the same file
The repetition of the same data within a single file
The inability to store data in separate files
The lack of data indexing capabilities
Which of the following best describes the scalability of a Flat File System compared to a DBMS?
Flat File System is more scalable than a DBMS.
DBMS is more scalable than a Flat File System.
Flat File System and DBMS have similar scalability.
Neither Flat File System nor DBMS are scalable.
Which of the following is a characteristic feature of a DBMS that is not present in a Flat File System?
Ability to enforce data integrity constraints
Support for complex data relationships
Concurrent access and multi-user capabilities
All of the above
The columns in a database are called:
Records
Fields
Primary key
Foreign key
The rows in a database are called:
Records
Fields
Attribute
Coloum
What is used to grant a user account access to a database?
permission
right
password
encryption key
Aarav is learning about databases in his computer science class. Which of the following are the properties of entities?
Attribute
Group
Table
All of above
In a class project, Dia is learning about E-R diagrams and wonders how generalization is represented.
Ellipse
Dashed ellipse
Rectangle
Triangle
DOCTOR / PATIENT
SIM CARD / PHONE NUMBER
In a school database, information about a student is stored in attributes.
True
False
In a classroom setting, Aisha is trying to identify what entity type is represented in the given diagram. What entity type is used in the given diagram?
STUDENT
DOCTOR
EMPLOYEE
COURSE
Akhil is studying the concept of relationships in databases. The degree of a
relationship type is the number of participating _________.
Role
Entity Type
Attribute
Instance
In a classroom, the process of designing sub-grouping within a student entity set called as
abstraction
isolation
generalisation
specialisation
Which would NOT likely be an attribute of an entity called “Student”?
Age
Student identification number
Class room number
Home phone
Gender
In a classroom, the teacher explains that this symbol indicates _____ relationship between students' participation in group projects.
zero or one
zero or one
zero or many
one or many
many to many
Which of the following attributes can use to form composite attributes in a student database? [select all that apply]
Name
Address
Total
Age
Mira has a collection of books, and she wants to categorize them. She realizes that a single valued attribute can only store______ values
Atomic values
Non atomic values
More than one value
None of above
In a school, which of the following is considered a derived attribute for a student?
Phone Number
Name
Age
Date of Birth
Aditi has a pet dog named Max. Max can only have one owner, but Aditi can take care of many pets at the same time. Which mapping cardinality holds?
One to one
One to Many
Many to Many
Many to One
Prisha's project on Week Entity Set Dependent on_____
Identifying Entity Set
Relationship set
week Relationship Set
None of Above
Aarush is working on a project that involves database design. He needs to understand which attribute is used to uniquely identify a weak entity in his design.
Descriptive Attribute
Discriminator
Composite Attribute
Identifying Attribute
In a database for a school, the attribute of a relationship set that connects students to their courses is called_______
Descriptive Attribute
Strong Attribute
Discriminator
Multivalued attribute
Aarav is studying the ER data model, which contains ______ basic concepts
Generalization
Entity Set
Relationship Set
Attribute
In a database design class, Avani is learning about different types of relationships in an Entity-Relationship model. Which of the following is NOT a type of relationship that she has studied?
One to One
One to Many
Many to One
Single to Multiple
In a classroom project, Tisha is designing an E-R diagram for a school database. Which shape should she use to represent a student entity?
Circle
Rectangle
Diamond
Triangle
In a school database, what is the purpose of a foreign key when linking students to their respective classes?
To uniquely identify a student record
To establish a relationship between students and classes
To store multiple values for a student
To define the primary key for the class
In a database, what is the main function of a primary key?
To link tables together
To uniquely identify each record in a table
To store multiple values in a single field
To define relationships between entities
Which of the following best describes a many-to-many relationship in a database?
Each record in one table can relate to multiple records in another table
Each record in one table can relate to only one record in another table
Each record in both tables can relate to only one record in the other table
Each record in both tables can relate to multiple records in the other table
In an E-R diagram, which shape is typically used to represent a relationship?
Circle
Rectangle
Diamond
Triangle
Consider the following relations: Employee(EmpID, Name, DeptID) Department(DeptID, DeptName, Location) Which SQL query returns the names of employees working in the same department as 'Amit'?
SELECT Name FROM Employee WHERE DeptID = (SELECT DeptID FROM Employee WHERE Name = 'Amit');
SELECT Name FROM Employee WHERE EXISTS (SELECT * FROM Employee WHERE Name = 'Amit' AND DeptID = DeptID);
SELECT Name FROM Employee WHERE DeptID IN (SELECT DeptID FROM Department WHERE Name = 'Amit');
SELECT Name FROM Employee WHERE Name != 'Amit' AND DeptID = 'Amit';
Consider the following FDs on relation R(A, B, C, D): F = {A -> BC, B -> C, A -> B, AB -> C, AC -> D} What is the minimal cover for F?
{A -> B, A -> C, AC -> D}
{A -> B, B -> C, AC -> D}
{A -> B, A -> C, C -> D}
{A -> B, A -> C, A -> D}
Given relation R(A, B, C, D, E), and FDs: F = {A -> B, B -> C, C -> D, D -> E}, What is the closure of A+?
{A, B, C, D}
{A, B, C, D, E}
{A, B, C}
{A, C, D, E}
Given relation R(A, B, C, D) and FDs: F = {A -> B, B -> C, C -> A, AD -> B, CD -> A} Which of the following is not a superkey?
{A, D}
{C, D}
{B, D}
{D, A, B}
Let R(A, B, C, D) be a relation with FDs: F = {A -> BC, B -> D, C -> A}. Find the candidate key(s).
A
C
B
AB
The data model which describes how the data is actually stored is
internal model
external model
logical model
none of these
