Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A data definition also known as data description language ( DDL ) is a language used for defining data structures for database schemas. DDL statements

A data definition also known as data description language (DDL) is a language used for defining data structures for database schemas. DDL statements create, modify, and delete database objects such as tables, views, indexes, procedures, and users. Commonly used DDL statements are CREATE (creating new objects), ALTER (modifying existing objects), and DROP (deleting objects). 

 

The system catalog tables that keep track of database metadata such as tables information, are modified or entered through DDL statements. The system catalog entities are read-only and cannot be modified by the database user or administrator. They also keep track of which objects are accessible to database users to modify the user objects. 

 

The metadata contains definitions of records, data items and other objects that are used by the DBA or developers to get more information about the DBMS. The DBMS refers to the system catalog before the data is accessed within the database. System catalog is also referred as data dictionary which is used to describe the. DDL to manage all the database objects in a DBMS.

 

If you have accidentally executed a DDL command, can it be rolled backed? Explain your reasoning?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

If you have accidentally executed a DDL Data Definition Language command in a database it typically ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Modern Systems Analysis And Design

Authors: Joe Valacich, Joey George

9th Global Edition

1292351624, 978-1292351629

More Books

Students also viewed these Databases questions

Question

4. Jobe dy -Y 2 et by

Answered: 1 week ago

Question

=+a. What is the probability that both tests yield the same result?

Answered: 1 week ago