DAT/380 Advanced Database Architecture The Latest Version A+ Study Guide
**********************************************
DAT 380 Entire Course Link http://www.onlinehelp123.com/dat-380 DAT 380 Wk 1 - Practice: Pre-Course Assessment Quiz Which of the following is true of spreadsheet applications? • They enhance the user's ability to understand the data. • They provide enhanced security and robust data sharing features. • They do not allow manipulation of data once entered. • They are a better alternative to databases.
Disjoint subtypes are subtypes that contain nonunique subsets of the supertype entity set. • True • False A data dictionary is sometimes described as "the database designer's database" because it records the design decisions about tables and their structures. • True • False A weak entity has a primary key that is partially or totally derived from the parent entity in the relationship. • True • False The "_____" characteristic of a primary key states that the primary key should not have embedded semantic meaning. • nonintelligent • unique values
• •
preferably single-attribute security-compliant
Each row in the relational table is known as an entity instance or entity occurrence in the ER model. • True • False In Oracle, you can use the SQL*Plus command SHOW ERRORS to help you diagnose errors found in PL/SQL blocks. • True • False
Structure is based on the type of processing to be performed on the data. • True • False In the context of total completeness, in a(n) _____, every supertype occurrence is a member of at least one subtype. • disjoint constraint • overlapping constraint • unique constraint • foreign key constraint
A(n) _____ is the attribute in the supertype entity that determines to which entity subtype each supertype occurrence is related. • subtype discriminator • entity supertype • specialization hierarchy • inheritance discriminator
The tables on which a view, or a virtual table derived from a SELECT query, are based are called _____ tables. • indexed • core • base • relation One of the major advantages of stored procedures is that they can be used to encapsulate and represent business transactions. • True • False A _____ is a character or group of characters that has a specific meaning.
• file • record • database • field To implement a small database, a database designer must know the "1" and the "M" sides of each relationship and whether the relationships are mandatory or optional. • True • False Database design is a(n) _____ process based on repetition. • linear • sequential • intermittent • iterative A system is always at some stage of SDLC because every request for structural changes requires retracing the steps of the Systems Development Life Cycle (SDLC). • True • False SQL allows the use of logical restrictions on its inquiries such as OR, AND, and NOT. • True • False In a(n) _____ diagram, the arrows above the attributes indicate all desirable dependencies. • Chen • ER • functionality • dependency The term "database development" is used to describe the process of database design and implementation. • True • False The hierarchical data model was developed in the _____. • 1990s • 1960s • 1980s • 1970s In the _____ model, the basic logical structure is represented as an upside-down tree. • entity relationship • network • relational • hierarchical Each table _____ represents an attribute. • value • dimension • column • row
When the specific cardinalities are not included on the diagram in Crow's Foot notation, cardinality is implied by the use of _____. • tables • images • symbols • attributes The most useful feature of PL/SQL blocks is that they let a designer create code that can be named, stored, and executed by the DBMS. • True • False Field refers to a collection of related records. • True • False
DAT 380 Wk 1 - Practice Knowledge Check The only way to access the data in a database is through the DBMS. • True • False Which of the following is true of spreadsheet applications? • They enhance the user's ability to understand the data. • They provide enhanced security and robust data sharing features. • They do not allow manipulation of data once entered. • They are a better alternative to databases. The term _____ refers to an organization of components that define and regulate the collection, storage, management and use of data within a database environment. • database system • structured data • management system • transaction A _____ is a collection of related records. file column field schema
Even when a good database blueprint is available, an applications programmer's view of the data should match that of the manager and the end user. • True
•
False
A(n) _______ enables a database administrator to describe schema components. • data definition language (DDL) • query language • unified modeling language (UML) • extensible markup language (XML) In an SQL-based relational database, rows in different tables are related based on common values in common attributes. • True • False VMS/VSAM is an example of the _____. • hierarchical model • file system data model • XML data model • relational data model An implementation-ready data model needn't necessarily contain enforceable rules to guarantee the integrity of the data. • True • False The object-oriented data model was developed in the _____. • 1980s • 1960s • 1990s • 1970s
DAT 380 Wk 1 - Practice: Critical Thinking Exercises
DAT 380 Wk 1 - Apply Problems
DAT 380 Wk 2 - Practice Knowledge Check The row's range of permissible values is known as its domain. • True
•
False
RDBMSs enforce integrity rules automatically. • True • False Character data can contain any character or symbol intended for mathematical manipulation. • True • False _____, also known as RESTRICT, yields values for all rows found in a table that satisfy a given condition. • UNION • DIFFERENCE • INTERSECT • SELECT A weak relationship exists if the primary key of the related entity contains at least one primary key component of the parent entity. • True • False Only a single attribute, not multiple attributes, can define functional dependence. • True • False _____ returns only the attributes requested, in the order in which they are requested. • SELECT • UNION • PROJECT • DIFFERENCE A data dictionary is sometimes described as "the database designer's database" because it records the design decisions about tables and their structures. • True • False In the relational model, _____ are important because they are used to ensure that each row in a table is uniquely identifiable. • keys • relations • logical structures • indexes
A _____ relationship exists when an association is maintained within a single entity. • ternary • unary • weak • strong
DAT 380 Wk 2 - Practice: Critical Thinking Exercises
DAT 380 Wk 2 - Apply: Problems
DAT 380 Wk 3 - Practice: Knowledge Check Repeating groups must be eliminated by ensuring that each row defines a single entity. True False The purpose of an entity _____ is to simplify an entity-relationship diagram (ERD) and thus enhance its readability. • interface • cluster • constraint • discriminator Within a specialization hierarchy, every subtype can have _____ supertype(s) to which it is directly related. • one or many • zero • only one • many A subtype contains attributes that are common to all of its supertypes. • True • False
In the context of total completeness, in a(n) _____, every supertype occurrence is a member of only one subtype. foreign key constraint nonunique constraint overlapping constraint disjoint constraint A table that is in 2NF and contains no transitive dependencies is said to be in _____. • 2NF • 3NF • 1NF • 4NF To model time-variant data, one must create a new entity in an M:N relationship with the original entity. • True • False In a _____ situation, one key determines multiple values of two other attributes and those attributes are independent of each other. transitive dependency multivalued dependency functional dependency partial dependency One important inheritance characteristic is that all entity subtypes inherit their primary key attribute from their supertype. • True • False One important inheritance characteristic is that all entity subtypes inherit their _____ key attribute from their supertype. • natural • foreign • primary • surrogate
DAT 380 Wk 3 - Practice: Critical Thinking Exercises
DAT 380 Wk 3 - Apply: Problems DAT 380 Wk 4 - Practice: Knowledge Check The special operator used to check whether a subquery returns any rows is _____. • IN • EXISTS • BETWEEN • LIKE ANSI-standard SQL allows the use of special operators in conjunction with the WHERE clause. • True • False You can select partial table contents by naming the desired fields and by placing restrictions on the rows to be included in the output. • True • False A database language enables the user to perform complex queries designed to transform the raw data into useful information. • True • False Which query is used to list a unique value for V_CODE, where the list will produce only a list of those values that are different from one another? • SELECT UNIQUE V_CODE FROM PRODUCT; • SELECT DISTINCT V_CODE FROM PRODUCT; • SELECT DIFFERENT V_CODE FROM PRODUCT; • SELECT ONLY V_CODE FROM PRODUCT; In Oracle, _____ make(s) it possible to merge SQL and traditional programming constructs, such as variables, conditional processing (IF-THEN-ELSE), basic loops (FOR and WHILE loops,) and
error trapping. • Procedural Language SQL • embedded SQL • dynamic SQL • stored procedures All changes in a table structure are made using the _____ TABLE command, followed by a keyword that produces the specific changes a user wants to make. • ALTER • UPDATE • ROLLBACK • COMMIT The _____ constraint is used to validate data when an attribute value is entered. • UNIQUE • CASCADE • SET NULL • CHECK _____ is a relational set operator. • EXISTS • ALL • PLUS • EXCEPT The SQL data manipulation command HAVING: • restricts the selection of grouped rows based on a condition. • modifies an attribute's values in one or more table's rows. • groups the selected rows based on one or more attributes. • restricts the selection of rows based on a conditional expression.
DAT 380 Wk 4 - Practice: Critical Thinking Exercises
DAT 380 Wk 4 - Apply: Coding Labs DAT 380 Wk 5 - Practice: Knowledge Check In the Systems Development Life Cycle(SDLC), the design of the system's processes begins in the detailed systems design phase. • True
•
False
Training principles and methodologies are planned during the _____ phase of the Systems Development Life Cycle (SDLC). • analysis • detailed systems design • maintenance • implementation Producing the required information flow is part of the _____ phase of the Database Life Cycle (DBLC). • testing and evaluation • operation • database initial study • database design _____ is the process of determining the data storage organization and data access characteristics of the database to ensure its integrity, security, and performance. • Conceptual design • Physical design • Network design • Logical design The term "database development" is used to describe the process of database design and implementation. • True • False In the detailed systems design phase of the Systems Development Life Cycle (SDLC), steps are laid out for the conversion of a database from an old system to a new system. • True • False Selecting database management system (DBMS) software is part of the _____ phase of the Database Life Cycle (DBLC). • database design • database initial study • testing and evaluation • implementation and loading Systems analysis establishes the need for an information system and its extent. • True • False
During decentralized design, after the _____ has been completed, all modules are integrated into one conceptual model. • logical process • declaration process • verification process • conceptual process A system is always at some stage of SDLC because every request for structural changes requires retracing the steps of the Systems Development Life Cycle (SDLC). • True • False
DAT 380 Wk 5 - Practice: Critical Thinking Exercises
DAT 380 Wk 5 - Apply - Post-Course Assessment Quiz 1 Data is said to be verifiable if: • the data always yields consistent results. • the data is obtained from trusted sources. • the data is stored in different places within the database. • the data cannot be changed or manipulated. 2 The database contents might be loaded interactively or in batch mode using a variety of methods and devices including customized user programs. • True • False 3 Database designers determine the data and information that yield the required understanding of the entire business. • True • False 4 During the _____ phase of the Systems Development Life Cycle (SDLC), the hardware, database management system (DBMS) software, and application programs are installed, and the database design is implemented. • analysis • detailed systems design
• •
maintenance implementation
5 Data integrity is enforced by the database management system (DBMS) through the proper use of primary and foreign key rules. • True • False 6 In the context of partial dependencies, data redundancies occur because every row entry requires duplication of data. • True • False 7 Relational algebra defines the theoretical way of manipulating table contents using relational operators. • True • False 8 The _____ command restricts the selection of grouped rows based on a condition. • HAVING • DISPLAY • CONVERT • FROM 9 The _____ command defines a default value for a column when no value is given. • UNIQUE • CHECK • DEFAULT • NOT NULL 10 After the initial declarations in Database Life Cycle (DBLC), the database designer must carefully probe in order to generate additional information that will help define the problem within the larger framework of company operations. • True • False 11 The special operator used to check whether an attribute value is within a range of values is _____.
• •
IN NULL
12 VMS/VSAM is an example of the _____. • hierarchical model • file system data model • XML data model • relational data model 13 A table where all attributes are dependent on the primary key but are independent of each other, and no row contains two or more multivalued facts about an entity is said to be in _____. • 3NF • 2NF • 4NF • 1NF 14 To implement a small database, a database designer must know the "1" and the "M" sides of each relationship and whether the relationships are mandatory or optional. • True • False 15 An operational database is sometimes referred to as an enterprise database. • True • False 16 A _____ is a block of code containing standard SQL statements and procedural extensions that is stored and executed at the DBMS server. • persistent storage module (PSM) • base table • statement-level trigger • cursor-style process 17 The default comparison condition for the subtype discriminator attribute is the _____ comparison. • greater than • nonequality • equality • less than
18 In the Systems Development Life Cycle (SDLC), problems defined during the planning phase are examined in greater detail during the analysis phase. • True • False 19 A design trap occurs when a relationship is improperly or incompletely identified and is therefore represented in a way that is not consistent with the real world. • True • False 20 The entity supertype contains common characteristics, and the entity subtypes each contain their own unique characteristics. • True • False 21 Ideally, an entity identifier is composed of _____ attribute(s). • two • six • three • one 22 The idea of determination is unique to the database environment. • True • False 23 In the context of total completeness, in a(n) _____, every supertype occurrence is a member of only one subtype. • foreign key constraint • nonunique constraint • overlapping constraint • disjoint constraint 24 Structural dependence exists when it is possible to make changes in the file structure without affecting the application program's ability to access the data. • True • False
25 Today, most relational database products can be classified as object/relational. • True • False
DAT 380 Wk 5 - Apply: Coding Labs Click the MindTap Access in the Course Content section to locate this assignment. Complete the assignments in the Wk 5 – Apply folder.