CIST 1220 LESSON 13 TEST.docx - Course Test Started...

This preview shows page 1 - 3 out of 10 pages.

Course CIST1220: Structured Query Language-SQL (Online) 42264 Test Lesson 13- Test Started 4/9/20 7:22 PM Submitted 4/9/20 8:07 PM Due Date 4/18/20 11:30 PM Status Completed Attempt Score 38 out of 40 points Time Elapsed 45 minutes out of 1 hour Results Displayed All Answers, Submitted Answers, Correct Answers, Incorrectly Answered Questions Question 1 2 out of 2 points A(n) ____ stores a query and is used to access data in the underlying tables. Selected Answer: d. view Answers: a. function b. constraint c. argument d. view
Question 2 2 out of 2 points A(n) ____ table is a table that does not contain the primary key that a view uses to uniquely identify each record being displayed by the view.
non key-preserved d. primary Question 3 2 out of 2 points A(n) ____ table is the table that contains the primary key the view uses to uniquely identify each record being displayed by the view.
Question 4 2 out of 2 points A view based on the contents of one table that uses an expression for one of the columns is considered a(n) ____ view.

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture