Ddl compiler-database management system, Database Management System

DDL Compiler

The DDL compiler changes the data definition statements (such as CREATE TABLE .... in SQL) into a set of tables having metadata tables. These tables have information concerning the database and are in a form that can be used by other parts of the DBMS. These tables are then stored in a system catalog or data dictionary.

 

Posted Date: 3/5/2013 5:10:50 AM | Location : United States







Related Discussions:- Ddl compiler-database management system, Assignment Help, Ask Question on Ddl compiler-database management system, Get Answer, Expert's Help, Ddl compiler-database management system Discussions

Write discussion on Ddl compiler-database management system
Your posts are moderated
Related Questions
Define average seek time. The average seek time is the average of the seek times, calculated over a sequence of random requests.

Problem 1. Create a PL/SQL program to insert data into student table and display the details of the student having Reg.No 1010 Writing a PL/SQL program to Insert data

Whta is the advantage of the database management approach? The advantage of the database management approach is data is integrated and can be accessed by multiple programs.

Why 'AS' clause is used in SQL ? 'As' clause is used for Rename operation. ‘AS' clause is used in SQL for rename operation. (e.g., SELECT ENO AS EMPLOYEE_NO FROM EMP)

What is Cross Product? Simply Cross product is Binary Operator

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.

sql is relationally complete-justify

Mention the type of constraints we can specify in the CREATE command of DDL. The type of constraints that can be specified are as follows:- PRIMARY KEY, NOT NULL, UNIQUE, FOR

A file manipulation command that extracts some of the records from a file is called ? A file manipulation command that extracts some of the records from a file is called SELECT

Natural Join : It is the similar like Equi join except one of the duplicate columns is removed in the result table. The natural join is the most usually used form of join operation