In which two cases would you use an outer join? () A. The tables being joined have NOT NULL columns.B. The tables being joined have only matched data.C. The columns being joined have NULL values.D. The tables being joined have only unmatched data.E. The tables being joined have both matched and unmatched data.F. Only when the tables have a primary key/foreign key relationship.

In which two cases would you use an outer join? ()

A. The tables being joined have NOT NULL columns.

B. The tables being joined have only matched data.

C. The columns being joined have NULL values.

D. The tables being joined have only unmatched data.

E. The tables being joined have both matched and unmatched data.

F. Only when the tables have a primary key/foreign key relationship.


相关考题:

You’ll be punished by law if you ________ your child. (A) use(B) abuse(C) used(D) abused

”You ____ have a wrong number,” she said. “There’s no one of that name here.”A. needB. canC. mustD. would

7. If I _______ you,l_______ take an umbrella with me.A. was ; shouldB. was ; wouldC. were ; willD. were ; would

Ifyoudon’tliketoswim,you_____aswellstayathome.A)shouldB)mayC)canD)would

"You _________ finish your homework before the dinner." said mother. A.shouldB.have toC.mustD.would

i need a _______________ milk for this recipe. A. two-litre carton ofB. two litres carton ofC. two-litres-carton ofD. two-litre carton

The professor asked us to write a _____________ report.A、two-hundreds-wordsB、two-hundreds-wordC、two-hundred-wordsD、two-hundred-word

“You ____ have a wrong number,” she said. “There’s no one of that name here.”A. needB. canC. mustD. would

以下对于字符串的相关操作,正确的输出结果是哪些选项?A.>>> 'Life is short, you need Python.'.find('you') 15B.>>> seq = [1, 2, 3, 4]; >>> sep = '+'; >>> sep.join(seq) '1+2+3+4'C.>>> print('{:5.3f}'.format(math.pi)) 3.1416D.>>> print('you' in 'Life is short, you need Python.') True

9、以下对于字符串的相关操作,正确的输出结果是哪些选项?A.>>> 'Life is short, you need Python.'.find('you') 15B.>>> seq = [1, 2, 3, 4]; >>> sep = '+'; >>> sep.join(seq) '1+2+3+4'C.>>> print('{:5.3f}'.format(math.pi)) 3.1416D.>>> print('you' in 'Life is short, you need Python.') True