M

Mr. Dubey • 52.30K Points
Coach 

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

(A) The statement is syntactically wrong
(B) It creates a relation with three attributes ownerID, ownername, floor in which floor cannot be null.
(C) It creates a relation with three attributes ownerID, ownername, floor in which ownerID cannot be null.
(D) It creates a relation with three attributes ownerID, ownername, floor in which ownername must consist of at least 25 characters.
Correct : Option (C)

Share

Discusssion

Login to discuss.

Be the first to start discuss.

Related MCQs

Q. Data mining helps in________.

Q. Security methods such as private encryption, VLANs and firewalls comes under subject area.

Q. A unique piece of information that is used in encryption.

Q. "An informal narrative description of human activities or tasks in a story that allows exploration and discussion of contexts, needs, and require

Q. Which data structure allows deleting data elements from and inserting at rear?

Q. Which method will return the number of elements in an array?

Q. Supervised learning and unsupervised clustering both require which is correct according to the statement.

Q. In IBM’s S360/370 systems lines are used to select the I/O devices.

Q. The need for data replication can arise in various scenarios like

Q. Which of the following statements about SRS is/are true ? i. SRS is written by customer ii. SRS is written by a developer iii. SRS serves as a contrac