Which of the following types of constraints will allow NULL values? a. UNIQUE b. FOREIGN KEY c. PRIMARY KEY a. and b.
Added by Elizabeth T.
Close
Step 1
UNIQUE constraint: Ensures that all values in a column are unique. It does *not* allow NULL values because NULL is considered different from any other value, including another NULL. FOREIGN KEY constraint: Creates a link between two tables. It references the Show more…
Show all steps
Your feedback will help us improve your experience
Yujie Wang and 66 other AP CS educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
Which of the following do you need to consider when you define a table in SQL? Select one or more a. Default values for attributes b. Multivalued attributes c. Primary key of table d. Data Types of attributes
Yujie W.
109. The constraint violated when key value in tuple already exists in some other relation's tuple is called a. domain constraint b. attribute constraint c. key constraint d. lock constraint
Haricharan G.
Which of the following is true about XML files? A. May have empty tags B. All elements need attributes C. Can be combined with HTML tags D. May not have empty tags
James K.
Recommended Textbooks
Computer Science and Information Technology
Introduction to Programming Using Python
Computer Science - An Overview
Transcript
18,000,000+
Students on Numerade
Trusted by students at 8,000+ universities
Watch the video solution with this free unlock.
EMAIL
PASSWORD