Take Test: Midterm Part × G nport.blackboard.com/webapps/assessment/take/launch,

Question

Take Test: Midterm Part × G nport.blackboard.com/webapps/assessment/take/launch,jsp?course assessment id-537160 1& course id Question Completion Status: Column Name Column Column Nullable Retail ID Retail Street Retail City Retail State Retail Name Character Character Character mber Variable Variable No Yes Yes 50 30 Yes Yes Yes Character Retail ZipNumber5 Number5 Retail Sales Column Name Retail ID Retail Sales number Column TypeColumn Length Nullable Number Yes Submit your SQL create statements T TT Arial 3(12pt) 'T·-·-·?·as ' Chiel Save and Submit to save and submit. Click Save All Answers to save all answers

Explanation / Answer

Answers :

1)

CREATE TABLE Customer
(
Retail_ID NUMBER (4) NOT NULL,
Retail_Name CHAR (100),
Retail_Street VARCHAR2 (50),
Retail_City VARCHAR2 (30),
Retail_State CHAR (2),
Retail_Zip NUMBER (5)
);

CREATE TABLE Retaiil_Sales
(
Retail_ID NUMBER (4) NOT NULL,
Retail_Sales NUMBER (7,2)
);

=========================================================================

2)

CREATE TABLE Customer_Becon_Falls
AS (SELECT *
FROM Customer
WHERE RETAIL_CITY = 'Beacon Falls'

);

==========================================================================

3)

CREATE TABLE Customer_Copy as SELECT* FROM Customer WHERE 1=0;

==========================================================================

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.