Q95.Marks: +2.0UGC NET Paper 2: Computer Science 7th Dec 2023 Shift 2
“CREATE TABLE T” in SQL is an example of :
1.Normalization
2.DML
3.DDL✓ Correct
4.Primary key
Solution
The correct answer is DDL
Key Points
DDL (Data Definition Language):
Data Definition Language includes SQL commands such as CREATE, ALTER, DROP, and TRUNCATE which are used to define or change the structure of the database objects.
The "CREATE TABLE T" command is indeed a DDL command as it's used to create a new table structure within the database.
Additional Information
Normalization: Normalization in databases is a process to minimize redundancy and dependency by organizing fields and table of a database. It typically involves dividing large tables into smaller ones and defining relationships between them to increase the clarity, efficiency, and integrity of the data.
DML (Data Manipulation Language): Data Manipulation Language commands are used to manage and manipulate data in an existing database structure. Key DML commands include SELECT, INSERT, UPDATE, and DELETE.
Primary key: A primary key is a column (or set of columns) in a table whose values uniquely identify every row in that table. The primary key plays a critical role in relational databases by providing a way of distinguishing each record in a table from every other record.
