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

Document Content and Description Below

CS 2203 Databases 1 - Term 5, 2018-2019 CS 2203 - AY2019-T5 ► Final Exam (Days 1 - 4) ► Final Exam 1.00 In the right outer join, all of the rows of all of the tables are included in the out... put regardless of whether they matched or not (True/False)? Select one: True False A lack of normalisation can lead to which one of the following problems Select one: a. Lost Updates b. Deletion of data c. Insertion problems d. Deadlock conditions How can you change "Hansen" into "Nilsen" in the "LastName" column in the Persons table? Select one: a. UPDATE Persons SET LastName='Hansen' INTO LastName='Nilsen' b. UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen' c. MODIFY Persons SET LastName='Hansen' INTO LastName='Nilsen d. MODIFY Persons SET LastName='Nilsen' WHERE LastName='Hansen' The JDBC API is a Java API that can access any kind of tabular data, especially data stored in a relational database. Select one: True False Question 25 1.00 Question 26 1.00 Question 27 1.00 Question 28 1.00 An atomic Õeld is Select one: a. a single valued Õeld b. a key Õeld c. a numerical Õeld d. a key that contains only a single Õeld cascade update option (in the context of referential integrity) Select one: a. means do not change the value in the primary key Õeld if that record has related records in another table b. means change all the related records in child tables if the record in parent table is changed c. Both of above d. None of above With SQL, how can you insert "Olsen" as the "LastName" in the "Persons" table? Select one: a. INSERT INTO Persons (LastName) VALUES ('Olsen') b. INSERT ('Olsen') INTO Persons (LastName) c. INSERT INTO Persons ('Olsen') INTO LastName d. None of the above Which of the following statements is true concerning subqueries? Select one: a. Involves the use of an inner and outer query. b. Cannot return the same result as a query that is not a subquery. c. Does not start with the word SELECT. d. All of the above. Question 29 1.00 Question 30 1.00 Foreign keys uniquely identify records. Select one: True False Consider the following relation: Repayment(borrower_id,name,address,loanamount,requestdate,repayment_date,repayment_amount) Which of the following SQL statements will return all the tuples with information on repayments from borrower_id equal to 42, and where the lent amount exceeds 1000 USD. Choice 1: SELECT sum(repayment_amount) FROM Repayment WHERE borrower_id=42 AND loanamount>1000; Choice 2: SELECT * FROM Repayment WHERE borrower_id=42 AND loanamount>1000; Choice 3: SELECT sum(loanamount) FROM Repayment WHERE borrower_id==42 AND loanamount>1000; Choice 4: SELECT * FROM r.Repayments WHERE r.borrower_id=42 AND r.loanamount<1000; Select one: a. Choice 1 b. Choice 2 c. Choice 3 d. Choice 4 e. None of the Above [Show More]

Last updated: 1 year ago

Preview 1 out of 4 pages