Test#1 CS488 Fall 2018 Test#1(50 Points) C$488 Database Systems Fall 2018 Student Name: Amor ez Mood Arnor te2 M Grade Grade: 50 A. Multiple-Choice Questiens (Total 20 points, 2 points per question) Select the best answer to each question and write its letter in the table below Questions Answer provide a description of the data characteristics and the set of relationships that link the data found within the database. a. Queries b. End-user data c. Metadata d. Schemas 2. From a database point of view, the collection of data becomes meaningful only when it reflects properly defined a. business rules b. business norms c. business goals d. business plans 3. A(a) enables a database administrator to describe schema -- a extensible markup language (XML.) c. unified modeling language (UML) b. data definition language (DDL) d.query language 4. Referential dictates that the foreign key must contain values that match the primary key in the related table, or must contain null. a. integrity b. uniqueness c. modeld. Attribute 5. The CUSTOMER table's primary key is CUS CODE. The CUSTOMER primary key column has no null entries, and all entries are unique. This is an example of a. entity c. relational d. Nul integrity. b. referential 6. also known as RESTRICT, yields values for all rows found in a table that satisfy a given condition (i.e. a horizontal subset of the original table). a, INTERSECT b, UNION c. DIFFERENCE d. SELECT returns only the attributes requested (i.e. a vertical subset of the original table), in the order in which they are requested a. PROJECT b. SELECT c. UNION d.DIFFERENCE