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.

Test

CPSI 3413 - Concept 5

Adam Peterson 2 preguntas

Hacer el test

1Organizational memory consists of three elements: data, information, and knowledge.
1. AVerdadero
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.

Descripción: CPSI 3413 Test sobre CPSI 3413 - Concept 5, creado por Adam Peterson el 06/08/2018.
Autor: Adam Peterson
Idioma: English
Visitas: 12
Etiquetas: cpsi 3413
Valoración: Aún sin valoraciones
Valora este test
Valora este test