Saturday , December 3 2022
Home / cognitive class / Normalization – Keys – Constraints in Relational Database Cognitive Class Exam Answers:-

Normalization – Keys – Constraints in Relational Database Cognitive Class Exam Answers:-

Course Name :- Normalization – Keys – Constraints in Relational Database

Normalization – Keys – Constraints in Relational Database Cognitive Class Final Exam Answers:-

Question 1.Which one of the following features is provided by Db2 on Cloud?

  • Scalability
  • High availability
  • Performance
  • All of the above

Question 2.What clause of the CREATE TABLE statement do you use to create a primary key?

  • CONSTRAINT
  • ALTER TABLE
  • PRIMARY KEY
  • REFERENCES

Question 3. Which of the following is NOT a constraint?

  • Entity Integrity Constraint
  • Domain Integrity Constraint
  • Referential Integrity Constraint
  • None of the above

Question 4. Which of the following constraints identifies each tuple (or row) in a table?

  • Entity integrity constraint
  • Check constraint
  • Positive constraint
  • Domain constraint

Question 5. What are the requirements that a table must meet to be in first normal form (1NF)?

  • The table must have a Primary Key.
  • Each table must contain no more than three columns.
  • Each row must be unique, and each cell must contain only a single value.
  • The table must already be in third normal form (3NF) and second normal form (2NF).

About Machine Learning

Check Also

Python for Data Science Cognitive Class Exam Answers:-

Course Name:- Python for Data Science Module 1. Python Basics Question 1. What is the …

Leave a Reply

Your email address will not be published.