What is data definition language, Database Management System

What is data definition language? Explain it in detail?

The SQL DDL allows specification of not only a set of relations, but also information after each relation, containing

a) The schema for each relation

b) The domain of values associated with each attribute

c) The integrity constraints

d) The set of indices to be maintained for each relation

e) The security and authorization information for each relation

f)  The physical storage structure of each relation on disk

  Domain Types in SQL

Char(n),

varchar(n), int, small int, numeric(p,d), real, double, precision,

f loat(n), date, time, timestamp.

Schema Definition in SQL

a) Primary key

b) Check

 

Posted Date: 6/3/2013 2:45:18 AM | Location : United States







Related Discussions:- What is data definition language, Assignment Help, Ask Question on What is data definition language, Get Answer, Expert's Help, What is data definition language Discussions

Write discussion on What is data definition language
Your posts are moderated
Related Questions
The clause in SQL which specifies that the query result should be sorted in ascending or descending order based upon the values of one or much more columns is Ans : Order by

What is Message switching Message switching transmits data units which can be arbitrarily long. Packet switching has a utmost packet size, if any message longer than that, it s

Using the questions found at the end of Chapter 9 in your textbook, complete this homework activity. Students will submit a Word document answering questions 2, 3, and 4.

What is serialization? Where it is used and why?  Serialization is a basic term used for mechanisms which enable objects and object structures to be converted into portable for

please i request for your assistance in developing a case-based online phone repair

Explain the B + tree? B + tree is a type of tree which denotes sorted data in a way that permits for efficient insertion, retrieval and removal of records, each of which is

What is a cascading update? Referential integrity constraints needs that foreign key values in one table correspond to primary key values in another. If the value of the primar

Project Description: Hi I'm seeking someone to make my dBase application work. I know it's not a 'modern' language but it's what I know. I have written an order program and I ne

INSERT INTO command : Values can be inserted for all columns or for the selected columns Values can be given by sub query. In place of values parameter substitution

Define object-relational systems? Systems that give object-oriented extensions to relational systems are known as object-relational systems.