Name Null? Type --------- ----- ------------ GIFT VARCHAR2(15) MINRETAIL NUMBER(5,2) MAXRETAIL NUMBER(5,2) Based on the structure of the PROMOTION table, which of the following commands will add a PRIMARY KEY constraint to the GIFT column? 1. CREATE constraint promo_pk (gift VARCHAR2(15) PRIMARY KEY; 2. ALTER TABLE promotion MODIFY constraint promo_pk (gift PRIMARY KEY); 3. ALTER TABLE promotion SET constraint promo_pk PRIMARY KEY gift; 4. ALTER TABLE promotion ADD constraint promo_pk PRIMARY KEY(gift);
Types of Linked List
A sequence of data elements connected through links is called a linked list (LL). The elements of a linked list are nodes containing data and a reference to the next node in the list. In a linked list, the elements are stored in a non-contiguous manner and the linear order in maintained by means of a pointer associated with each node in the list which is used to point to the subsequent node in the list.
Linked List
When a set of items is organized sequentially, it is termed as list. Linked list is a list whose order is given by links from one item to the next. It contains a link to the structure containing the next item so we can say that it is a completely different way to represent a list. In linked list, each structure of the list is known as node and it consists of two fields (one for containing the item and other one is for containing the next item address).
Name Null? Type
--------- ----- ------------
GIFT VARCHAR2(15)
MINRETAIL NUMBER(5,2)
MAXRETAIL NUMBER(5,2)
Based on the structure of the PROMOTION table, which of the following commands will add a PRIMARY KEY constraint to the GIFT column?
CREATE constraint promo_pk (gift VARCHAR2(15) PRIMARY KEY;
ALTER TABLE promotion MODIFY constraint promo_pk (gift PRIMARY KEY);
ALTER TABLE promotion SET constraint promo_pk PRIMARY KEY gift;
ALTER TABLE promotion ADD constraint promo_pk PRIMARY KEY(gift);
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
