WorksheetsDBMS Quiz
Total questions: 50
Worksheet time: 25mins
Which of the following is a characteristic of a relational database?
Hierarchical data organization
Flat data structure
Uses tables to organize data
Object-oriented data storage
What is the primary purpose of a database management system (DBMS)?
To store data in a hierarchical format
To create spreadsheets
To enable data to be easily stored, retrieved, and manipulated
To perform statistical analysis
Which of the following is a database query language?
HTML
SQL
CSS
XML
In a database, what is a primary key?
A key that can have duplicate values
A unique identifier for a record in a table
A key that is always NULL
A key that links different databases together
Which operation is used to retrieve data from a database?
DELETE
INSERT
UPDATE
SELECT
What is a foreign key in a database?
A key that is always unique
A key that is used to link two tables together
A key that is never indexed
A key that contains only numeric values
What is a data warehouse?
A system used for operational transaction processing
A centralized repository for integrated data from multiple sources
c. A database used for storing multimedia content
d. A software application for designing databases
What is the purpose of a database schema?
To encrypt data stored in the database
To define the structure and organization of data
To backup data in the database
To manage user access permissions
What is the ACID property in databases?
A standard for data encryption
A set of properties ensuring reliable transactions
A method for increasing database speed
A tool for data visualization
What is a data mart?
A large-scale database for enterprise data
A subset of a data warehouse focused on a specific area
A database for storing unstructured data
A system for data mining
What is normalization in database design?
A process to speed up database queries
A method to make database design complex
A technique to organize data to reduce redundancy
A way to create more tables
Which of the following is the correct expansion of the acronym “ACID” in the context of database management systems?
Arithmetic Consistency Isolation Data
Atomicity Consistency Isolation Durability
Automated Computation Integrity Design
Access Control Information Data
Which of the following describes the requirement for First Normal Form (1NF)?
Eliminate transitive dependencies
Remove partial dependencies
Ensure that there are no repeating groups in the table
Remove all duplicate records
Which normal form eliminates transitive dependencies?
First Normal Form (1NF)
Second Normal Form (2NF)
Third Normal Form (3NF)
Boyce-Codd Normal Form (BCNF)
Which of the following best describes authentication in the context of database security?
Granting users access to specific data
Verifying the identity of users accessing the database
Encrypting sensitive data before storing it
Monitoring database activities for suspicious behavior
Why is encryption important in database security?
It prevents unauthorized users from modifying database structure
It ensures that sensitive data is protected even if accessed by unauthorized individuals
It helps in verifying user identity
It monitors database activities for auditing purposes
What does DBMS stand for?
Data Business Management System
Database Management System
Digital Background Management Service
Dynamic Binary Manipulation System
Which of the following is not a type of DBMS architecture?
Hierarchical
Relational
Logical
d. Network
What is the purpose of the Data Definition Language (DDL) in DBMS?
Retrieving data
Defining database structure
Updating records
Querying data
What is the role of the Data Manipulation Language (DML) in DBMS?
Creating tables
Modifying data
Defining relationships
Managing user access
In a relational database, what does a foreign key establish?
A link between two tables
The primary key of a table
An index for fast retrieval
A unique identifier for each record
Which of the following is an example of a non-relational database model (NoSQL database)?
SQL Server
MongoDB
MySQL
Oracle
What is the purpose of a DBMS (Database Management System)?
To create data
To organize and manage data
What does SQL stand for?
Simple Question Language
Structured Query Language
Sequential Query Logic
Server Quality Language
What is a key advantage of using a DBMS in managing data?
Increased data redundancy
Improved data security
Slower data retrieval
Limited data sharing
In a relational database table, columns are better known as ________________.
Records
Fields
Categories
Records
The number of rows in a relation
degree
tuple
cardinality
domain
Which of the following operations requires the relations to be union compatible?
A.UNION
B.INTERSECTION
C.DIFFERENCE
D.ALL OF THESE
In a relational database table, columns are also known as ________________.
Records
Fields
Categories
Records
In the relational modes, cardinality is termed as:
Number of tuples
Number of attributes
Number of tables
Number of constraints
What is the purpose of a primary key in a relational database?
To uniquely identify each record in a table
To link records across different tables
To sort records in a specific order
To perform complex calculations
An organized collection of structured information, or data, typically stored electronically in a computer system.
database
record
primary key
foreign key
A collection of fields and records in a specific category
Record
Table
Field
DBMS stands for-
Data basic maintenance system
Data base maintenance system
Data base management system
Data base managed system
How does Access treat the objects within a database?
As separate documents
As identical copies
As part of the database file
As temporary files
What analogy is used to describe the database in Access?
A folder of objects
A collection of files
A box of tools
A library of documents
What is a record?
grid made up of rows and columns used to store information.
collection of information that is stored on a computer.
sheet that has controls that are used to view and enter information
group of information about a person, thing, or event.
A group of fields, such as a telephone number, address and name, which are pertinent to a particular item. These are also known as rows.
query
field
report
records
What is the full form of DBMS?
Data of Binary Management System
Database Management System
Database Management Service
Data Backup Management System
1. What is the full form of DBMS?
a) Data of Binary Management System
b) Database Management System
c) Database Management Service
d) Data Backup Management System
a
b
c
d
Which of the following creates a virtual relation for storing the query?
A . Function
B . View
C . Procedure
D . None of the mentioned
What is the main purpose of a foreign key in a relational database?
To ensure data integrity between tables
To create a unique identifier for each record
To speed up data retrieval
To store large amounts of data
Which of the following is a benefit of using a database management system (DBMS)?
Increased data redundancy
Improved data security
Decreased data integrity
Limited data access
What is a characteristic of a hierarchical database model?
Data is organized in a tree-like structure
Data is stored in flat files
Data is organized in tables with rows and columns
Data is stored in a network of nodes
