Test Difficulty Level: Easy

Syllabus of Test

Other Database Objects - Constraints, Sequences, Indexes, Synomys, Procedures and Functions, Packages, Triggers, A Quick 'n' Dirty Review of Data Dictionary, Querying the Data Dictionary.

Sample Question from this online test:

Question: Which of the following statements will create a primary key constraint pk_books on the table BOOKS, column ISBN? Choose one.

Option A: create primary key on books(ISBN);

Option B: create constraint pk_books primary key on books(ISBN);

Option C: alter table books add constraint pk_books primary key (ISBN);

Option D: alter table books add primary key (ISBN);

To answer, click the "Start This Test" button below.

Start this Test