Question

ALL THE QUESTIONS BELOW ARE BASED ON CYBER SECURITY COURSE. SO PLEASE ASN THE QUESTION. THE NAME OF THE TOPIC IS "DATABASE AND DATA CENTER SECURITY"

Do what Daes Dms Stands for give some Examples - Qy which Daes DDL Stands far, Examples?

Answer 1

SOLUTION :-

DMS :- DMS stands for Database Migration Service which is utilized for migrating the databases to AWS(Amazon Web Services) speedily and securely. The source database remains completely operational during the migration process, and minimizes the downtime to applications that depend on the database. It endorses analogous migrations namely Oracle to Oracle, and as well as heterogeneous migrations between distinct database platforms, namely Oracle to Amazon Aurora or Microsoft SQL Server to MySQL.

For example : If an organization has recently employed a hybrid cloud architecture which requires them to migrate their application servers and databases in AWS(Amazon Web Services). One of their applications needs a heterogeneous database migration in which we require to transform our on-premises Oracle database to PostgreSQL in AWS(Amazon Web Services). Then first of all, we will utilize the AWS Schema Conversion Tool to convert the source schema & code to match that of the target database, and then we will utilize the AWS Database Migration Service for migrating the data from the source database to the target database.

DDL :- DDL stands for Data Definition Language which is a standard for commands that define the distinct structures in a database. DDL statements are utilized for creating, modifying, and removing the database objects such as tables, indexes, and users.

The examples of general DDL statements are given below :-

(1) CREATE - It is utilized for creating the objects in the database.
(2) ALTER - It is utilized for altering the structure of the database.
(3) DROP - It is utilized for deleting the objects from the database.
(4) TRUNCATE - It is utilized for removing all records from a table, comprising all spaces assigned for the records are removed.
(5) COMMENT - It is utilized for adding the comments to the data dictionary.
(6) RENAME - It is utilized for renaming an object.

============================================================================