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 Fragen

Quiz starten

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

Beschreibung: CPSI 3413 Quiz am CPSI 3413 - Concept 5, erstellt von Adam Peterson am 06/08/2018.
Autor: Adam Peterson
Sprache: English
Aufrufe: 12
Schlagwörter: cpsi 3413
Bewertung: Noch keine Bewertungen
Bewerte dieses Quiz
Bewerte dieses Quiz