Question

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

a.

All phone numbers must include the area code

b.

Certain fields are required (such as the email address, or phone number) before the record is accepted

c.

Information on the customer must be known before anything can be sold to that custome

d.

When entering an order quantity, the user must input a number and not some text (i.e., 12 rather than ‘a dozen’)

Posted under DBMS

Answer: (c).Information on the customer must be known before anything can be sold to that custome

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

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

Add Comment

Similar Questions

Discover Related MCQs

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

Q. The SQL ALTER statement can be used to:

View solution

Q. What SQL structure is used to limit column values of a table?

View solution

Q. Which is NOT one of the most common types of SQL CHECK constraints?

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 Hardware

Explore the tangible components of computers with our Computer Hardware MCQs. Learn...

Object Oriented Programming Using C++

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

Web Technologies

Master the building blocks of the web with our Web Technologies MCQs. From HTML and...

Big Data Computing

Enhance your understanding of Big Data Computing with our comprehensive MCQs. Explore...

Management Information Systems

Discover how businesses leverage technology with our Management Information Systems...

Wireless and Mobile Communications

Get to grips with modern communication technologies with our Wireless and Mobile...

Python

Dive into one of the most popular languages with our Python MCQs. Understand...

Data Structures and Algorithms

Journey through the fundamentals of Data Structures and Algorithms with our extensive...

Neural Networks

Dive into the world of Artificial Intelligence with our Neural Networks MCQs. Uncover...