Consider the following statement: SELECT * FROM ABC WHERE COL1 = ‘Test’ OR COL2 = ‘ABC’ Which of the following would best describe the results that would be returned to the user?

All records will have either ‘Test’ in COL1 or ‘ABC’ in COL2, or both.

All records will have both ‘Test’ and ‘ABC’ in COL1 and COL2, respectively.

Some records will have either ‘Test’ in COL1 or ‘ABC’ in COL2, or both.

All records will have ‘Test’ in COL1 or ‘ABC’ in COL2, but not both.

Quiz

CPSI 3413 - Concept 5

Adam Peterson 2 perguntas

Fazer o quiz

1Organizational memory consists of three elements: data, information, and knowledge.
1. AVerdadeiro
2. BFalso
2
Consider the following statement:

SELECT *

FROM ABC

WHERE COL1 = ‘Test’

OR COL2 = ‘ABC’

Which of the following would best describe the results that would be returned to the user?
1. AAll records will have both ‘Test’ and ‘ABC’ in COL1 and COL2, respectively.
2. BSome records will have either ‘Test’ in COL1 or ‘ABC’ in COL2, or both.
3. CAll records will have either ‘Test’ in COL1 or ‘ABC’ in COL2, or both.
4. DAll records will have ‘Test’ in COL1 or ‘ABC’ in COL2, but not both.

Descrição: CPSI 3413 Quiz sobre CPSI 3413 - Concept 5, criado por Adam Peterson em 06-08-2018.
Autor: Adam Peterson
Idioma: English
Visualizações: 12
Etiquetas: cpsi 3413
Avaliação: Ainda sem avaliações
Avalie este quiz
Avalie este quiz