DAD-220 Introduction to Structured Database Environments Exam Questions All Correctly Solved

DAD-220 Introduction to Structured Database Environments Exam Questions All Correctly Solved Data - Answer -Raw facts and values Information - Answer -Data that has been processed to give the facts meaning Three common sources of data - Answer -Social networks, business systems, internet of things Database - Answer -A collection of data in a structured format that correlates related data values. The database structure enables fast storing, retrieving, updating, and deleting of data. Database Management System (DBMS) - Answer -Commonly called a database system. A software application used to support data organization in a database. It provides additional functionality to secure data and ensure data is accurate. Application - Answer -Software used to interact with database system to access data in a database. Database Administrator (DBA) - Answer -Responsible for securing the database system against unauthorized users. DBA's enforce procedures for end user access and database system availability. Database Designer - Answer -Defines a database's tables, views, constraints, and indexes. It supports data storage, retrieval, modification, and deletion actions. End User - Answer -Consumer of data in a database. End users request, update, or use stored data to generate reports or information. Data sharing - Answer -Databases allow end users to update and share data at the same time. A text file being edited by one user may be unavailable to others Data Duplication - Answer -Shared data in databases reduces data duplication. Text files are easily shared, so multiple versions of the data may exist. Data Security - Answer -Databases ensure only certain users may edit or read stored data, but text files lack the ability to limit who can edit or read portions of a text file. Data Interaction - Answer -Databases provide simpler methods to access and combine stored data, which may lead to increased user productivity. Reading and combining data from multiple text files is cumbersome and may decrease user productivity. Data Corruption - Answer -Databases ensure stored data is valid based on the database design and can recover from file system errors. Text files may contain invalid data or be corrupted when the file system fails. Performance - Answer -How quickly data is returned from database after query. Factors that affect performance - Answer -1. Workload 2. Throughput 3. Resources 4. Query optimization 5. Data contention Workload - Answer -The number of users and applications the database can handle concurrently. How to manage: Limit the number of concurrent users and applications accessing the database. Throughput - Answer -The number of transactions a database can handle over time (transactions per second). How to manage: Ensure sufficient computer resources exists to support transaction demand. Resources - Answer -The computer hardware (CPU, memory, storage space, etc.) and software components that are available to the database system.