Quiz 1

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

21. A particular query that pulls information from one or more tables is an example of a: ● Physical Schema ● Relation ● View ● Conceptual Schema 22. Which of the following database types is most oriented toward storing well-structured data? ● NoSQL Database ● Relational Database ● Spark ● Hadoop 23. A participation constraint is indicated by _____ in an ER diagram. ● A dashed line ● A bold line ● A dotted line ● A line 24. What does the relational algebra operator ‘x’ indicate? ● The union of the two tables ● The intersection of the two tables ● All pairs from the two tables matched on a specified field ● All possible pairs from the two tables 25. The basic syntax for an SQL query is: ● DISTINCT, FIELD, ID ● SELECT, FROM, WHERE ● DISTINCT FROM QUALIFICATION ● TARGET, RELATION, DISTINCT 26. What kind of software should be used if one needs to store data online, make certain parts of it accessible by different user types, searchable? ● Presentation software ● Spreadsheet software ● Word processing software ● DBMS 27. What is a characteristic of big data? ● Data comes from different sources in different formats ● Data growth is at a constant rate ● Data comes from different sources in standard formats 28. Which of the following is true about data schemas? ● There may be multiple conceptual schemas for a given database ● There may be multiple internal schemas for a given database ● There may be multiple physical schemas for a given database ● There may be multiple external schemas for a given database