Examine this constraint information:
Which three statements are true? (Choose three.)
1z0-071 Exam QuestionsBrowse all questions from this exam
1z0-071 Exam - Question 109
Show AnswerHide Answer
Correct Answer: BCDE
The DEPTNO column in the EMP table can contain NULLS since it is not explicitly stated to be NOT NULL, even though it is a foreign key. The COMMISION column can contain negative values as there are no constraints shown preventing negative amounts. The MANAGER column is a foreign key referencing the EMPNO column as indicated by the constraint information.
Discussion
13 commentsViviana3184Options: BCE
Dec 29, 2022i think BCE are correct
yaya32Options: CDE
Jan 17, 2024I think B is wrong : The DEPTNO column in the EMP table can contain NULLS no because it refers to a PK so not possible.
Nico_Nikko
Mar 4, 2024NULL is actually the only exception. AN FK Column can have NULL Values even though the PK Column it is referencing does not.
ArslanAltafOptions: BCE
Apr 18, 2024BCE is Correct A. The SALARY column must have a value. .............FALSE B. The DEPTNO column in the EMP table can contain NULLS..........TRUE C. The COMMISION column can contain negative values. ....TRUE D. The DEPTNO column in the EMP table can contain the value 1...... TRUE WITH CONDITION. (If dept table primary key has 1 values) E. The MANAGER column is a foreign key referencing the EMPNO column........ TRUE F. The DNAME column has a unique constraint. FALSE G. An index is created automatically in the MANAGER column....FALSE
RIDA_007
May 18, 2024A is correct!! The SALARY column is part of a Check constraint CC_COMM that requires the SALARY to be greater than 100, which means it must have a value and cannot be NULL
ArslanAltaf
Jun 7, 2024Its correct there is a check constraint which mean it has to be > 100, yet it will not prevent a null value to be inserted in the column. In order to prevent not null, this specific constraint has to be added. Test it. A is wrong
AV80Options: CDE
Dec 28, 2022CDE seems to be right option
anzac
Jan 1, 2023D is not correct because DEPTNO is foreign key referencing DEPTNO in DEPT table and there DEPTNO must > 9
lucemqy
Nov 14, 2023DEPTNO is a foreign key referencing a primary key so it should be able to be 1
CMjerOptions: BCE
May 19, 2023BCE seems correct
TheOracleWasTakenOptions: CE
Aug 2, 2023deptno is a pk so cannot be null
TofOra
Feb 6, 2024It's a PK in dept not in emp
SangiiiOptions: BCE
Aug 27, 2023BCE - is the answer
ramonciks
Oct 3, 2023why E ?
lucemqyOptions: BDE
Nov 14, 2023BDE is the correct answer
Mcromeo
Dec 6, 2023D is not correct bcz deptno > 9
zangadoOptions: BCE
Nov 30, 2023BCE are correct. D is wrong because DEPTNO in EMP table is referencign DEPTNO in DEPT and there is check constraint which demands DEPTNO in DEPT to be greater than 9
McromeoOptions: BCE
Dec 6, 2023BCE is correct
winstonOptions: BDE
Dec 16, 2023BDE Is correct but why is C wrong?
yanoolthecoolOptions: BCE
Dec 29, 2023BCE, D is wrong because DEP_NO has a constraint in the department table that prevents it from having a value less than 10, very tricky, those who answered D might get surprises after the exam.