Statement purpose To understand how to insert new rows into a table make them permanently stored (COMMIT statement). To Drop a table, run a script file (using the START sql*plus command) and check table content using SELECT. Activity Outcomes Students will be able to insert rows and save them permanently, Delete rows from a tables, Commit / Rollback a transaction and execute a script file containing SQL DDL-commands. Intructor Note Implement the question in the Exercise at the end of the Lab and submit the echo (i.e., result displayed by Oracle after each execution). 1) Add the following department to the DEP Table: DEPTNO = 'CM' and DNAME = 'Chemistry' 2) Add the following COURSE: (301, 'Chemistry l', 'CM', 40). 3) Try to add the COURSE: (101, 'Introduction to DOS', 'CP', 30). Discuss the result. 4) Try to add the CoURSE: (101, 'Introduction to DOS', 'CP', 30). Discuss the result. 5) How many rows are inserted correctly into each of the COURSE and DEP tables? 6) Execute the following SQL Query: SELECT * FROM DEP; How many rows you get? . 7) Execute the following SQL Query: SELECT * FROM COURSE; How many rows you get? 8) Right now, do the rows are permanently inserted into the tables? Discuss. 9) ROLLBACK the transaction. What is happened ? 10) If the rows are not permanently inserted, execute a statement to save the inserted rows. Now suppose we want to empty the two tables DEP and COURSE. 11) DELETE the rows in the DEP table first. Discuss the result and solve the problem to empty the two tables properly. 12) Check that the two tables are empty. 13) Extend the table DEP with a new column NBEMP to store the NUMBER(2) of employees in each department. 14) Remove the two tables DEP and COURSE.
Statement purpose To understand how to insert new rows into a table make them permanently stored (COMMIT statement). To Drop a table, run a script file (using the START sql*plus command) and check table content using SELECT. Activity Outcomes Students will be able to insert rows and save them permanently, Delete rows from a tables, Commit / Rollback a transaction and execute a script file containing SQL DDL-commands. Intructor Note Implement the question in the Exercise at the end of the Lab and submit the echo (i.e., result displayed by Oracle after each execution). 1) Add the following department to the DEP Table: DEPTNO = 'CM' and DNAME = 'Chemistry' 2) Add the following COURSE: (301, 'Chemistry l', 'CM', 40). 3) Try to add the COURSE: (101, 'Introduction to DOS', 'CP', 30). Discuss the result. 4) Try to add the CoURSE: (101, 'Introduction to DOS', 'CP', 30). Discuss the result. 5) How many rows are inserted correctly into each of the COURSE and DEP tables? 6) Execute the following SQL Query: SELECT * FROM DEP; How many rows you get? . 7) Execute the following SQL Query: SELECT * FROM COURSE; How many rows you get? 8) Right now, do the rows are permanently inserted into the tables? Discuss. 9) ROLLBACK the transaction. What is happened ? 10) If the rows are not permanently inserted, execute a statement to save the inserted rows. Now suppose we want to empty the two tables DEP and COURSE. 11) DELETE the rows in the DEP table first. Discuss the result and solve the problem to empty the two tables properly. 12) Check that the two tables are empty. 13) Extend the table DEP with a new column NBEMP to store the NUMBER(2) of employees in each department. 14) Remove the two tables DEP and COURSE.
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
Related questions
Question
please solve this question in SQL
with the fact that all the steps are in one question, so it's not a different question, so please solve it all
Transcribed Image Text:Statement purpose
To understand how to insert new rows into a table make them permanently stored (COMMIT
statement). To Drop a table, run a script file (using the START sql*plus command) and check
table content using SELECT.
Activity Outcomes
Students will be able to insert rows and save them permanently, Delete rows from a tables,
Commit / Rollback a transaction and execute a script file containing SQL DDL-commands.
Instructor Note
Implement the question in the Exercise at the end of the Lab and submit the echo (i.e., result
displayed by Oracle after each execution).
1) Add the following department to the DEP Table: DEPTNO = 'CM' and DNAME = 'Chemistry'
2) Add the following COURSE: (301, 'Chemistry l', 'CM', 40).
3) Try to add the COURSE: (101, 'Introduction to DOS', 'CP', 30). Discuss the result.
4) Try to add the COURSE: (101, 'Introduction to DOS', 'CP', 30). Discuss the result.
5) How many rows are inserted correctly into each of the COURSE and DEP tables?
6) Execute the following SQL Query: SELECT * FROM DEP; How many rows you get? .
7) Execute the following SQL Query: SELECT * FROM COURSE; How many rows you get?
8) Right now, do the rows are permanently inserted into the tables? Discuss.
9) ROLLBACK the transaction. What is happened ?
10) If the rows are not permanently inserted, execute a statement to save the inserted rows.
Now suppose we want to empty the two tables DEP and COURSE.
11) DELETE the rows in the DEP table first. Discuss the result and solve the problem to empty
the two tables properly.
12) Check that the two tables are empty.
13) Extend the table DEP with a new column NBEMP to store the NUMBER(2) of employees in
each department.
14) Remove the two tables DEP and COURSE.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education