Based on the structure of the PROMOTION table, which of the following commands will add a PRIMARY KEY constraint to the GIFT column?
a. CREATE TABLE promotion(gift VARCHAR2(15) PRIMARY KEY,minretail NUMBER(5, 2),maxretail NUMBER(5, 2));
b. ALTER TABLE promotionADD PRIMARY KEY(gift);
c. ALTER TABLE promotionMODIFY (gift PRIMARY KEY);
d. none of the above
b
You might also like to view...
New knowledge involves the continual interaction between ________ and ________ knowledge.
A. tacit; explicit B. detailed; tacit C. intellectual; pragmatic D. theoretical; practical
Presentations are given to many types of audiences. According to your text, what are the four categories of audiences?
A) Informed, uninformed, misinformed, and overinformed B) Hostile, friendly, neutral, and uninterested C) Workplace, school-related, community, and political D) Manuscript, extemporaneous, impromptu, and memorized
Which of the following is most often true of mature markets?
A. The market supports premium pricing, which attracts additional competitors. B. The magnitude of pricing differences and product differentiation is larger than in the growth stage. C. Some competitors enjoy a significant operating advantage due to increasing experience effects. D. Advantages that cannot be duplicated by other competitors are difficult to achieve.
A tenant renting an apartment under a three-year written lease that does not contain any specific restrictions may be evicted for:
a. Counterfeiting money in the apartmen b. Keeping a dog in the apartment c. Failing to maintain a liability insurance policy on the apartment d. Making structural repairs to the apartment