Question w

Module 13 Oracle Academy Section 13, Lesson 1: Creating Tables Hands On Practical Experience READ: For each problem, write a QUERY. ─ Answer any questions asked, and ─ Include screenshot of code (no extra whitespace) ─ Include screenshot of code result (no extra whitespace) ─ Your assignment will be graded if the images are legible Students should execute DESC tablename or view Object Browser before doing INSERT to view the data types for each column. VARCHAR2 data-type entries need single quotation marks in the VALUES statement. 1. Please come up with a table to be created. This table should include at least five columns, all of which you will name. Below, you will see the requirements for each of the five columns. (A good place to start was your modeling project, complete this.) Column Name Key Type Nulls/ Unique FK Column Data Type Length (you choose) (you choose) (you choose) (you choose) (you choose) NUMBER (you choose) VARCHAR2 VARCHAR2 NUMBER (you choose) DATE 2. In APEX, Create your designed table. Please confirm the creation of the table you made in problem 1. With a screenshot of the CREATE TABLE code and a screen shot the table design in Object Browser. 3. Insert five rows of data into the table you created in problem 2. Include a screenshot of the table data after entry. 4. Query the data dictionary for each of the following: ─ USER_TABLES ─ USER_OBJECTS ─ USER_CATALOG or USER_CAT ─ In separate sentences, summarize what each query will/did return Module 13 Oracle Academy Section 13, Lesson 3: Modifying Tables 5. Create a Table to complete this set of Hands-On: CREATE TABLE vacations (location VARCHAR2(20), Lodging VARCHAR2(20), Dining VARCHAR2(20), StarGazing VARCHAR2(20), Pets VARCHAR2(3), Entertainment VARCHAR2(20)) WRITE the appropriate code: ─ ALTER the table an add an additional COLUMN ─ Show the ALTER code and the TABLE DESIGN after 6. ALTER the table and give a COLUMN a default value ─ ALTER the table an add an additional COLUMN ─ Show the ALTER code and the TABLE DESIGN after 7. RENAME the TABLE ─ Show the RENAME code and the name in Object Browser after 8. COMMENT on the TABLE ─ At least two comments ─ Show the COMMENT Code and query the comments Module 13 Oracle Academy Section 13, Lesson 2: Additional Data Types 9. TimeStamp Data Types are difficult to work with from one time zone. Therefore, you will enter data from the perspective of different timezones and when you query the data. Create this table: CREATE table timeexample (location VARCHAR2(20), timeWithZone TIMESTAMP WITH TIME ZONE, timeWithLocalZone TIMESTAMP WITH LOCAL TIME ZONE) ─ ─ ─ Chose 5 different cities, look up their time zone, and INSERT the data. Query all the data What did you learn? 10. Review the INTERVAL DataTypes and the examples in Oracle Academy. Select one example in the lectures and explain that here (include a screenshot). Module 14 Oracle Academy Section 14, Lesson 1: Intro to Constraints; NOT NULL and UNIQUE Constraints Hands On Practical Experience READ: For each problem, write a QUERY. ─ Answer any questions asked, and ─ Include screenshot of code (no extra whitespace) ─ Include screenshot of code result (no extra whitespace) ─ Your assignment will be graded if the images are legible 1. Using the VACATION table created in Module 13. ─ Add a column Website, make the column UNIQUE ─ Select any one column (or create a new one) and make that column NOT NULL ─ For both Constraints, use the technique where you name the constraint ─ Include all code and a screenshot of the Table Design when code Oracle Academy Section 14, Lesson 2: PRIMARY KEY, FOREIGN KEY, and CHECK Constraints and Lesson3: Managing Constraints 2. Using the VACATION table created in Module 13, and worked with in Problem #1 ─ Add a Primary Key to the table. You may create a new column. If you do create a new column, you will need to populate the data. ─ Add a Check Constraint and validate that PETS contains the words “Yes” or “No” ─ Include all code and a screenshot of the Table Design when code CREATE TABLE TypeVacations (VacationTypeID VARCHAR2(3), VacationType VARCHAR2(12)) ─ Enter data into the table: INSERT ALL INTO TypeVacations VALUES (10, ‘Camping’) INTO TypeVacations VALUES (12, ‘Romantic’) INTO TypeVacations VALUES (14, ‘Hiking’) INTO TypeVacations VALUES (16, ‘Arts’) INTO TypeVacations VALUES (18, ‘Music’) SELECT * FROM Dual ─ Add a Foreign Key to the Vacations table referencing VacationTypeID in the TypeVacations table. Include all code and a screenshot of the Table Design when code