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

Document Content and Description Below

Home ► My courses ► CS 2203 - AY2019-T5 ► Final Exam (Days 1 - 4) ► Final Exam CS 2203 Databases 1 - Term 5, 2018-2019 Question 11 Question 12 Question 13 Answer saved Marked out of 1.0... 0 What SQL structure is used to limit column values of a table? Select one: a. The LIMIT constraint b. The CHECK constraint c. The VALUE constraint d. None of the above is correct. Which SQL statement is used to delete data from a database? Select one: a. delete b. remove c. collapse d. truncate To transform a relation from second normal form to third normal form we must remove which one of the following? Select one: a. All partial-key dependencies b. All inverse partial-key dependencies c. All repeating groups d. All transitive dependencies Question 14 Question 15 Answer saved Marked out of 1.00 Question 16 Which of the following are valid CREATE statements in the world of DDL? Select one: a. CREATE SCHEMA b. CREATE TABLE c. CREATE DOMAIN d. CREATE INDEX e. All of the above With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"? Select one: a. SELECT [all] FROM Persons WHERE FirstName='Peter' b. SELECT * FROM Persons WHERE FirstName LIKE 'Peter' c. SELECT [all] FROM Persons WHERE FirstName LIKE 'Peter' d. SELECT * FROM Persons WHERE FirstName='Peter' The left outer join is one type of outer join. Another one is the. Select one: a. right b. full c. right outer d. full outer e. all of the above Question 17 Question 18 Answer saved Question 19 1.00 A user is setting up a join operation between tables EMP and DEPT. There are some employees in the EMP table that the user wants returned by the query, but the employees are not assigned to departments yet. Which SELECT statement is most appropriate for this user? Select one: a. select e.empid, d.head from emp e, dept d; b. Select e.empid, d.head from emp e, dept d where e.dept# = d.dept#; c. Select e.empid, d.head from emp e, dept d where e.dept# (+) = d.dept#; d. Select e.empid, d.head from emp e right outer join dept d on e.dept# = d.dept#; Select the BEST answer. In a real relational database system, if you try to join (natural join) tables R and S and R is empty (that is, it has no tuples), Select one: a. the system reports an error. b. the answer set is an empty table. c. the answer set is the same as table S. d. the answer set consists of just one row. e. an answer set is returned; however, the results are system dependent. What do you mean by one to many relationship between Student and Class table? Select one: a. One student can have many classes b. One class may have many student c. Many classes may have many students d. Many students may have many classes Question 20 The result of a SELECT statement can contain duplicate rows. Select one: True False [Show More]

Last updated: 1 year ago

Preview 1 out of 4 pages