MIS 311 Quiz3

MIS 311 Quiz3 - Conceptual Unit 3 - The Relational Database...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Conceptual Unit 3 - The Relational Database Model Compiled By: Irfan A. Ilyas TRUE/FALSE 1. Most of the commercial software implementations of the relational algebra operators yield listings and new tables. ANS: F 2. The final outcome of a natural JOIN operation yields a table that does not include the unmatched row. ANS: T 3. The final outcome of a natural JOIN yields a table that provides only the copies of the unmatched pairs. ANS: F 4. Another form of JOIN, known as equijoin, links tables on the basis of an equality condition that compares specified columns of each table. ANS: T 5. In a relational table, each table must have an attribute or a combination of attributes that uniquely identifies each row. ANS: T 6. In a relational table, each table row ( tuple ) does not necessarily represent a single entity occurrence within the entry set. ANS: F 7. In a relational table, each column represents an attribute and each column has a distinctive name. ANS: T 8. In a relational table, each row/column intersection represents a single data value. ANS: T 9. In a relational table, each value in a column must conform to the same data format. ANS: T 10. Each column in a relational table has a specific range of values knows as the attribute object. ANS: F 11. The order of the rows and columns in a relational table is immaterial to the DBMS.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
ANS: T 12. Some older DBMSs might impose constraints restricting the table names to ten characters. ANS: F 13. Some older DBMSs might impose constraints restricting the column names to ten characters. ANS: T 14. Some older DBMSs impose constraints that allow column names to start with a digit. ANS: F 15. Numeric data are data on which you can perform meaningful arithmetic procedures. ANS: T 16. Character data can contain any character or symbol intended for mathematical manipulation. ANS: F
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 07/27/2011 for the course BUS 173 taught by Professor Essiahamouda during the Winter '11 term at UC Riverside.

Page1 / 6

MIS 311 Quiz3 - Conceptual Unit 3 - The Relational Database...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online