Unit 3: SQL and Advanced Database Programming21CSC205P

SQL Data Definition (DDL) and Integrity Constraints

Curriculum and historical examination lineage for SQL Data Definition (DDL) and Integrity Constraints under Unit 3 (SQL and Advanced Database Programming) of Database Management Systems (21CSC205P) at SRMIST.

Appearances
6
Cataloged Exam Questions
Exam Papers
2
Distinct University Exams
Question Families
0
Recurring Conceptual Archetypes
SRMIST Status
Active
Regulation 2021 Syllabus
Assessment Cycle Weightage

Historical appearance distribution across SRMIST Formative Tests (CT1, CT2) and University End Semester examinations.

CT1
0
Cycle Test 1
CT2
0
Cycle Test 2
EndSem
6
Semester Exam
Marks Weightage Distribution

Factual marks weightage of questions asked on this topic in historical examinations.

1 Marks:6 questions
Sample Past Exam Questions

Representative historical questions extracted directly from SRMIST examination papers.

Create and insert are (A) DDL and DML respectively (C) DML and DDL respectively (B) DML and DCL respectively (D) DDL and TCL respectively [1]

Year: 2022•Assessment: EndSem
1 Marks

Drop table, table name is a (A) DDL command (C) TCL command (B) DCL command (D) DML command [1]

Year: 2022•Assessment: EndSem
1 Marks

DDL Datas are _________ automatically without ______ (A) Committed, manual commit (C) Recovered, manual recovery (B) Deleted, delete (D) Executed, manual execution [1]

Year: 2022•Assessment: EndSem
1 Marks

A DDL command after any number of DML command (A) Stores the data permanently (B) No affect with DML commands (C) No effect with DDL command (D) Stores the DDL statement data...

Year: 2022•Assessment: EndSem
1 Marks

SELECT * FROM employee What type of statement is this? (A) DML (B) DDL (C) View (D) DCL [1]

Year: 2023•Assessment: EndSem
1 Marks
Historical Papers Indexed (2)

Examinations where questions for SQL Data Definition (DDL) and Integrity Constraints have appeared.

Database Management Systems - JUNE 2022 Examination Paper
2022EndSem
Database Management Systems - DEC 2023 Examination Paper
2023EndSem
Other Exam Topics in Unit 3: SQL and Advanced Database Programming

Master SQL Data Definition (DDL) and Integrity Constraints in MintAI

Practice past exam questions, test recurring archetypes, and view predictive probability for this topic before your upcoming exam.