DDL: to construct the database and alter its content explain in brief

. Identification. Write in the blanks the word/s that best describe/s the given statements.1. It allows multiple accesses coming from different locations.2. It indicates an optional value in a DDL command.3. It is a classification of a database where databases are stored what a single site that is used by several systems.4. It is a DDL language that allows you to create a table or database.ed napi 015. It is a value that a column name or field name can hold.6. It is also known as a field name. Jon7. It is an actual database which is distributed from various sites that are connected via a computer network.8. It is an electronic collection of text, numeric values, graphics, or images which are systematically processed and stored in computers.9. It is known as an organized collection of data that is related to a particular subject or purpose.10. It is one of the DBMS functions that allow you to define data elements and their relationships.11. It means that data in the database is always accurate.12. It provides backup and data recovery to ensure data safety and integrity13. It provides data access through the query language.14. It provides a security system that enforces user security and data privacy by means of security rules.15. This language is used to define structure in the SQL Server Management Studio. Its main aim is to create, alter, or drop data,3 / 3

For what purpose the DML is provided?a.Addition of new structure in the databaseb.Definition of the physical structure of the database systemc.All of the aboved.Manipulation & processing of the database

Data Definition Language (DDL) and Data Manipulation Language (DML) are what?1 pointThe basic categories for managing data. The basic categories for providing security to databases.The basic categories of the PYTHON language based on functionality.The basic categories of the SQL language based on functionality.

Archie is developing a library management system to manage books, authors, and borrowers. The system needs to handle three main types of data: BOOKS, AUTHORS, and BORROWERS.Write the DDL statements to create the following tables with the mentioned constraints to handle the data: symbol refers to the primary key NN refers to Not NULL After creating the tables, Archie needs to:Alter the BOOKS table to change the primary key to Title to ensure each book is uniquely identified by its title.Drop the primary key from the BORROWERS table as it is no longer requiredAlter the AUTHORS table to change the Nationality to NULL Note: The user must write only the query to create and alter the table. The query to display the description of the table is already given.Input format :No console inputOutput format :The output displays the successful table creation status and the structure of all three tablesRefer to the sample output.Sample test cases :Input 1 :Output 1 :Table BOOKS created.Table AUTHORS created.Table BORROWERS created.Table BOOKS altered.Table BOOKS altered.Table BORROWERS altered.Table AUTHORS altered. Name Null? Type __________________ ___________ ________________ BOOKID NOT NULL NUMBER TITLE NOT NULL VARCHAR2(200) AUTHORID NOT NULL NUMBER PUBLICATIONYEAR NOT NULL NUMBER Name Null? Type ______________ ___________ ________________ AUTHORID NOT NULL NUMBER NAME NOT NULL VARCHAR2(100) NATIONALITY VARCHAR2(100) Name Null? Type _________________ ___________ ________________ BORROWERID NOT NULL NUMBER NAME NOT NULL VARCHAR2(100) MEMBERSHIPDATE NOT NULL DATE TABLE_NAME COLUMN_NAME POSITION STATUS _____________ ______________ ___________ __________ BOOKS TITLE 1 ENABLED 1 row selected. Note :

Which of the following creates and maintains the schema of a database?Data Manipulation LanguageData Definition LanguageData Control LanguageNone of the above