Constraints Questions And Answers

Here you can find Constraints Questions and Answers.

Why Constraints Questions and Answers Required?

In this Constraints Questions and Answers section you can learn and practice Constraints Questions and Answers to improve your skills in order to face technical inerview conducted by organisations. By Practicing these interview questions, you can easily crack any Exams interview.

Where can I get Constraints Questions and Answers?

AllIndiaExams provides you lots Constraints Questions and Answers with proper explanation. Fully solved examples with detailed answer description. All students, freshers can download Constraints Questions and Answers as PDF files and eBooks.

How to solve these Constraints Questions and Answers?

You no need to worry, we have given lots of Constraints Questions and Answers and also we have provided lots of FAQ's to quickly answer the questions in the Competitive Exams interview.

Constraints Questions & Answers

1. To include integrity constraint in a existing relation use :

Constraints Questions & Answers

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

Constraints Questions & Answers

3. Foreign key is the one in which the ________ of one relation is referenced in another relation.

Constraints Questions & Answers

4. Domain constraints, functional dependency and referential integrity are special forms of _________.

Constraints Questions & Answers

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

Constraints Questions & Answers

6. Data integrity constraints are used to:

Constraints Questions & Answers

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

Constraints Questions & Answers

8. _____________, express the number of entities to which another entity can be associated via a relationship set.

Constraints Questions & Answers

9. An entity in A is associated with at most one entity in B, and an entity in B is associated with at most one entity in A.This is called as

Constraints Questions & Answers

10. An entity in A is associated with at most one entity in B. An entity in B, however, can be associated with any number (zero or more) of entities in A.

Constraints Questions and Answers

This is the DBMS questions and answers section on "Constraints" with explanation for various interview, competitive examination and entrance test. Solved examples with detailed answer description, explanation are given and it would be easy to understand.

1. To include integrity constraint in a existing relation use :

A. Create table
B. Modify table
C. Alter table

Answer & Explanation

Answer: Option C

Explanation:

Alter table

SYNTAX – alter table table-name add constraint , where constraint can be any constraint on the relation.

Workspace

Report Error

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

A. Not null
B. Positive
C. Unique
D. Check ‘predicate’

Answer & Explanation

Answer: Option B

Explanation:

Positive

Positive is a value and not a constraint.

Workspace

Report Error

3. Foreign key is the one in which the ________ of one relation is referenced in another relation.

A. Foreign key
B. Primary key
C. References
D. Check constraint

Answer & Explanation

Answer: Option B

Explanation:

Primary key

The foreign-key declaration specifies that for each course tuple, the department name specified in the tuple must exist in the department relation.

Workspace

Report Error

4. Domain constraints, functional dependency and referential integrity are special forms of _________.

A. Foreign key
B. Primary key
C. Assertion
D. Referential constraint

Answer & Explanation

Answer: Option C

Explanation:

Assertion

An assertion is a predicate expressing a condition we wish the database to always satisfy.

Workspace

Report Error

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

A. Create assertion 'assertion-name' check 'predicate';
B. Create assertion check 'predicate' 'assertion-name';
C. Create assertions 'predicates';
D. All of the mentioned

Answer & Explanation

Answer: Option A

Explanation:

Create assertion 'assertion-name' check 'predicate';

Workspace

Report Error

«
1
2
3
4
»

Advertisement