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
job scheduling for different cubes

What three major types of actions includes databases? Briefly discuss these The three major types of actions including databases are: (i) Defining: It includes specifyin

#questiontypes of keys examples..

What are the two main goals of parallelism? Load -balance multiple small accesses, so that the  throughput of such accesses enhances. Parallelize large accesses so that the res

QUESTION (a) Using an appropriate example, explain what is a recursive function? (b) Explain in detail the C++ function given below. void search2(int list[],int n,int ele

What is object containment? References among objects can be used to model dissimilar real-world concepts.

Project Description: I am updating my Javascript + HTML website with five domains for the same website I would like to know if I want to create site map and submit it in all the

Q.   Explain the terms key constraints participation constraints and mapping caradinalities in ER model.  Participation Constraints :   The participation of an entity set E i

Operator Precedence The basic operators used in SQL are * /   - + Operators of the similar priority are evaluated From Left to right Parentheses are used to force priorit

why data in an RDMS need to be normalised