Define the terms- ddl and dml, Database Management System

Assignment Help:

Define the terms

i) DDL

ii) DML

DDL: Data base schema is specified by a set of definitions expressed by a special language known as a data definition language.

DML: A data manipulation language is a language that enables users to access or manipulate data as organized by the suitable data model.

Related Discussions:- Define the terms- ddl and dml

Normalise data to third normal form, A software contract and consultancy fi...

A software contract and consultancy firm maintains details of all the various projects in which its employees are currently involved. These details comprise: Employee Numbe

What is identity, What is Identity? Identity (or AutoNumber) is a colum...

What is Identity? Identity (or AutoNumber) is a column that automatically produces numeric values. A start and increment value can be set, but most DBA leave these at 1. A GUID

Special workarea for interface, While using extract datasets it is required...

While using extract datasets it is required to have a special workarea for interface False. It is not required to have a special workarea for interface

Abap/4 statements to access internal tables without header, What should be ...

What should be declared explicitly in the corresponding ABAP/4 Statements to access internal tables without header lines & why? Work Area. This is needed as the Work Area is

Balance transfer, Scenario 1: Power goes out after the first instruction. ...

Scenario 1: Power goes out after the first instruction. What happens?

Insert statement reverses storage space and transfers value, A field-groups...

A field-groups statement or an insert statement reverses storage space and transfers values. False.

The concurrent transactions, The Concurrent Transactions Almost every ...

The Concurrent Transactions Almost every commercial DBMS support multi-user environment. Therefore, allowing multiple transactions to proceed concurrently. The DBMS must make

Explain concurrency problems, Question: a) There are three concurrency...

Question: a) There are three concurrency problems, i.e. three types of potential mistake which could occur if concurrency control is not properly enforced in the database syst

Creating database for library, i need help with creating database system fo...

i need help with creating database system for a library

Determine advantages of merging an association into a class, What are the a...

What are the advantages and disadvantages of merging an association into a class? Advantages: i) Less number of tables ii) Faster performance due to the fewer tables

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages