Exam 1z0-071 topic 1 question 109 discussion

i think BCE are correct

As per the rule Primary and Composite Key can not contain Null value Then why B option is right I think A is right

but how did we know that the manager is referencing the empno column ?!

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

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.

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.

BDE Is correct but why is C wrong?

BCE is correct

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

BDE is the correct answer

why E ?

BCE - is the answer

deptno is a pk so cannot be null

BCE seems correct

CDE seems to be right option