exam questions

Exam 1z0-071 All Questions

View all questions & answers for the 1z0-071 exam

Exam 1z0-071 topic 1 question 37 discussion

Actual exam question from Oracle's 1z0-071
Question #: 37
Topic #: 1
[All 1z0-071 Questions]

Which two statements are true about an Oracle database? (Choose two.)

  • A. A table can have multiple primary keys.
  • B. A column definition can specify multiple data types.
  • C. A table can have multiple foreign keys.
  • D. A VARCHAR2 column without data has a NULL value.
  • E. A NUMBER column without data has a zero value.
Show Suggested Answer Hide Answer
Suggested Answer: CD 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Mahendra_19
6 months ago
Table can have multiple foreign Key: CREATE TABLE ENCOUNTER ( ENCT_ID VARCHAR2(25) PRIMARY KEY, ENCT_DATE DATE NOT NULL, PT_MRN NUMBER NOT NULL, ENCT_BP VARCHAR2(10) NOT NULL, ENCT_WT NUMBER(3,2) NOT NULL, ENCT_TEMP NUMBER(3) NOT NULL, ACCT_ID VARCHAR2(25) NOT NULL, PHX_ID VARCHAR2(25) NOT NULL, CONSTRAINT FK_PATIENT FOREIGN KEY (PT_MRN) REFERENCES PATIENT(PT_MRN) CONSTRAINT FK_ACCOUNT FOREIGN KEY (ACCT_ID) REFERENCES ACCOUNT(ACCT_ID) CONSTRAINT FK_PTHISTORY FOREIGN KEY (PHX_ID) REFERENCES PTHISTORY(PHX_ID));
upvoted 1 times
...
Kamaljeet001
11 months, 3 weeks ago
CD is correct answer. PFB discussion link for same question https://www.examtopics.com/discussions/oracle/view/21762-exam-1z0-071-topic-2-question-64-discussion/
upvoted 1 times
...
Selected Answer: CD
One pk and yeah if you dont insert anything in a row with a with a varchar datatype the value is null and not an empty string which i guess is what they're trying to trick you into?
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago