WGU D426 - Assessment

D426 - Assessment (1 review) Students also studied Terms in this set (69) 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 Data M 183 term And Practice questions for this set Learn1 / 7Study using Learn Which of the following statements concerning the primary key is true?A record consists of a?Set of one or more fields A DBMS performs several important functions that guarantee the integrity and consistency of the data in the database. Which of the following is NOT one of those functions?Data reports Choose an answer 1All primary key entries are unique2Primary key entries can be null 3All primary key entries are duplicated4Some primary key entries are optional Don't know?

Which item is unstructured data?A video

Data is/are:Raw facts

Which classification is correct for the box marked "Registration" in the given E-R Diagram?Intersection Which type of relationship exists between Student and Course?Many-to-many binary What is the E-R Diagram about an online pet food vendor showing?One Invoice Line must include a minimum of one and a maximum of one Item.A pet owner can have many pets; a specific pet is linked to one pet owner.One-to-many Database models were developed to?Model real-world events or conditions What is the correct way to read the modality on the right side of the association?A minimum of zero activities What is the modality of Volunteer?At least one What type of relationship is expressed with the phrase "A Painter paints one or more Paintings"?

1:M

The entity integrity rule requires that?All primary key entries are unique What does the 'refer' in referential integrity mean? A foreign key in a table must refer to a valid primary key in another table.A table is perceived as a?Two-dimensional structure Another word for the term "relation" is?Table

DISTINT filters the results to remove duplicates. ORDER BY?Modifies the presentation by changing the order of the result set.A primary key?Must be unique A table can be logically connected to another table by defining a?Common attribute A relational operator that allows for the combination of information from two or more tables is known as the ____ operator?Join Which of the following statements concerning the primary key is true?All primary key entries are unique We can describe a link by observing that ____. A primary key of one table appears again as a foreign key in a related table When designing a new database, it is a good idea to ____ Minimize data redundancy An attribute (or combination of attributes) that uniquely identifies each entity in a table is called a ____.Superkey A foreign key must ____.Match the value of a primary key in a related table The ERD is used to graphically represent the ____ database model.Conceptual A derived attribute ____.Need not be physically stored within the database A relationship is an association between ____.Entities A ____ key is a key that consists of more than one attribute. Composite A ____ attribute is one that cannot be subdivided. Atomic If an entity can exist apart from one or more related entities, it is said to be ____-independent.Existence A ____ relationship exists when three entities are associated.Ternary The set of possible values for an attribute is a ____. Domain Which attribute(s) make up the primary key in the table

definition:

CLASS (CRS_CODE, CLASS_SECTION, CLASS_TIME,

CLASS_ROOM, PROF_NUM)

CRS_CODE and CLASS_SECTION

A table that has all key attributes defined, has no repeating groups, and all its attributes are dependent on the primary key, is said to be in ____.1NF A table that is in 2NF and contains no transitive dependencies is said to be in ____.3NF Data redundancy produces ____.Data integrity problems Normalization works through a series of normal ____. Forms Dependencies based on only a part of a composite primary key are called ____ dependencies.Partial Given the table EMP_PROJ (PROJ_NUM, EMP_NUM, PROJ_NAME, EMP_NAME, PROJ_START, HOURS), which of the following is a partial dependency?PROJ_NUM --> PROJ_NAME

A relation is not in 1NF if:There are repeating groups in the table

The SQL command that lets you insert data into a table, one row at a time, is ____.

INSERT

The SQL command that enables you to make changes in the data is ____.

UPDATE

To list all the contents of the PRODUCT table, you would use ____.

SELECT * FROM PRODUCT;

Which command would you use when making corrections to the PRODUCT table?

UPDATE PRODUCT

SET P_INDATE = '01/18/2004'

WHERE P_CODE = '13-Q2/P2';

Which command would be used to delete the table row where the P_Code = '2238/QPD'?

DELETE FROM PRODUCT

WHERE P_CODE = '2238/QPD';

Which command is used to select partial table contents? SELECT FROM