adplus-dvertising
frame-decoration

Question

____________ is preferred method for enforcing data integrity.

a.

Constraints

b.

Stored Procedure

c.

Triggers

d.

Cursors

Posted under SQL DBMS

Answer: (a).Constraints

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. ____________ is preferred method for enforcing data integrity.
Add Comment

Similar Questions

Discover Related MCQs

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

Q. What is an advantage of placing computations in SQL views?

View solution

Q. Views constructed from SQL SELECT statements that conform to the SQL-92 standard may not contain:

View solution
View All MCQs on SQL

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!

Internet of Things (IoT)

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

Computer Architecture

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

Wireless and Mobile Communications

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

Systems Programming

Decode low-level programming with our Systems Programming MCQs. These questions delve...

C Programming

Master one of the most widely used programming languages with our C Programming MCQs....

CSS

Polish your web design skills with our CSS MCQs. Learn about selectors, properties,...

Digital Communication

Master the basics of electronic communication with our Digital Communication MCQs....

Python

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

Software Architecture and Design

Get a strong hold on the blueprint of software systems with our Software Architecture...