Exam 3: CIW v5 Database Design Specialist

Consider the Registration relation shown in the exhibit. Which of the following SQL statements would return all tuples that have course codes beginning with the letter M?

Which term describes an attribute or combination of attributes that uniquely identifies a row in a relation?

Which term best defines a database system in which data records are stored in one or more files with no structured relationship?

Consider the Registration relation shown in the exhibit. Which of the following SQL statements would return all tuples that have course codes beginning with the letter M?

Consider the Information Engineering diagram in the exhibit showing the relations BUILDING and RESIDENT. What is the relationship between BUILDING and RESIDENT?

Which statement best describes a candidate key?

Which area of database security involves maintaining access to enterprise data?

Consider the following table as well as the Dept1_Parts and Dept2_Parts relations shown in the exhibit: Which of the following relational algebraic expressions would result in the given table?

FROM Registration WHERE Consider the following relational algebraic expression: Which of the following SQL Course_Code = 'A4343'; statements is equivalent to this relational algebraic expression?

The creation of intermediate entities occurs during the logical database design phase for an enterprise. It is used to resolve which types of relationships?

You enterprise must decide whether to use a database management system. Which of the following lists four advantages of using a DBMS?

Consider the relation shown in the exhibit. Which of the following SQL statements would properly remove all tuples for New York customers?

Consider the following DBDL description of an entity: Teachers (teach_num: variable length character string length 10 NOT NULL teach_name: variable length character string length 10 NOT NULL) Primary Key: teach_num which integrity constraint is satisfied?

Consider the following four database design activities: 1 - Design user views. 2 - Select a DBMS. 3 - Apply normalization. 4 - Determine entities. Which choice shows the correct ordering of these activities, from first to last, by assigned numbers?

In a relational database, which term describes a single table consisting of rows and columns?

What is the most important service provided by a database management system?

Which pair of relational algebraic operations requires union compatibility?

A large enterprise uses a two-tier database architecture and runs complex database applications. Which term best describes the client in this system?

Consider the Recreation relation shown in the exhibit. You need to apply a SQL statement to the Recreation relation that will return the following data: Which SQL statement applied to the Recreation relation will return this data?

Consider the symbols shown in the exhibit. Which of the following correctly identifies these symbols when used in an entity-relationship (ER) diagram?