R

Ranjeet • 34.60K Points
Instructor I

Q. Which CREATE TABLE statement is valid?

  • (A) CREATE TABLE ord_details (ord_no NUMBER(2) PRIMARY KEY, item_no NUMBER(3) PRIMARY KEY, ord_date date NOT NULL); 50
  • (B) CREATE TABLE ord_details (ord_no NUMBER(2) UNIQUE, NOT NULL, item_no NUMBER(3), ord_date date DEFAULT SYSDATE NOT NULL);
  • (C) CREATE TABLE ord_details (ord_no NUMBER(2) , item_no NUMBER(3), ord_date date DEFAULT NOT NULL, CONSTRAINT ord_uq UNIQUE (ord_no), CONSTRAINT ord_pk PRIMARY KEY (ord_no));
  • (D) iii and iv
Share

No solution found for this question.
Add Solution and get +2 points.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Related MCQs

Q. Which of the following is true?

Q. RTP can use

Q. The name of the document should be shown on the application’s ………………

Q. The NOT EXISTS keyword will be true if:

Q. In Data Processing model

Q. Following is not a Software Test Life Cycle Phase.

Q. Claytronics project is application of .

Q. Which scholar's definition on management is " Management is the art of getting things done through and with people in formally organised gro

Q. A thread is also called

Q. Not applicable condition can be represented in relation entry as

Question analytics