WorksheetsDatabase Design Quiz
Total questions: 69
Worksheet time: 1hrs 9mins
What is the primary purpose of normalization in database design?
To increase data redundancy
To reduce data redundancy and dependency
To complicate table structures
To speed up data retrieval
Which normal form eliminates repeating groups?
2NF
3NF
1NF
BCNF
What does functional dependency describe?
The speed of data retrieval
The relationship between attributes in a relational database
The size of the database
The security of the database
Ensuring that data remains the same across all instances and updates refers to:
Data accuracy
Data completeness
Data consistency
Data reliability
Which type of data integrity ensures that each row in a table is uniquely identifiable?
Domain integrity
Entity integrity
Referential integrity
User-defined integrity
What does referential integrity maintain?
Data values within a defined range
Business rules defined by users
Consistency between related tables
Protection from physical threats
Implementing checks to ensure that data meets predefined rules and formats is known as:
Data backup
Data auditing
Data validation
Data constraint
Which of the following is NOT a type of DBMS?
RDBMS
NoSQL
SQL
Hierarchical
What does RDBMS organize data into?
Documents
Graphs
Tables
Key-value pairs
What language is used to write queries in RDBMS?
Java
Python
SQL
C++
Which of the following is an example of a NoSQL DBMS?
MySQL
Oracle
MongoDB
PostgreSQL
What is the role of a Database Administrator (DBA)?
Designing user interfaces
Managing and maintaining the DBMS
Writing application code
Creating marketing strategies
Which of the following is a task of a DBA?
Hardware installation
Performance tuning
Network configuration
Software development
What does optimizing database performance for MIS include?
Index tuning
Query optimization
Hardware optimization
All of the above
What is the importance of data governance policies?
To define how data is managed, used, and protected
To control hardware costs
To design user interfaces
To develop marketing plans
Which of the following is included in data governance policies?
Data quality standards
Data security policies
Data access controls
All of the above
What is a key benefit of cloud-based databases?
Reduced scalability
Increased maintenance overhead
Cost-effectiveness
Limited flexibility
What type of data do NoSQL databases handle well?
Structured data
Unstructured and semi-structured data
Small volumes of data
Highly relational data
What is a database schema?
The actual information stored in the database
Software that manages the database
Structure defining the organization of data
Language used to perform operations on data
What is a DBMS?
The actual information stored in the database
Software that manages and interacts with the database
Structure defining the organization of data
Language used to perform operations on data
What is the purpose of a query language in a database?
To define the structure of the database
To manage the database software
To perform operations on the data
To store the actual data
What is the function of database indexes?
To store the actual data
To speed up the process of finding specific data
To define the database structure
To manage the database software
What does a clustered index determine?
A copy of the indexed columns
The physical order of the data in a table
A pointer to the actual data
An index based on a function
How many clustered indexes can a table have?
Multiple
Only one
Depends on the size of the table
None
What does a non-clustered index contain?
The actual data
A copy of the indexed columns and a pointer to the actual data
The physical order of the data
An index based on a function
What is a key drawback of indexes?
They take up a lot of storage space.
They slow down data retrieval.
They need to be updated when data is updated.
They can only be used with NoSQL databases.
What is a key role of a DBMS in MIS?
Creating data silos
Acting as a centralized data storage
Promoting data inconsistency
Limiting data sharing
What do companies use ERP systems for in manufacturing?
Customer relationship management
Production scheduling and inventory management
Patient care processes
Loan processing
What do hospitals use EHR systems for?
Managing customer relationships
Streamlining patient care processes
Automating order processing
Personalizing financial services
What do banks use CRM systems for?
Optimizing production lines
Managing customer relationships
Automating shipping
Analyzing patient data
What is a benefit of BPM?
Increased efficiency and productivity
Increased costs
Reduced agility
Decreased customer satisfaction
How does BPM help reduce costs?
By increasing waste
By identifying and eliminating inefficiencies
By adding redundant tasks
By slowing down cycle times
What does BPM enable organizations to do in terms of market conditions?
Ignore changing market conditions
Quickly adapt to changing market conditions
Maintain the status quo
Increase errors
What is essential for overcoming resistance in BPM implementation?
Effective change management strategies
Ignoring employee concerns
Keeping changes secret
Avoiding training
Who should be engaged for BPM success?
Only managers
Only employees
All stakeholders
No one
What is essential for tracking progress in BPM initiatives?
Defining clear metrics and KPIs
Avoiding monitoring
Ignoring process performance
Setting no objectives
What is a key aspect of keeping morale high during BPR?
Keeping information secret
Being transparent about changes
Ignoring employee concerns
Avoiding recognition
What implementation strategy is well-suited for radical change?
Traditional waterfall-style
Agile and adaptive
Rigid and inflexible
Top-down only
What does implementing BPR across the entire organization at once involve?
Minimal risk
Pilot projects
No refinement
Ignoring feedback
What is a crucial aspect of BPR implementation?
Rigidity
Flexibility
Ignoring change
Avoiding contingency plans
What is a limitation of traditional performance metrics in BPR?
They capture the full impact of BPR
They only consider long-term outcomes
They may not capture the full impact of BPR
They focus on qualitative measures
What is an example of a qualitative measure in BPR?
Cost savings
Efficiency gains
Employee morale
KPIs
What should you do when measuring the success of a newly designed process?
Avoid setting goals
Track KPIs over time
Ignore stakeholder feedback
Conduct no reviews
What is a factor to look for in successful BPR case studies?
Weak leadership
Employee disengagement
Technology enablement
Data-ignorant decision-making
What is a key security challenge related to users?
Hardware failures
User security and awareness
Software vulnerabilities
Natural disasters
What is a common security vulnerability related to the human element?
Phishing attacks
Strong passwords
Up-to-date software
Firewalls
What does security awareness training educate users about?
Advanced programming techniques
Recognizing phishing emails and creating strong passwords
Hardware installation
Network cabling
What is a strong authentication mechanism to prevent unauthorized access?
Sharing passwords
Multi-factor authentication (MFA)
Using default passwords
Avoiding password changes
What does risk assessment involve in cybersecurity?
Ignoring potential threats
Identifying potential threats and vulnerabilities
Installing new hardware without planning
Avoiding security policies
What is an example of a technical control to mitigate risks?
Security policies
Firewalls
User awareness training
Administrative procedures
What is the purpose of defense in depth?
Relying on a single security measure
Implementing multiple layers of security controls
Avoiding antivirus software
Disabling firewalls
What does incident response planning involve?
Ignoring security incidents
Having a plan to respond to security incidents
Avoiding data backups
Skipping system restoration procedures
What does disaster recovery planning involve?
Avoiding data backups
Having a plan to recover from major disruptions
Ignoring natural disasters
Avoiding system restoration
Why is patch management important?
To create software vulnerabilities
To fix known vulnerabilities
To slow down systems
To increase security risks
What can AI be used for in cybersecurity?
To create malware
To detect anomalies and identify potential threats
To bypass security measures
To slow down network traffic
What is the purpose of a database schema?
To store the actual data
To manage the database software
To define the organization of data
To perform operations on the data
Which component of a DBMS is responsible for ensuring data integrity, consistency, and security?
Data
DBMS
Query Language
Database Schema
What is the purpose of a query language like SQL?
Defining the database structure
Managing the database software
Performing operations on the data
Storing the actual data
What is the function of database indexes?
To store the actual data
To speed up the process of finding specific data
To define the database structure
To manage the database software
What does a clustered index determine?
A copy of the indexed columns
The physical order of the data in a table
A pointer to the actual data
An index based on a function
How many clustered indexes can a table have?
Multiple
Only one
Depends on the size of the table
None
What does a non-clustered index contain?
The actual data
A copy of the indexed columns and a pointer to the actual data
The physical order of the data
An index based on a function
What is a drawback of indexes?
They take up a lot of storage space
They slow down data retrieval
They need to be updated when data is updated
They can only be used with NoSQL databases
What is a key role of a DBMS in MIS?
Creating data silos
Acting as a centralized data storage
Promoting data inconsistency
Limiting data sharing
What is the purpose of data validation?
To prevent data loss from physical threats
To ensure data meets predefined rules and formats
To track changes to data
To limit access to data
Which type of DBMS organizes data into tables with rows and columns?
NoSQL DBMS
Relational DBMS (RDBMS)
Hierarchical DBMS
Object-oriented DBMS
What language is commonly used to query data in a relational DBMS?
Java
Python
SQL
C++
What is a key characteristic of NoSQL DBMS?
It uses SQL for querying data
It organizes data into tables
It handles large volumes of unstructured data
It enforces strict data schemas
Which of the following is an example of a NoSQL DBMS?
MySQL
Oracle
MongoDB
PostgreSQL
