1-12 Эвелина 2

What is the primary purpose of data analysis?

• To extract meaningful insights from raw data for decision-making

• To manually process large datasets without software

• To randomly store data for future use

• To eliminate the need for human decision-making

• To generate random reports without interpretation

Which of the following is a key component of data management?

• Social media marketing

• Web development

• Video editing

• Data governance

• Hardware maintenance

What is the purpose of normalization in database design?

• To remove duplicate records permanently

• To decrease system security

• To delete primary keys from tables

• To add redundant data for faster access

• To organize data efficiently and reduce redundancy

What is an Entity-Relationship (ER) model used for?

• Designing network topologies

• Increasing query execution speed

• Formatting user interfaces

• Encrypting database files

• Structuring data relationships in database design

Which of the following is NOT a type of database model?

• Hierarchical

• NoSQL

• Computational

• Object-oriented

• Relational

Which SQL command is used to retrieve data from a database?

• UPDATE

• SELECT

• INSERT

• ALTER

• DELETE

What is the role of a Database Management System (DBMS)?

• Controlling internet access

• Designing front-end applications

• Running operating system processes

• Managing only network security

• Storing, retrieving, and managing data in a structured way

What is a key feature of NoSQL databases?

• They only work with SQL queries

• They require predefined table relationships

• They support flexible schema and unstructured data

• They strictly follow relational models

• They do not scale well for large data

What is the purpose of transaction management in databases?

• To prevent data storage

• To allow multiple users to modify the same data without restrictions

• To speed up database backup processes

• To ensure data integrity, consistency, and recovery in case of failure

• To delete user data regularly

Why is data security important in database systems?

• To allow unauthorized access for faster troubleshooting

• To remove encryption from stored data

• To duplicate data across multiple databases

• To increase system performance at the cost of user privacy

• To protect sensitive information from unauthorized access and breaches