Question: Which of the following commands creates a new table containing a virtual column? a. CREATE TABLE newtable AS (SELECT order#, title, quantity, retail FROM orders);

Which of the following commands creates a new table containing a virtual column?
a. CREATE TABLE newtable AS (SELECT order#, title, quantity, retail FROM orders);
b. CREATE TABLE newtable (price NUMBER(3), total NUMBER(8,2));
c. CREATE TABLE newtable (calcl NUMBER(4), calc2 NUMBER(4);
d. CREATE TABLE newtable (cola NUMBER(3), colb NUMBER(3), cole AS (cola+colb));

Step by Step Solution

3.34 Rating (160 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

d CREATE TABL... View full answer

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_60b8c121214fb_716030.pdf

180 KBs PDF File

Word file Icon

1803_60b8c121214fb_716030.docx

120 KBs Word File

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