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

Document Content and Description Below

CS 2203 Databases 1 - Term 5, 2018-2019 Home ► My courses ► CS 2203 - AY2019-T5 ► Final Exam (Days 1 - 4) ► Final Exam Question 41 Answer saved Marked out of 1.00 Question 42 Answer s... aved Marked out of 1.00 Question 43 Answer saved Marked out of 1.00 Consider the table (Relation) STUDREC SREF (Key Field) INITIAL SURNAME DATEOFBIRTH GENDER RESIDENCE KIDS HOMETOWN DISTANCE The key is SREF (student reference number). This table is in Select one: a. Õrst normal form b. second normal form c. third normal form d. None of the above Which of the following statements best decribes the function of an entity relation model? Select one: a. An ER model is concerned primarily with a physical implementation of the data and secondly with the logical view b. An ER model is concerned primarily with a logical view of the data and secondly with the physical implementation c. An ER model provides a view of the logic of the data and not the physical implementation d. An ER model is entirely concerned with modelling the physical implemetation A Database Language Concerned With The DeÕnition Of The Whole Database Structure And Schema Is ________ Select one: a. DCL b. DML c. DDL d. All of the above Question 44 Answer saved Marked out of 1.00 Question 45 Answer saved Marked out of 1.00 Question 46 Answer saved Marked out of 1.00 Question 47 Answer saved Marked out of 1.00 The unique constraint speciÕes that the value of an attribute must be diàerent from all other values of the same attribute that exist within a relation. Select one: True False Which view of information deals with how the information is physically arranged, stored, and accessed? Select one: a. Physical View b. Logical View c. Information View d. None of the Above The rule that requires that each non-key Õeld (attribute) should be fully functionally dependent on the primary key is Select one: a. Õrst normal form b. second normal form c. third normal form d. None of the Above How many tables may be included with a join? Select one: a. One b. Two c. Three d. All of the above Question 48 Answer saved Marked out of 1.00 Question 49 Answer saved Marked out of 1.00 Question 50 Answer saved Jump to... Which of the following is NOT a type of SQL constraint? Select one: a. PRIMARY KEY b. FOREIGN KEY c. ALTERNATE KEY d. UNIQUE Given a relation country(name, continent, population) which of the following is a valid SQL statement? Select one: a. SELECT continent, population FROM country GROUP BY continent b. SELECT continent, SUM(population) FROM country GROUP BY continent c. SELECT name, population FROM country GROUP BY continent d. SELECT name, SUM(population) FROM country GROUP BY continent e. None of the above OR more than one of the above This Key Uniquely IdentiÕes Each Record Select one: a. Primary Key b. Key Record c. Unique Key d. Field Name CS 2203 Databases 1 - Term 5, 2018-2019 Home ► My courses ► CS 2203 - AY2019-T5 ► Final Exam (Days 1 - 4) ► Final Exam Question 41 Answer saved Marked out of 1.00 Question 42 Answer saved Marked out of 1.00 Question 43 Answer saved Marked out of 1.00 Consider the table (Relation) STUDREC SREF (Key Field) INITIAL SURNAME DATEOFBIRTH GENDER RESIDENCE KIDS HOMETOWN DISTANCE The key is SREF (student reference number). This table is in Select one: a. Õrst normal form b. second normal form c. third normal form d. None of the above Which of the following statements best decribes the function of an entity relation model? Select one: a. An ER model is concerned primarily with a physical implementation of the data and secondly with the logical view b. An ER model is concerned primarily with a logical view of the data and secondly with the physical implementation c. An ER model provides a view of the logic of the data and not the physical implementation d. An ER model is entirely concerned with modelling the physical implemetation A Database Language Concerned With The DeÕnition Of The Whole Database Structure And Schema Is ________ Select one: a. DCL b. DML c. DDL d. All of the above Question 44 Answer saved Marked out of 1.00 Question 45 Answer saved Marked out of 1.00 Question 46 Answer saved Marked out of 1.00 Question 47 Answer saved Marked out of 1.00 The unique constraint speciÕes that the value of an attribute must be diàerent from all other values of the same attribute that exist within a relation. Select one: True False Which view of information deals with how the information is physically arranged, stored, and accessed? Select one: a. Physical View b. Logical View c. Information View d. None of the Above The rule that requires that each non-key Õeld (attribute) should be fully functionally dependent on the primary key is Select one: a. Õrst normal form b. second normal form c. third normal form d. None of the Above How many tables may be included with a join? Select one: a. One b. Two c. Three d. All of the above Question 48 Answer saved Marked out of 1.00 Question 49 Answer saved Marked out of 1.00 Question 50 Answer saved Jump to... Which of the following is NOT a type of SQL constraint? Select one: a. PRIMARY KEY b. FOREIGN KEY c. ALTERNATE KEY d. UNIQUE Given a relation country(name, continent, population) which of the following is a valid SQL statement? Select one: a. SELECT continent, population FROM country GROUP BY continent b. SELECT continent, SUM(population) FROM country GROUP BY continent c. SELECT name, population FROM country GROUP BY continent d. SELECT name, SUM(population) FROM country GROUP BY continent e. None of the above OR more than one of the above This Key Uniquely IdentiÕes Each Record Select one: a. Primary Key b. Key Record c. Unique Key d. Field Name [Show More]

Last updated: 1 year ago

Preview 1 out of 3 pages