NEW
Font size
WorksheetsDBC-IT105-Prelim Quiz
Total questions: 25
Worksheet time: 13mins
In hierarchy of database, which is the smallest unit of data, representing a binary value?
Bit
Byte
Field
Record
In hierarchy of database, which is the collection of related fields, representing a single entity, such as a
customer or product?
Bit
Byte
Field
Record
In the database hierarchy, which is the collection of related records?
Field
Record
Table
Database
Database minimizes data redundancy to a great extent.
True
False
Sharing of data is not possible using the database.
True
False
Which of the following DBMS organizes data in a tree-like hierarchy with parent-child relationships?
Hierarchical DBMS
Network DBMS
Relational DBMS (RDBMS)
Object-Oriented DBMS (OODBMS)
Which of the following DBMS organizes data into tables (relations) with rows (records) and columns (fields)?
Hierarchical DBMS
Network DBMS
Relational DBMS (RDBMS)
Object-Oriented DBMS (OODBMS)
Which of the following DBMS stores data in various formats like key-value pairs, documents, or
graphs?
Hierarchical DBMS
NoSQL DBMS
Cloud DBMS
In-Memory DBMS
Which of the following DBMS managed and hosted on cloud platforms, allowing scalable, on-demand
resources and services?
Hierarchical DBMS
NoSQL DBMS
Cloud DBMS
In-Memory DBMS
In early computing, file systems were used to store and manage data.
True
False
Databases provide a structured way to store and manage data, supporting large
volumes of data with complex relationships.
True
False
Which functions of DBMS help store data in a structured format and provide tools to retrieve data efficiently?
Data Storage and Retrieval
Data Security
Data Integrity
Data Backup and Recovery
Which functions of DBMS ensure the accuracy and consistency of data over its entire lifecycle?
Data Storage and Retrieval
Data Security
Data Integrity
Data Backup and Recovery
DBMS acts as an intermediary between data and users, allowing disparate data from different applications to be managed.
True
False
Which components of the database system interpret the requests received from end users via an application program into instructions?
Query Processor
Storage Manager
Disk Storage
Database Administrator
The Relational Data Model is one of the most widely used data models for databases.
True
False
An attribute is a single row in a table, representing a single record.
True
False
Which of the following is the minimal set of attributes that can uniquely identify a tuple?
Candidate Key
Primary Key
Foreign Key
Alternate Key
Which of the following is the unique key?
Candidate Key
Primary Key
Foreign Key
Alternate Key
Which of the following is a key it acts as a primary key in one table and it acts assecondary key in another table?
Candidate Key
Primary Key
Foreign Key
Alternate Key
Which of the following DBMS relationships occurs when each record in one entity is related to only one record in another entity, and vice versa?
One-to-One Relationship
One-to-Many Relationship
Many-to-Many Relationship
One-to-Single Relationship
Which of the following DBMS arises when multiple records in one entity can be linked to multiple records in another entity?
One-to-One Relationship
One-to-Many Relationship
Many-to-Many Relationship
One-to-Single Relationship
A domain defines the permissible values for an attribute.
True
False
Keys are special types of attributes that uniquely identify rows or establish relationships between tables.
True
False
Primary keys are not necessarily to be a single column; more than one column can also be a primary key for a table.
True
False
