University of Texas, Arlington CS 2203 Final Exam4 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 31 1.00 A publishing company produces academic books on v... arious subjects. Books are written by authors who specialise in one or more particular subject. The company employs a number of editors who do not have particular specialisations but who take sole responsibilty for for editing one or more publications. A publication covers a single subject area but may be written by one or more author - the contribution of each author is recorded as a percentage for the purposes of calculating royalties. The following ER diagram is intended to represent the above speciÕcation: Indicate the relation which has an incorrect cardinality shown: Select one: a. specialises in b. makes c. is about d. to e. None of the Above Question 32 1.00 Question 33 1.00 Question 34 1.00 Which SQL statement is used to remove data from a database? Select one: a. DELETE b. REMOVE c. TRUNCATE d. DEL With SQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"? Select one: a. SELECT * FROM Persons SORT BY 'FirstName' DESC b. SELECT * FROM Persons ORDER BY FirstName DESC c. SELECT * FROM Persons ORDER FirstName DESC d. SELECT * FROM Persons SORT 'FirstName' DESC In one-to-many relationship the table in ‘one’ side is called _______ and on ‘many’ side is called _______ Select one: a. Child , Parent b. Parent , Child c. Brother , Sister d. Father , Son Question 35 1.00 Question 36 1.00 Question 37 1.00 Which of the Following Is Not A Database Model? Select one: a. Network Database Model b. Relational Database Model c. Object Oriented Database Model d. None of the above SQL stands for Select one: a. Sequential Query Language b. Structured Question Language c. Structured Query Language d. Sequential Question Language According to the entity integrity constraint, primary keys can take on any value from the set {null, 0 ... inÕnity} Select one: True False Question 38 1.00 Question 39 1.00 Question 40 1.00 Jump to... Consider the table (Relation) CLASSES CLASSREF (Key Field) CLASS_TITLE TUTOR_ID ROOM_ID Why is the class title not suitable as a key Õeld? Select one: a. The key Õeld needs to be a unique number b. The key Õeld has to be an extra Õeld to the actual data that we store about classes c. It is likely that as time passes, we'll need to add more classes with diàerent names to our CLASSES table. d. It is possible to have more than one class with the same name (e.g. a database design class could run on Monday for one group and on Tuesday for another group) What does a view allow you to do? Select one: a. See the contents of a database table b. Make changes to a database table c. Sort a database table d. All of the above Foreign keys are not necessary in relational databases. Select one: True False [Show More]

Last updated: 1 year ago

Preview 1 out of 5 pages