SQL DDL and DML Queries
Not what you're looking for?
Hi,
See attached file for assignment problems.
Thank you
DDL and DML
1. For emp table, set the constraint that Hiredate is later than Jan. 1, 1980.
2. Modify Dept table so that dname column can contain up to 20 characters.
3. Define ProdId+StartDate as the primary key for Price table.
4. Insert this row of data into price table:
Prodid= 200380, stdprice =5, minprice =4.4, startDate =today, EndDate =null.
5. Delete the row added in the previous step from Price table using Delete from (not rollback).
Q18-Q20 require using data dictionary items. Use one SQL for each.
18. Find all check constraints defined on emp. In the result, list name of the constraint.)
19. Find all tables in your account. Return the table names as output.
20. Find all foreign key constraints defined on emp table and on dept table. In the list, list the name of the constraint and which table it is defined on. USE only one SQL statement to accomplish this.)
Purchase this Solution
Solution Summary
This solution deals with a set of eight DDL and DML queries. Most of the queries are based on basic DDL and DML commands.
Purchase this Solution
Free BrainMass Quizzes
C++ Operators
This quiz tests a student's knowledge about C++ operators.
Excel Introductory Quiz
This quiz tests your knowledge of basics of MS-Excel.
Basic UNIX commands
Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.
Word 2010: Table of Contents
Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.
Basic Networking Questions
This quiz consists of some basic networking questions.