Quiz 1

.docx

School

Arizona State University *

*We aren’t endorsed by this school

Course

511

Subject

Computer Science

Date

Jan 9, 2024

Type

docx

Pages

4

Uploaded by ChiefPheasantPerson1012

Report
1. Which of the following is a correctly formatted database query? Is there a correlation between oil prices and temperature? What is the name of the student with ID number 2357? What is the best U.S. state for retirement? What will be the temperature in New York City tomorrow? 2. What is the role of a relationship in a database? It is part of a relation. It connects two entities. It connects two attributes. It helps users connect to a remote database. 3. Which of the following can be an entity name in a database? Age First Name Student Gender 4. What is required in order to use the cartesian product operator on two relations? The number of tuples in each relation must be the same. The number of attributes in each relation must be the same. There must be at least one common attribute in the two relations. It can be applied to any two relations without a requirement. 5. Consider two relations A and B in a database. Relation A has 5 rows and relation B has 3 rows. How many rows are produced if we apply the cartesian product operation to A and B? 3 15 8 5 6. You are given the following two relations A and B. What is the cartesian product of A and B, AXB? Merge them into the table 7. Which mathematical operator must be used in order to display information about students who are majoring in Computer Science but not in Electrical Engineering? Difference Cartesian Product Union Intersection 8. Which statement about the selection operator is true? It requires more than one relation as its input. It filters certain tuples in a relation based on given criteria. It requires more than one database as its input. It filters certain attributes in a relation based on given criteria.
9. Which mathematical operator must be used in order to display information about students who are majoring in both Computer Science and Electrical Engineering? Intersection Cartesian Product Union Difference 10. Which mathematical operation must be completed before the ϴ-Join operation? Union Intersection Cartesian product Multiplication 11. For which of the following functions require database management software because typical spreadsheet software cannot implement it? Store data Search data Create multiple user types Update data 12. What connects two entities in a database? Relationship Relation Table Record 13. What is the name of the operation used for joining two relations? α-Join β-Join ⋈-Join ϴ-Join 14. Which operator must be used to display information about students majoring in Mathematics or Physics? Intersection Difference Cartesian Product Union 15. Which of the following two operators must be used one after another? Cartesian Product, Multiplication Union, ϴ-Join Multiplication, ϴ-Join Cartesian Product, ϴ-Join 16. What must be listed after the SELECT command in a SQL query? Records Tables
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help