Storage Management Concepts
Setting Extent Size
Table Space Fragmentation
Correct Table Space
Data System Blocks
Schema Manager Table
Creating Table Syntax
Four Basic Constraints
Primary Key Constraints
Data Dictionary Constraints
Oracle Database Index
Drop Index Oracle
Listing Privileges Columns
Revoking Object Privileges
Database Security Roles
PRIMARY KEY constraints - Exercise
Course project: Using primary key constraints
Create primary key constraints for the
This exercise is worth a total of 24 points. Each completed block of code is worth 4 points. You will be graded on completeness and correctness of code. When you complete your answer, submit your answer.
Background and Overview
Earlier in this course, you created a script file with the SQL statements needed to create the tables in your
database. In this exercise, you will modify those scripts to include primary key constraints.
You can download a correct version of the script for this exercise, primarykey.sql, from the project download file found on the Resources page.
Add a primary key constraint for each table in the
You can create a primary key that includes multiple columns by listing the columns, separated by commas.
Submitting your exercise
Submit your answer in the text box below.