D426 Data Management - Foundation Objective Assessment Practice Exam

D426 Data Management - Foundation Objective Assessment Practice Exam 10 studiers recently 4.8 (5 reviews) Students also studied Terms in this set (186) Western Governors UniversityD 426 Save D426 Study Guide (Red Text ONLY) 225 terms brattynnPreview

WGU D426 V2

160 terms MoDhochesPreview

WGU - D426: Objective Assessment...

151 terms natesoundslike Preview

D426 -

139 term Sam Practice questions for this set Learn1 / 7Study using Learn The individual who is responsible for safeguarding the database system against unauthorized access and enforcing procedures for user access and system availability.Database ApplicationSoftware that helps business users interact with database systems.Database AdministratorThe individual who is responsible for safeguarding the database system against unauthorized access and enforcing procedures for user access and system availability.Choose an answer 1Project Manager2Storage Manager 3Database Administrator4Network Administrator Don't know?

Database DesignerDetermines the format of each data element and the overall database structure.AuthorizationMany database users should have limited access to specific tables, columns, or rows of a database. Database systems use this to grant individual users access to specific data.Query ProcessorInterprets queries, creates a plan to modify the database or retrieve data, and returns query results to the application RulesDatabase systems ensure data is consistent with structural and business rules.What does the query processor perform?Query optimization to ensure the most efficient instructions are executed on the data.Storage ManagerTranslates the query processor instructions into low-level file system commands that modify or retrieve data.IndexesDatabase sizes range from megabytes to many terabytes, so the storage manager uses indexes to quickly locate data.Transaction ManagerThe transaction manager ensures efficient transaction execution, prevents conflicts between concurrent transactions, and restores the database to a consistent state in case of a transaction or system failure.MetadataIs data about the database, such as column names and the number of rows in each table.Relational DatabaseStores data in tables, columns, and rows, similar to a spreadsheet.SQL Query LanguageAll relational database systems support this.Relational systems are ideal for databases that require....An accurate record of every transaction, such as banking, airline reservation systems, and student records.NoSQLA nonrelational database.INSERTInserts rows into a table.SELECTRetrieves data from a table.UPDATEModifies data in a table.DELETEDeletes rows from a table.CREATE TABLEStatement creates a new table by specifying the table and column names.Data TypeIndicates the format column names. These can be numerical, textual or complex.INTStores integer values.

DECIMALStores fractional numeric values.VARCHARStores textual values.DATEStores year, month, and day.The Analysis PhaseSpecifies database requirements without regard to a specific database system.Requirements are represented as entities, relationships, and attributes.AnalysisHas many alternative names, conceptual design, entity-relationship modeling, and requirements definition.What shape represents an Entitiy?Rectangle

• multiple choice options

Logical Design PhaseImplements database requirements in a specific database system. For relational database systems, it converts entities, relationships, and attributes into tables, keys, and columns.Physical Design PhaseAdds indexes and specifies how tables are organized on storage media with SQL statements such as CREATE INDEX and is specific to a database system.Data IndependenceThe principle that physical design never affects query results MySQL Command-Line ClientA text interface that is included in the MySQL Server download.Error CodeGenerated when a SQL statement is syntactically incorrect or the database cannot execute the statement.Data StructuresPrescribes how data is organized.Table, Column, Row, & Data TypeData structures that organizes data in table.TupleAn ordered collection of elements is enclosed in parentheses such as (a, b, c) and (a, b, c).

• multiple choice options

RulesGoverns valid data.TableHas a name, a fixed tuple of columns, and a varying set of rows.ColumnHas a name and a data type.RowAn unnamed tuple of values. Each value corresponds to a column and belongs to the column's data type.Data TypeA named set of values, from which column values are drawn.

SelectSelects a subset of rows of a table.JoinCombines two tables by comparing related columns.UnionSelects all rows of two tables.AggregatePerforms a calculation on a set of values and returns a single result. They are commonly used to summarize or analyze data, such as calculating sums, averages, counts, or finding maximum or minimum values within a dataset.Logical ConstraintsRules that ensure data is valid.Business RulesBased on policies that are specific to a particular database.

Ex: PassportNumber values may not repeat in different Employee rows.

Structured Query LanguageThe standard language for relational databases, and is commonly supported in non-relational databases.LiteralsExplicit values that are string (surrounded by single or double quotes), numeric, or binary (represented with x'0', where '0' is any hex value).KeywordsWords with special meaning such as SELECT, FROM, and WHERE.IdentifiersObjects from the database like tables, columns, etc.Ex. City, Name, Population Data Definition Language (DDL)Defines the structure of the database.Data Query Language (DQL)Retrieves data from the database.Data Manipulation Language (DML)Manipulates data stored in a database.Data Control Language (DCL)Controls database user access.Data Transaction Language (DTL)Manages database transactions.TableHas a name, a fixed sequence of columns, and a varying set of rows.ColumnHas a name and a data type.RowAn unnamed sequence of values. Each value corresponds to a column and belongs to the column's data type.CellA single column of a single row.No row orderRows are not ordered. The organization of rows on a storage device, such as a disk drive, never affects query results.