adplus-dvertising
frame-decoration

Question

To include integrity constraint in a existing relation use :

a.

Create table

b.

Modify table

c.

Alter table

d.

Any of the above

Posted under DBMS

Answer: (c).Alter table

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. To include integrity constraint in a existing relation use :
Add Comment

Similar Questions

Discover Related MCQs

Q. Which of the following is not a integrity constraint ?

View solution

Q. Which of the following is the right syntax for assertion?

View solution

Q. Which of the following can be addressed by enforcing a referential integrity constraint?

View solution

Q. Drop Table cannot be used to drop a table referenced by a _________ constraint.

View solution

Q. ____________ is preferred method for enforcing data integrity.

View solution

Q. SQL stands for ________ .

View solution

Q. The SQL command to create a table is:

View solution

Q. A ________ is a stored program that is attached to a table or a view.

View solution

Q. The DROP TABLE statement:

View solution

Q. SQL views can be used to hide:

View solution

Q. The SQL statement to create a view is:

View solution

Q. To update an SQL view, the DBMS must be able to associate the column(s) to be updated with:

View solution

Q. Which of the following is NOT a type of SQL constraint?

View solution

Q. A ________ is a program that performs some common action on database data and that is stored in the database.

View solution

Q. For what purposes are views used?

View solution

Q. What is an SQL virtual table that is constructed from other tables?

View solution

Q. When using the SQL INSERT statement:

View solution

Q. What is not an advantage of stored procedures?

View solution

Q. A reason for using an SQL view to hide columns is:

View solution

Q. Which of the following is an SQL trigger supported by Oracle?

View solution
View All MCQs on DBMS

Suggested Topics

Are you eager to expand your knowledge beyond DBMS? We've curated a selection of related categories that you might find intriguing.

Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!

Computer Architecture

Unveil the science behind computer design with our Computer Architecture MCQs. Topics...

Software Engineering

Learn about the systematic approach to developing software with our Software...

SQL Server

Master Microsoft's database server with our SQL Server MCQs. Topics cover database...

Internet of Things (IoT)

Discover how devices communicate with each other in the smart world with our IoT...

Object Oriented Programming Using C++

Enhance your programming skills with our MCQs on Object Oriented Programming using...

CompTIA PenTest+ Certification Exam PT0 002

Prepare for the CompTIA PenTest+ PT0-002 exam with our targeted MCQs. Covering...

IT Fundamentals

Navigate the basics of information technology with our IT Fundamentals MCQs. Get a...

Java Spring Framework

Enhance your Java development skills with our Spring Framework MCQs. Learn about...

MATLAB

Hone your computational mathematics skills with our MATLAB MCQs. Understand...