arrow
arrow
arrow
Which SQL language type is used to create and delete views and relations within tables?
Question



Which SQL language type is used to create and delete views and relations within tables?

A.

SQL Data Mining

B.

SQL Data Audit

C.

SQL Data Dynamic Creation

D.

SQL Data Definition Language

E.

SQL Data Referential Integrity

Correct option is D

DDL (Data Definition Language) is a subset of SQL used to define, create, and delete database objects such as tables, views, and indexes. It includes commands like CREATE, DROP, and ALTER.
Important Key Points:
1. CREATE: Defines new database structures like tables and views.
2. DROP: Deletes objects such as tables and views permanently.
3. ALTER: Modifies the structure of an existing table.
Knowledge Booster:
· Data Mining: Refers to extracting patterns from data, unrelated to SQL commands.
· Data Audit: Ensures the integrity and quality of data.
· Referential Integrity: Ensures consistency in relationships between tables but is not part of DDL.

Free Tests

Free
Must Attempt
Video Solutions

SBI Clerk Mains 2026 Full Mock Test-01

languageIcon English
  • pdpQsnIcon190 Questions
  • pdpsheetsIcon200 Marks
  • timerIcon160 Mins
languageIcon English
Free
Must Attempt

SBI Clerk Mains MBT (29th October 2026 S1)- Based on Backlog Vacancies

languageIcon English
  • pdpQsnIcon190 Questions
  • pdpsheetsIcon200 Marks
  • timerIcon160 Mins
languageIcon English
Free
Must Attempt

SBI Clerk Mains 2026 : Reasoning Section Test - 01

languageIcon English
  • pdpQsnIcon50 Questions
  • pdpsheetsIcon60 Marks
  • timerIcon45 Mins
languageIcon English
test-prime-package

Access ‘IBPS SO IT Officer’ Mock Tests with

  • 1.5 Lakhs+ Mocks and Previous Year Papers
  • Unlimited Re-Attempts
  • Personalised Report Card
  • 500% Refund on Final Selection
  • Largest Community
students-icon
590k+ students have already unlocked exclusive benefits with Test Prime!
Our Plans
Monthsup-arrow