All India Exams
Home AptitudeBankEngineeringEnglishGKInterviewOnline TestPlacement PapersReasoning
  • Home
  • Aptitude
  • Bank
  • Engineering
  • English
  • GK
  • Interview
  • Online Test
  • Placement Papers
  • Reasoning

Constraints DBMS Questions And Answers

Here you can find Constraints DBMS Questions and Answers.

Why Constraints DBMS Questions and Answers Required?

In this Constraints DBMS Questions and Answers section you can learn and practice Constraints DBMS 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 DBMS Questions and Answers?

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

How to solve these Constraints DBMS Questions and Answers?

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

Constraints DBMS Questions & Answers

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

Constraints DBMS Questions & Answers

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

Constraints DBMS Questions & Answers

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

Constraints DBMS Questions & Answers

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

Constraints DBMS Questions & Answers

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

Constraints DBMS Questions & Answers

6. Data integrity Constraints DBMS are used to:

Constraints DBMS Questions & Answers

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

Constraints DBMS Questions & Answers

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

Constraints DBMS 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 DBMS 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.

Home EngineeringComputer Science & EngineeringDBMS Questions and AnswersConstraints

Constraints - DBMS 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.

Constraints DBMS Questions

Online Test Name Constraints
Exam Type Multiple Choice Questions
Category Computer Science Engineering Quiz
Number of Questions 17
1. To include integrity constraint in a existing relation use :
  • A. Create table
  • B. Modify table
  • C. Alter table
  • View Answer
  • Workspace
  • Report
  • Discuss

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'
  • View Answer
  • Workspace
  • Report
  • Discuss

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
  • View Answer
  • Workspace
  • Report
  • Discuss

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
  • View Answer
  • Workspace
  • Report
  • Discuss

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
  • View Answer
  • Workspace
  • Report
  • Discuss

Answer & Explanation

Answer: Option A

Explanation:

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

Workspace

Report Error


  • «
  • 1
  • 2
  • 3
  • 4
  • »

Related Topics:

  • Relational Algebra
  • Indexes
  • Storage Structure
  • SQL Basics
  • Physical Storage Media
  • Transactions
  • RDBMS
  • Views
  • DBMS Keys
  • Aggregate Functions

Mock Tests & Online Quizzes

  • Aptitude Online Test

  • Reasoning Online Test

  • GK Online Test

  • English Online Test

  • RRB Mock Test

  • RBI Mock Test

  • Free SBI Mock Test

  • IBPS Mock Test FREE

  • SSC Mock Test

  • CAT Exam Mock Test

  • GATE Mock Test

  • IT Courses Quiz

Questions and Answers

  • Aptitude Questions
  • Verbal Reasoning Questions
  • Non Verbal Reasoning
  • Logical Reasoning Questions
  • Data Sufficiency Questions
  • Data Interpretation
  • eLitmus Sample Papers
  • ECE Questions and Answers
  • EEE Questions and Answers
  • Verbal Ability Questions
  • GK Questions

Programming Quiz

  • C Programming
  • C++ Programming
  • PHP Programming
  • Java Programming
  • Python Programming
  • DataScience MCQ
  • Hadoop MCQ
  • Mongo DB MCQ
  • MySQL MCQ

Interview Questions

  • Java Interview Questions
  • .Net Interview Questions
  • Networking Interview Questions
  • C Language Interview Questions
  • C++ Interview Questions
  • Testing Interview Questions
  • Android Interview Questions
  • HR Interview Questions
  • Group Discussion Topics

Our Sites

AView.in

© by AllIndiaExams.in. All Rights Reserved | Copyright | Terms of Use & Privacy Policy