Ch 27: SQL Integrity Constraints

Enforcing schema-level business rules via SQL constraints, named constraints, and foreign key referential integrity actions (CASCADE, SET NULL).

16 Questions16 MCQs0 Short Questions0 Long Questions

🎯 Exam Practice Papers

CS403 - Database Management Systems Examination Practice

Timed practice exam simulation for CS403 - Database Management Systems.

Showing 1 – 10 of 16 Questions

Page 1 of 2

❓ MCQ📘 CS403📑 Lec 27🏷️ 27.3. Data Manipulation Language (DML) OverviewEasy🔁⭐💡📄🎓VU🏛️VU

Under standard relational database management guidelines, which classification of SQL commands is used to insert, retrieve, modify, or delete data instances inside tables?

💻 sql Snippet

INSERT INTO Teacher(TeacherID, Name, Office, Phone, Salary, Email)
VALUES('T001','Dr. Najma Waheed','F001', 9125, 150000,'najma@uni.edu.pk');

A.Data Definition Language (DDL)
B.Data Query Language (DQL)
C.Data Manipulation Language (DML)
D.Data Control Language (DCL)

❓ MCQ📘 CS403📑 Lec 27🏷️ 27.3. Data Manipulation Language (DML) OverviewEasy🔁⭐💡📄🎓VU🏛️VU

Which of the following commands is classified as a Data Manipulation Language (DML) command under standard database management system guidelines?

💻 sql Snippet

SELECT empName, salary 
FROM Employee 
WHERE department = 'Sales';

A.SELECT
B.CREATE
C.ALTER
D.DROP

❓ MCQ📘 CS403📑 Lec 27🏷️ 27.3. Data Manipulation Language (DML) OverviewEasy🔁⭐💡📄🎓VU🏛️VU

Under standard SQL query classifications, which of the following commands is NOT classified as a Data Manipulation Language (DML) command?

💻 sql Snippet

CREATE TABLE Program (
    prName char(4)
);

A.UPDATE
B.SELECT
C.INSERT
D.CREATE

❓ MCQ📘 CS403📑 Lec 27🏷️ 27.3. Data Manipulation Language (DML) OverviewEasy🔁⭐💡📄🎓VU🏛️VU

Which of the following database query statements is classified as a Data Manipulation Language (DML) command?

💻 sql Snippet

SELECT stId, stName FROM student;

A.SELECT
B.ALTER
C.CREATE
D.DROP

❓ MCQ📘 CS403📑 Lec 27🏷️ 27.4. Insertion, Deletion and Update CommandsEasy🔁⭐💡📄🎓VU🏛️VU

Which of the following SQL commands correctly deletes an employee record with the employee_id '12345' from a table named 'PERSON'?

💻 sql Snippet

DELETE FROM person WHERE employee_id = '12345';

A.DELETE FROM person WHERE employee_id = '12345';
B.DELETE WHERE person FROM employee_id = 12345;
C.DROP FROM person WHERE employee_id = 12345;
D.DELETE WHERE person WHERE employee_id = 12345;

❓ MCQ📘 CS403📑 Lec 27🏷️ 27.1. Alter Table StatementMedium⭐💡📄🎓VU🏛️VU

Analyze the following SQL statement: ```sql ALTER TABLE exams RENAME COLUMN Q_description TO Question_Descp, Std_ID to Student_ID; ``` True or False: The syntax of this ALTER TABLE statement is NOT correct.

💻 sql Snippet

ALTER TABLE exams RENAME COLUMN Q_description TO Question_Descp, Std_ID to Student_ID;

A.True
B.False

❓ MCQ📘 CS403📑 Lec 27🏷️ 27.4. Insertion, Deletion and Update CommandsEasy🔁⭐💡📄🎓VU🏛️VU

In relational database management systems, Data Manipulation Language (DML) commands are primarily used for:

A.Inserting, retrieving, and modifying data in databases
B.Creating databases and schemas
C.Destroying databases and schemas
D.Creating and altering database objects

❓ MCQ📘 CS403📑 Lec 27🏷️ 27.1. Alter Table StatementEasy🔁⭐💡📄🎓VU🏛️VU

Which of the following table properties, structures, or entries will be completely deleted and removed from the database if you execute a 'TRUNCATE TABLE' command?

💻 sql Snippet

TRUNCATE TABLE Student_Grades;

A.All data rows stored within the table
B.The physical indexes created on the table columns
C.The table definition structure and its declared columns
D.The table constraints and referential definitions

❓ MCQ📘 CS403📑 Lec 27🏷️ 27.4. Insertion, Deletion and Update CommandsMedium🔁⭐💡🌟📄🎓VU🏛️VU

Which of the following statements is strictly true regarding the SQL 'DELETE' command?

💻 sql Snippet

BEGIN TRANSACTION;
DELETE FROM Employee WHERE Age > 60;
ROLLBACK; -- RESTORES THE RECORD

A.It is classified as a Data Definition Language (DDL) command.
B.It automatically resets the auto-increment/identity value of the table to its initial seed.
C.It cannot activate or execute database delete triggers.
D.Its changes can be fully rolled back within an active transaction.

Q10

❓ MCQ📘 CS403📑 Lec 27🏷️ 27.4. Insertion, Deletion and Update CommandsEasy🔁⭐💡📄🎓VU🏛️VU

Which of the following SQL commands correctly deletes a record of an employee with the employee_id '12345' from a table named 'PERSON'?

💻 sql Snippet

DELETE FROM person WHERE employee_id = '12345';

A.DELETE FROM person WHERE employee_id = '12345';
B.DELETE WHERE person FROM employee_id = 12345;
C.DROP FROM person WHERE employee_id = 12345;
D.DELETE WHERE person WHERE employee_id = 12345;

Ch 27: SQL Integrity Constraints

CS403 - Database Management Systems Examination Practice

Mid Term Examination

Final Term Examination

CS403 - Database Management Systems Examination Practice

Mid Term Examination

Final Term Examination

📖 Related CS403 - Database Management Systems Curriculum Units