Download Database Systems Study Guide: Terms and Concepts for DAD 220 Module One in 2024 and more Exams Computer Science in PDF only on Docsity!
DAD 220 Module One Study Guide 2024
Data Corrrect Answer is Numeric, textual, visual, or audio information that describes real- world systems. Analog Data Corrrect Answer is Data that is encoded as continuous variations on various physical media. Digital Data Corrrect Answer is Data that is encoded as zeros and ones on electronic and magnetic media. Database Corrrect Answer is A collection of data in a structured format. Database System (Database Management System, DBMS) Corrrect Answer is Software that reads and writes data in a database. Query Corrrect Answer is A command for a database the typically inserts new data, retrieves data, updates data, or deletes data from a database. Query Language Corrrect Answer is A specialized programming language designed specifically for database systems. Database Administrator Corrrect Answer is Responsible for securing the database system against unauthorized users. Database Designer Corrrect Answer is Determines the format of each data element and the overall database structure. Database Programmer Corrrect Answer is Develops computer programs that utilize a database. Database User Corrrect Answer is A consumer of data in a database. Transaction Corrrect Answer is A group of queries that must be either completed or rejected as a whole. Execution of some, but not all, queries results in inconsistent or incorrect data.
Architecture of a Database System Corrrect Answer is The internal components and the relationships between components. Query Processor Corrrect Answer is Interprets queries, creates a plan to modify the database or retrieve data, and returns query results to the application. Query Optimization Corrrect Answer is Performed by the query processor to ensure the most efficient instructions are executed on the data. Storage Manager Corrrect Answer is Translates the query processor instructions into low-level file- system commands that modify or retrieve data. Indexes Corrrect Answer is Used by the storage manager to quickly locate data. Transaction Manager Corrrect Answer is Ensures transactions are properly executed by preventing conflicts between concurrent transactions and restoring the database to a consistent state in the event of a transaction or system failure. Log Corrrect Answer is A file containing a complete record of all inserts, updates, and deletes processed by the database. Catalog (Data Dictionary) Corrrect Answer is A directory of tables, columns, indexes, and other database objects. Relational Database Corrrect Answer is A database that stores data in tables, columns, and rows, similar to a spreadsheet. All data in a row represents a single object, such as a person, place, product, or activity. Big Data Corrrect Answer is Massive volumes of online data due to the growth of the internet in the 1990s. Often have poorly structured or missing information. NoSQL Corrrect Answer is Stands for "not only SQL". Newer non-relational systems that are optimized for big data. CRUD
Key Corrrect Answer is A column used to identify rows of a table. Table Diagram Corrrect Answer is Used to depict logical design. Rectangles represent tables. Text within rectangles and below table names represent columns. Solid bullets (●) indicate key columns. Empty bullets (○) and arrows indicate columns that refer to keys. Database Schema Corrrect Answer is The logical design, as specified in SQL and depicted in a table diagram. Physical Design Phase Corrrect Answer is Adds indexes and specifies how tables are organized on storage media. Data Independence Corrrect Answer is The principle that physical design never affects query results. Application Programming Interface (API) Corrrect Answer is A library of procedures or classes that links a host programming language to a database. SQL Clause Corrrect Answer is Groups SQL keywords like SELECT, FROM, and WHERE with table names like City, column names like Name, and conditions like Population > 100000 Literals Corrrect Answer is Explicit values that are string, numeric, or binary. Strings must be surrounded by single quotes or double quotes. Binary values are represented with x '0' where the 0 is any hex value. Keywords Corrrect Answer is Words with special meaning. Identifiers Corrrect Answer is Objects from the database like tables, columns, etc. Comments Corrrect Answer is Statements intended only for humans and ignored by the database when parsing an SQL Statement Data Definition Language (DDL) Corrrect Answer is Defines the structure of the database.
Data Query Language (DQL) Corrrect Answer is Retrieves data from the database. Data Manipulation Language (DML) Corrrect Answer is Manipulates data stored in a database Data Control Language (DLC) Corrrect Answer is Controls database user access. Data Transaction Language (DTL) Corrrect Answer is Manages database transactions. MySQL Corrrect Answer is A leading relational database system sponsored by Oracle. MySQL Community (MySQL Server) Corrrect Answer is A free edition of MySQL. Includes a complete set of database services and tools, and is suitable for non-commercial applications such as education. MySQL Enterprise Corrrect Answer is A paid edition for managing commercial databases. Includes MySQL Server and additional administrative applications. Root Account Corrrect Answer is The administrative account that has full control of MySQL. MySQL Command-Line Client Corrrect Answer is A text interface included in the MySQL Server download. Allows developers to connect to the database server, perform administrative functions, and execute SQL statements. Error Code Corrrect Answer is Returned by MySQL Server along with a description with a statement is syntactically incorrect or the database cannot execute the statement. MySQL Workbench Corrrect Answer is Allows developers to execute SQL commands using an editor.
