Examine this constraint information:
Which three statements are true? (Choose three.)
Exam 1z0-071 All QuestionsBrowse all questions from this exam
Question 109
Correct Answer: B, C, E
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
Viviana3184Options: BCE
i think BCE are correct
ArslanAltafOptions: BCE
BCE 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
A 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
Its 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
yaya32Options: CDE
I 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
NULL is actually the only exception. AN FK Column can have NULL Values even though the PK Column it is referencing does not.
yanoolthecoolOptions: BCE
BCE, 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.
winstonOptions: BDE
BDE Is correct but why is C wrong?
McromeoOptions: BCE
BCE is correct
zangadoOptions: BCE
BCE 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
lucemqyOptions: BDE
BDE is the correct answer
Mcromeo
D is not correct bcz deptno > 9
ramonciks
why E ?
SangiiiOptions: BCE
BCE - is the answer
TheOracleWasTakenOptions: CE
deptno is a pk so cannot be null
TofOra
It's a PK in dept not in emp
CMjerOptions: BCE
BCE seems correct
AV80Options: CDE
CDE seems to be right option
anzac
D is not correct because DEPTNO is foreign key referencing DEPTNO in DEPT table and there DEPTNO must > 9
lucemqy
DEPTNO is a foreign key referencing a primary key so it should be able to be 1