To understand how to insert new rows into a table make them permanently stored (COMMIT statement)....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 (Le, result displayed by Oracle after each execution). 1) Add the following department to the DEP Table: DEPTNO = 'ch and DNAME = 'Chemistry 2) Add the following COURSE: (301, Chemistry I'. '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. 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 (Le, result displayed by Oracle after each execution). 1) Add the following department to the DEP Table: DEPTNO = 'ch and DNAME = 'Chemistry 2) Add the following COURSE: (301, Chemistry I'. '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. 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 (Le, result displayed by Oracle after each execution). 1) Add the following department to the DEP Table: DEPTNO = 'ch and DNAME = 'Chemistry 2) Add the following COURSE: (301, Chemistry I'. '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. 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 (Le, result displayed by Oracle after each execution). 1) Add the following department to the DEP Table: DEPTNO = 'ch and DNAME = 'Chemistry 2) Add the following COURSE: (301, Chemistry I'. '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.
Expert Answer:
Answer rating: 100% (QA)
SQL Data Manipulation Language DML operations are a subset of SQL Structured Query Language that focuses on interacting with and manipulating data stored in a relational database DML operations are re... View the full answer
Related Book For
Data Modeling and Database Design
ISBN: 978-1285085258
2nd edition
Authors: Narayan S. Umanath, Richard W. Scammel
Posted Date:
Students also viewed these databases questions
-
What is Amazon's diversity statement?
-
Employers must pay employees for a 3 0 minute lunch break?
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Suppose you are a depositor at First Street Bank. You hear a rumor that the bank has suffered serious losses on its loans. Every depositor knows that the rumor isnt true, but each thinks that most...
-
Three RC circuits have the emf, resistance, and capacitance given in the accompanying table. Initially, the switch on the circuit is open and the capacitor is uncharged. Rank these circuits in order...
-
In the event the WTO rules against Airbus and tells it to stop accepting subsidies and soft loans, how should Airbus management respond? What new approaches can management pursue to maintain Airbus's...
-
Research the programming language XBRL and write a two-page report about its effect on financial reporting via the Internet.
-
How would you define ethics? What types of ethical issues are involved in computerized accounting information systems? How can organizations encourage their employees to act ethically?
-
Provide an in-depth outline of job design as a new research direction and an analysis of the needed research
-
A textile company produces shirts and pants. Each shirt requires two square yards of cloth, and each pair of pants requires three square yards of cloth. During the next two months the following...
-
Your manager is concerned that costs are being misappropriated due to large balances in ending work in process inventories while currently using the FIFO Method for accounting for beginning work in...
-
Carla Vista's Custom Construction Company is considering three new projects, each requiring an equipment investment of $26.400. Each project will last for 3 years and produce the following net annual...
-
When requesting chunks/pieces of files, why does the Bit Torrent use "rarest first strategy for file sharing?
-
How do the Basel Accords influence the regulatory framework for risk-weighted capital adequacy, and what are the mechanisms by which these international standards aim to ensure the solvency and...
-
A company is considering three alternative investment projects with different net cash flows. The present value of net cash flows is calculated using Excel and the results follow. Potential Projects...
-
The accountant for Rooney's Dress Shop prepared the following cash budget. Rooney's desires to maintain a cash cushion of $17,000 at the end of each month. Funds are assumed to be borrowed and repaid...
-
A common misconception is that using a free online credit report service will lower your credit score. Fortunately, that's not true! Review this article to learn more about some of the most popular...
-
According to a New York Times columnist, The estate tax affects a surprisingly small number of people. In 2003, . . . just 1.25 percent of all deaths resulted in taxable estates, with most of them...
-
Explain functional dependency between two attributes.
-
Display the sum along with a three month moving average of the production of milk across the regions of the 2006-2010 period starting with January, 2006 and ending in December, 2010?
-
What is a unique identifier of an entity type? Is it possible for there to be more than one unique identifier for an entity type?
-
Barium sulfide is produced by reacting barium sulfate ore with coal. The result is barium black ash, which is \(\mathrm{BaS}\) plus insoluble solids. Since \(\mathrm{BaS}\) is soluble in water, it...
-
Batch leaching is similar to batch extraction, and the equations developed in Section 13.6 can be adapted when the solution is dilute or there is an insoluble solid matrix. We have \(12.5...
-
Repeat Problem 14.D14 except the feed has \(4.5 \mathrm{~kg}\) liquid \(/ \mathrm{kg}\) solids. Problem 14.D14 Barium sulfide is produced by reacting barium sulfate ore with coal. The result is...
Study smarter with the SolutionInn App