Question
Download Solution PDF“CREATE TABLE T” in SQL is an example of :
Answer (Detailed Solution Below)
Detailed Solution
Download Solution PDFThe 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.
Last updated on Jun 6, 2025
-> The UGC NET Exam Schedule 2025 for June has been released on its official website.
-> The UGC NET Application Correction Window 2025 is available from 14th May to 15th May 2025.
-> The UGC NET 2025 online application form submission closed on 12th May 2025.
-> The June 2025 Exam will be conducted from 21st June to 30th June 2025
-> The UGC-NET exam takes place for 85 subjects, to determine the eligibility for 'Junior Research Fellowship’ and ‘Assistant Professor’ posts, as well as for PhD. admissions.
-> The exam is conducted bi-annually - in June and December cycles.
-> The exam comprises two papers - Paper I and Paper II. Paper I consists of 50 questions and Paper II consists of 100 questions.
-> The candidates who are preparing for the exam can check the UGC NET Previous Year Papers and UGC NET Test Series to boost their preparations.