Answered step by step
Verified Expert Solution
Question
1 Approved Answer
A manager would like to create a view of information specific to a particular customer. Which SQL command should be used? A. CREATE CUSTOMER VIEW
A manager would like to create a view of information specific to a particular customer. Which SQL command should be used?
A. CREATE CUSTOMER VIEW AS SELECT CUSTOMER, CUTNAME,LAST_PAYMENT FORM CUSTOMER_TABLE;
B. ADD VIEW CUSTOMER AS SELECT CUSTNUN, CUSTNAME LAST_PAYMENT FROM CUSTOMER_TABLE;
C.CREATE VIEW CUSTOMER AS SELECT CUSTNUM CUSTNAME, LAST_PAYMENT FROM CUSTOMER_ TABLE;
D. ADD CUSTOMER VIEW AS SELECT CUSTOMER, CUTNAME, LAST_PAYMENT FROM CUSTOMER_TABLE;
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started