Bissoy.com
Doctors Medicines MCQs Q&A

create table apartment(ownerID varchar (5), ownername varchar(25), floor numeric(4,0), primary key (ownerID)); Choose the correct option regarding the above statement

create table apartment(ownerID varchar (5), ownername varchar(25), floor numeric(4,0), primary key (ownerID)); Choose the correct option regarding the above statement Correct Answer It creates a relation with three attributes ownerID, ownername, floor in which ownerID cannot be null.

It creates a relation apartment with three attributes as specified. The attribute ownername cannot be null because it is the primary key of the relation.

Related Questions

Seven persons A, Q, E, F, L, M and C live on 7 floor building numbered as 1 to 7th floor from bottom to top. Bottom floor numbered as floor 1 and its above floor numbered as floor 2 and so on. Topmost floor numbered as floor 7. A lives on the 4th floor. Two persons live between A and F. M lives just above E. F does not live on the top floor. Q lives on the 2nd floor. L is not an immediate neighbour of Q and does not live on the top floor. Who lives on the top floor?
Five persons A, B, C, D and E are lives on the five-floor building. Each person lives on each floor. Bottom floor numbered as floor 1 and above the floor is numbered as floor 2 and so on top floor numbered as floor 5. B lives on the 4th floor. A is not an immediate neighbour of B and also not lives on the bottom floor. D neither lives on the top floor nor bottom floor. Who lives on the 3rd floor?
Six persons A, F, W, K, P and C live on the six-floor building. Each person lives on each floor. The lowest floor is numbered as floor 1, its above floor is numbered as floor 2 and so on and the top most floor is numbered as floor 6. F lives on floor 4. W lives between A and K. K does not lives on the lowest floor. K lives below F's floor. P lives on an even-numbered floor. Who lives between C and K?
Five persons S, T, W, N and C live on five floor building. Each person lives on each floor. The lowest floor is numbered as floor 1, its above floor is numbered as floor 2 and so on and the top most floor is numbered as floor 5. T lives in the middle of the floor. W lives below T. W is not lives on the lowest floor. One person lives between T and S. S lives above T. Two persons lives between N and C. Who lives on the lowest floor?
Six persons A, D, E, Q, G and K are living on a building. Each person lives on each floor and the lowest floor is numbered as floor 1 and the floor it's above is called floor 2 and so on. The top floor is numbered as floor 6. A lives on floor 3. Two persons are living between A and E. Q lives just above G. G lives on the 1st floor. D lives on odd number floor. Who lives on the 4th floor?
Five persons A, L, K, D and S lives on five floor building. Each person lives on each floor. Bottom floor numbered as floor 1 and above floor is numbered as floor 2 and so on top floor numbered as floor 5. A lives between K and L. Neither K nor L lives on either top nor bottom floor. L lives below K. D does not lives on top floor. Who lives on top floor?
Seven persons Q, D, E, R, L, P and W are living on the seven-floor building. Lower floor numbered as floor 1 and its above floor is numbered as floor 2 and so on the topmost floor is numbered as floor 7. Each person lives on each floor. Three persons are living between Q and P. P lives below Q. R lives on second floor. Two persons are living between R and E. L lives on odd number floor. D is not an immediate neighbour of Q. Who lives on 3rd floor?
Six persons Q, F, H, A, L and V are lives on the six-floor building. Each person lives on each floor. Bottom floor numbered as floor 1 and above the floor is numbered as floor 2 and so on top floor numbered as floor 6. Q lives just above V who lives on the bottom floor. Two persons are live between V and H. A lives just above L. Who lives on the fifth floor?
Six persons 1, 2, 3, 4, 5 and 6 live on the six-floor building. Exactly one person lives on each floor. Bottom floor numbered as floor 1 and above the floor is numbered as floor 2 and so on top floor numbered as floor 6. Person 1 live just above person 3 and just below person 5. Person 6 lives between persons 3 and 2. Person 4 is not placed at the top floor. Who placed on the third floor?
Five persons A, Q, D, R and X are lives on the five-floor building. Each person lives on each floor. Bottom floor numbered as floor 1 and above the floor is numbered as floor 2 and so on top floor numbered as floor 5. X lives on the lowest floor. Three persons live between X and A. R lives just above D. D is not an immediate neighbour of X. Who lives on the 4th floor?