D426 Study Guide Red Text ONLY

D426 Data Management - Foundations Pre-Assessment Leave the first rating Students also studied Terms in this set (103) Western Governors UniversityD 426 Save D426 Study Guide (Red Text ONLY) 225 terms brattynnPreview

WGU - D426: Objective Assessment...

151 terms natesoundslike Preview

WGU D426 V2

160 terms MoDhochesPreview

D426 D

58 terms alex Practice questions for this set Learn1 / 7Study using Learn Which type of relationship is established by a foreign key in a relational database?AuthorizationWhich requirement within large, complex databases ensures users have limited access to the database?Conceptual designWhich design type specifi es database requirements without regard to a specifi c database system?They are logical constraints that ensure the data is valid. What characterizes the rules of relational databases?Choose an answer 1Many-to-many2One-to-one 3One-to-many4Many-to-one Don't know?

When an SQL statement is syntactically incorrect Which event will result in an error code and error description when using MySQL Server?INTWhich data type should be used to store whole integer values, such as age?MySQL Command-Line ClientWhich text-based interface is included in the MySQL Server Download?MySQLWhich database system includes the World database during its installation?Structured Query LanguageWhat is the standardized language of relational database systems?Data Control Language (DCL)Which SQL sublanguage is used to manage database access?Data Transaction Language (DTL)Which SQL sublanguage is used to roll back database changes?hh:mm:ssWhich format is used by the TIME data type in MySQL?ORWhich MySQL operator is the last in the order of operator precedence?<=Which operator is used to compare columns from the left and right tables in MySQL?CROSSWhich type of join combines two tables without comparing columns?EquijoinWhich type of join compares columns using only the = operator?EQUIJOINWhich type of join is demonstrated by the following query?SELECT Dog.Nickname, Kennel.Address FROM Dog, Kennel WHERE Dog.KennelID = Kennel.ID In a nested query, the outer query is evaluated first. What is another name for a subquery?INWhich operator is used to compare against a list of values when determining a match in a WHERE clause?%Which wildcard character is used to represent zero or more characters when searching for a specified pattern using a LIKE operator?MINWhich function is considered an aggregating function in SQL?GROUP BYWhich clause or function is used with aggregate functions to produce summary rows?Inner JoinWhich type of join returns only the matching values when selecting rows from two or more tables?Inner JoinWhich join type selects only matching left and right table rows?

Materialized ViewWhich phrase refers to the view in which data is persisted and is automatically changed as the underlying data is changed?UPDATE Employee SET Salary = 50000 WHERE ID = 1; Which SQL command uses the correct syntax to update the salary of an employee in the Employee table?MetadataWhat describes elements such as column name and data type?TupleWhich term identifies an ordered collection of elements enclosed in parenthesis in a tablespace?SELECT name, salary FROM Employee WHERE salary > 50000ORDER BY salary DESC; Which SQL command uses the correct syntax to select the name and salary columns from the Employee table, where the salary is greater than 50000, and sort the results by salary in descending order?INSERT INTO table_name (column1, column2) VALUES (value1,value2); Which INSERT statement demonstrates valid syntax in SQL?UPDATE table_name SET column1 = value1, column2 = value2WHERE condition; Which UPDATE statement uses valid syntax in SQL?TRUNCATEWhich statement used to remove data from temporary tables?CREATEWhich keyword is a DDL (data definition language) keyword in SQL?Not NullWhich property is enforced by a primary key fi eld?Auto-incrementWhich property or function allows SQL to insert a fi eld value?CASCADEWhich property specifies an expression on one or more columns of a table?Simple primary keyWhich type of key is a single column in a table used to identify a row?CompositeWhich type of key is often represented by parentheses to show multiple columns?SimpleWhich primary key characteristic means it includes information that is easy to type and store?One-to-manyWhich type of relationship is established by a foreign key in a relational database?INSERTWhich statements may be rejected when a foreign key constraint is specified?Candidate keyWhich key describes the unique columns in a table that do not contain a primary key?Multi-level indexWhich index stores column values and row pointers in a hierarchy?Hash indexWhich type of index refers to entries that are assigned to buckets?

Bitmap indexWhich type of index is a grid of bits where each index row corresponds to a unique row in a table?Foreign keyWhich part of a junction table in a relational database establishes a many-to-many relationship between two tables?Logical designWhich type of development activity is used to convert an entity-relationship model (ERM) into tables, columns, and keys?Trivial dependencyWhich term addresses columns of A being a subset of the columns of B, with A always depending on B?Merging tablesWhich term describes the process of denormalization?It is a first normal form table.A database designer is working with a table that has a primary key and no duplicate rows.What can be concluded about the table?NormalizationWhich process eliminates redundancy by decomposing a table into two or more tables in a higher normal form?Boyce-Codd normal formWhich term describes the optimal normal form for frequent inserts, updates, and deletes of data?One-to-manyWhich relationship is depicted in the following entity-relationship (ER) diagram?IsA relationshipWhich relationship or association exists between a supertype entity and its subtype entities?SquareWhich symbol is used in an entity-relationship (ER) diagram for an entity?CircleWhich symbol is used in an entity-relationship (ER) diagram to indicate an attribute?Identify entities.What must be done before creating supertype and subtype entities?EntityWhich real-world object can be distinctly identified and grouped, such as all employees in a company?Weak entityWhich item in an entity-relationship (ER) diagram follows the attribute name and is placed outside of parentheses?Unique identifier analysisWhich strategy can be used to identify primary keys when investigating data relationships?