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
Extend your CREATE TABLE statement from problem 3 with referential integrity constraints. Updates and deletes on related rows are restricted. 6. From examination of the sample data

What is the use of sub queries? A sub query is a select-from-where expression that is nested with in another query. A common use of sub queries is to do tests for set membershi

Question: (a) What are the challenges in the development of Large Scale Distributed Real Systems? (b) What is backward engineering and forward engineering in a design packa

What are the two approaches to store relations in distributed database? a) Replication b) Fragmentation

What is equi join? Equi Join - It generates all the combinations of tuples from two relations which satisfy a join condition along with only equality comparison (=).

Advantages And Drawbacks Of Ddbms  There are various reasons for building distributed database systems, with sharing of data, reliability and availability, and speedup of query

ER diagram on cosmetics

What subschema expresses ? A subschema expresses the external view. (External schemas are called also called as subschemas)

Define Signal. It allows methods to respond to events triggered by themselves or by other processes. Each signal corresponds to an exacting event. A signal is represented in Sy

Write an sql statement to find what is the percentage of home policies which are from the state of Arizona out of all Home policies by Policy Value.