University of Texas, Arlington CS 2203 Final Exam1. 10Q&A. Score 100%.

Document Content and Description Below

University of Texas, Arlington CS 2203 Final Exam1 Home ► My courses ► CS 2203 - AY2019-T5 ► Final Exam (Days 1 - 4) ► Final Exam Question 1 Answer saved Marked out of 1.00 Question 2 A... nswer saved Marked out of 1.00 Question 3 Answer saved Marked out of 1.00 With SQL, how can you delete the records where the "FirstName" is "Peter" in the Persons Table? Select one: a. DELETE FROM Persons WHERE FirstName = 'Peter' b. DELETE ROW FirstName='Peter' FROM Persons c. DELETE FirstName='Peter' FROM Persons d. None of the above If a piece of data is stored in two places in the database, then Select one: a. storage space is wasted b. changing the data in one spot will cause data inconsistency c. it can be more easily accessed d. both a and b The inner join is typically the most common form of join used in application queries (true/false)? Select one: True False CS 2203 Databases 1 - Term 5, 2018-2019 Question 4 Answer saved Marked out of 1.00 Question 5 Answer saved Marked out of 1.00 Question 6 Answer saved Marked out of 1.00 An athletics meeting involves several competitors who participate in a number of events. The database is intended to record who is to take part in which event and to record the outcome of each event. As results become available the winner attribute will be updated with the cid of the appropriate competitor. Competitor(cid, name, nationality) Event(eid, description, winner) Compete s(cid, eid) Competitor cid name nationality 01 Pat British 02 Hilary British 03 Sven Swedish 04 Pierre French Event eid description winner 01 running 02 jumping 03 throwing Competes cid eid 01 01 02 01 03 02 04 02 04 03 Select one: a. A numeric attribute should be added to the Competes table b. A numeric attribute should be added to the Event table c. A numeric attribute should be added to the Competitor table d. Three numeric attribute should be added to the Competitor table e. Two numeric attributes should be added to the Competitor table A unary relationship describes a table that joins to itself (True/False)? Select one: True False It is impossible to represent a one-to-one relationship in a relational schema. Select one: True False This study source was downloaded by 100000806173026 from CourseHero.com on 12-15-2021 12:00:01 GMT -06:00 https://www.coursehero.com/file/59253814/Final-Exam1pdf/ 8/16/2019 Final Exam https://my.uopeople.edu/mod/quiz/attempt.php?attempt=2073147&cmid=177522 3/5 Question 7 Answer saved Marked out of 1.00 If an attribute depends on only part of a multi-valued key, then it should be removed to a separate relation. This is an action that is taken during normalization to which normal form? Select one: a. 1NF (First normal form) b. 2NF (second normal form) c. 3NF (3rd Normal Form) d. None of the above This study source was downloaded by 100000806173026 from CourseHero.com on 12-15-2021 12:00:01 GMT -06:00 https://www.coursehero.com/file/59253814/Final-Exam1pdf/ 8/16/2019 Final Exam https://my.uopeople.edu/mod/quiz/attempt.php?attempt=2073147&cmid=177522 4/5 Question 8 Answer saved Marked out of 1.00 Consider the table (STUDREC). SREF INIT SNAME DOB GENDER RES KIDS TNAME STUDREC 1 TJ OSMAN 29/09/1953 M 0 0 Millhouse Green 2 S LANGLEY 21/08/1957 F 0 0 HUDDERSFIELD 3 H WILSON 07/07/1962 M 1 1 HUDDERSFIELD 4 J CARTER 21/03/1954 F 1 2 BARNSLEY 5 A jones 10/11/1948 F 1 2 SHEFFIELD 6 S ISHEMO 05/12/1950 M 0 0 LEEDS 7 K ARNOTT 01/08/1960 F 1 2 SHEFFIELD 8 B ARNOTT 23/05/1962 F 1 1 Leeds 9 N GREEN 30/09/1958 M 1 1 SHEFFIELD 10 H JACKSON 21/04/1941 M 1 0 SHEFFIELD 11 A ARNOTT 23/08/1954 M 1 2 BARNSLEY 12 N HEY 10/10/1955 F 0 0 SILKSTONE 13 K WILSON 13/03/1965 M 0 2 BARNSLEY 14 J BROWN 29/09/1953 F 1 1 BARNSLEY 15 A ARNOTT 23/08/1954 F 0 1 BARNSLEY 16 G WHITE 03/03/1965 M 1 3 BARNSLEY 17 J GREEN 06/08/1969 F 0 0 BARNSLEY 18 J GREEN 09/08/1945 M 0 0 BARNSLEY 19 F WATSON 03/03/1958 M 1 1 THURLSTONE 20 L HARVEY 03/08/1954 F 0 2 THURLSTONE 21 T MOSLEY 31/10/1975 M 1 2 Silkstone 22 J POWERS 30/08/1945 M 1 0 HENDON 23 J CHESTER 15/03/1960 M 0 0 BARNSLEY Which of the following statements will list all students born between 1953 and 1959 Select one: a. Select * from studrec where studrec.DOB > 01/01/1953 AND studrec.DOB > 31/12/1959; Question 9 Answer saved Marked out of 1.00 Question 10 Answer saved Marked out of 1.00 ◄ Review Quiz Jump to... b. Select * from studrec where studrec.DOB > 01/01/1953 OR studrec.DOB < 31/12/1959 c. Select * from studrec where studrec.DOB >= 01/01/1953 AND studrec.DOB <= 31/12/1959 d. All of the above With SQL, how do you select a column named "FirstName" from a table named "Persons"? Select one: a. EXTRACT FirstName FROM Persons b. SELECT FirstName FROM Persons c. SELECT Persons.FirstName d. UNION Persons.FirstName Primary keys perform the unique identiÕcation function in the relational model. Select one: True False [Show More]

Last updated: 1 year ago

Preview 1 out of 5 pages