Question: This question is based on successful execution of the following command: CREATE VIEW changename AS SELECT customer#, lastname, firstname FROM customers WITH CHECK OPTION; Assume

This question is based on successful execution of the following command:

CREATE VIEW changename

AS SELECT customer#, lastname, firstname

FROM customers

WITH CHECK OPTION;

Assume that the only constraint on the CUSTOMERS table is a PRIMARY KEY constraint.


Which of the following columns serves as the primary key for the CHANGENAME view?

a. Customer#

b. Lastname

c. Firstname

d. The view doesn’t have or need a primary key.

Step by Step Solution

3.28 Rating (166 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (2 attachments)

PDF file Icon

1803_60b8c1212ba10_716781.pdf

180 KBs PDF File

Word file Icon

1803_60b8c1212ba10_716781.docx

120 KBs Word File

Students Have Also Explored These Related Oracle 12c SQL Questions!