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

Document Content and Description Below

Home ► My courses ► CS 2203 - AY2019-T5 ► Final Exam (Days 1 - 4) ► Final Exam Question 51 Answer saved Marked out of 1.00 Question 52 Answer saved Marked out of 1.00 Referential inte... grity means Select one: a. Do not enter a value in the foreign key Õeld of a child table if that value does not exist in the primary key of the parent table b. Do not enter a value in the primary key Õeld of chield table if that value does not exist in the primary key of the parent table c. Do not enter a value in the foreign key Õeld of a parent table if that value does not exist in the primary key of the child table d. All of above An entity is Select one: a. a real physical "thing" or a conceptual "thing" that is speciÕc to a particular database management system b. a "thing" which has either a real physical existence (e.g. a car or a student) or a conceptual existence (e.g. a course) c. a real physical "thing" that is speciÕc to a particular database management system d. any physical "thing" that exists in the real world CS 2203 Databases 1 - Term 5 Question 53 Answer saved Marked out of 1.00 Question 54 Answer saved Marked out of 1.00 Question 55 Answer saved Marked out of 1.00 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 User JANKO would like to insert a row into the EMPLOYEE table, which has three columns: EMPID,LASTNAME, and SALARY. The user would like to enter data for EMPID 59694, LASTNAME Harris, but no salary. Which statement would work best? Select one: a. INSERT INTO employee VALUES (59694,’HARRIS’, NULL); b. INSERT INTO employee VALUES (59694,’HARRIS’, SALARY); c. INSERT INTO employee (EMPID, LASTNAME, SALARY) VALUES (59694,’HARRIS’); d. INSERT INTO employee (SELECT 59694 FROM ‘HARRIS’); If we write a program in a programming language and switch to SQL when we require to use the database, then the SQL environment in use is know as _______ SQL. Select one: a. Real - time b. Dynamic c. PL - d. Embedded [Show More]

Last updated: 1 year ago

Preview 1 out of 3 pages