Question: Q5. Separate DDL and DML Sql commands from the given queries. I. CREATE TABLE EMPLOYEE(Name VARCHAR2(20), Email VARCHAR2(100), DOB DATE); II. DROP TABLE EMPLOYEE;

Q5. Separate DDL and DML Sql commands from the given queries. I.

Q5. Separate DDL and DML Sql commands from the given queries. I. CREATE TABLE EMPLOYEE(Name VARCHAR2(20), Email VARCHAR2(100), DOB DATE); II. DROP TABLE EMPLOYEE; III. ALTER TABLE STU_DETAILS ADD (ADDRESS VARCHAR2(20)); IV. INSERT INTO javatpoint (Author, Subject) VALUES ("Sonoo", "DBMS"); V. UPDATE students SET User Name 'Sonoo' WHERE Student_Id = '3' VI. DELETE FROM Studen table WHER city= "Peshawar";

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

DDL stands for Data Definition Language When we want to create and modify structure of objects in a ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Computer Engineering Questions!

Joshua Munoz SYM-400 Mortoza Abdullah 1. Select * from Sales. Store; 2. Select * from Sales. Credit Card; Create a Microsoft Word document that includes the SQL queries used to explore the database...

Students of the author randomly selected 217 student cars and recorded their ages, and they randomly selected 151 faculty cars and recorded their ages. If using the F test with these data, is it...

Students of the author randomly selected 217 student cars and found that they had ages with a mean of 7.89 years and a standard deviation of 3.67 years. They also randomly selected 152 faculty cars...

SESSION: SUMMER 2017 LAB 1B SQL * Plus - CREATING TABLES and CONSTRAINTS Successful people did not attain their success without first overcoming challenges.------- Catherine Pulsifer FOLLOW...

SESSION: SUMMER 2017 LAB 1B SQL * Plus - CREATING TABLES and CONSTRAINTS FOLLOW INSTRUCTIONS: DO NOT SKIP A SINGLE STEP SECTION I: NOTE: Do not specify any constraints with the create statement...

Example 2: Below are some queries about create table, drop or alter it, insert data into table, etc. Please read each part carefully then write and execute it in MS SQL server management studio. /*...

Database Administration CHAPTER OBJECTIVES I Understand the need for and importance of database I ttno'illI the meaning of ACID transaction administralin - Learn the tour 1992 ANSI standard isolation...

Mom and POP database: Project 2 Based on the business requirements provided, the ERD would include the following entities: -Customers -Videos/DVDs -Movie -Distributors -Transactions Assignment to be...

Project SEE attatchment of mom and pop database In this assignment you will create the physical database from your design created in Project 2. Project 2 was a logical model of the Mom & Pop...

5. A communication system uses OFDM modulation with the following parameters: 127 subcarriers, modulation formats of 16QAM, 32QAM or 64QAM, and symbol duration of 0.5s. Determine: The symbol rate....

Your client is renovating an older Victorian style home into a 2-family dwelling with one unit on the ground floor and another on the 2nd floor. There are no windows on either side of the building as...

The following three lines do not have a common intersection: x+y=4, x-y=4 and x + 2y = 2. However, we can find an "approximate solution" to this system of equations by finding a point (x, y) that is...

Prepare the journal entry to record Zende Company's issuance of 75,000 shares of $5 par value common stock assuming the shares sell for: a. $5 cash per share. b. $6 cash per share. es View...

Hashing is a one-way function that maps a message to a fixed-size sequence of bits (hashed value) with the assumption it is extremely difficult to reverse the process. Given the hashed-value, it is...

Give me an example and evidence to prove that Boeing's investor relations website is doing a good job in preventing selective disclosure. The example (evidence ) should be kind of doing a comparison...

How to do this Database questions using Oracle? Given the following Relations Schema: (Primary key column(s) are underlined, decide on the required foreign keys.) Hotel (hotelNo, hotelName, city)...

Find the radius of convergence in two ways: (a) Directly by the CauchyHadamard formula in Sec. 15.2. (b) From a series of simpler terms by using Theorem 3 or Theorem 4.

What are the aims of static typing and dynamic evaluation?

Produce use case diagrams and a set of associated sequence diagrams for the DreamHome case study documented in Appendix A.

Now for each of the documents created above, create an appropriate DTD and XML Schema. Use namespaces where appropriate to reuse common declarations. Try to model multiplicity, primary and foreign...

What are the major differences between "industrial" regulation and "social" regulation? Cite examples of Federal commissions that address the two types of regulation.

Explain: "An effectively regulated natural monopoly will have trouble attracting capital to sustain and modernize its facilities."

How is price fixing treated under antitrust policy? Give two examples of legal actions against price fixing.