What is the purpose of the SQL 'CONSTRAINT' keyword? MCQ with Answer and Explanation
Question
Report Error
Discuss this Question (0)
Practice More Database Management System (DBMS) Questions
Question #1
Report Error
Which of the following is a valid constraint in SQL?
Correct Answer: Option C
Explanation:
CHECK, PRIMARY KEY, FOREIGN KEY, UNIQUE, NOT NULL are all constraints in SQL.
CHECK, PRIMARY KEY, FOREIGN KEY, UNIQUE, NOT NULL are all constraints in SQL.
This question belongs to:
Computer
Database Management System (DBMS)
Question #2
Report Error
What is the concept of data independence?
Correct Answer: Option C
Explanation:
Data independence is the capacity to change the database schema at one level without affecting the next higher level, minimizing impact on applications.
Data independence is the capacity to change the database schema at one level without affecting the next higher level, minimizing impact on applications.
This question belongs to:
Computer
Database Management System (DBMS)
Question #3
Report Error
What is the difference between DELETE and TRUNCATE commands?
Correct Answer: Option B
Explanation:
DELETE is a DML command that can be rolled back and can use WHERE; TRUNCATE is a DDL command that removes all rows and cannot be rolled back (in some DBMS) and resets auto-increment counters.
DELETE is a DML command that can be rolled back and can use WHERE; TRUNCATE is a DDL command that removes all rows and cannot be rolled back (in some DBMS) and resets auto-increment counters.
This question belongs to:
Computer
Database Management System (DBMS)
No comments yet. Be the first to start the discussion!