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 questions

Take the quiz

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

Description: CPSI 3413 Quiz on CPSI 3413 - Concept 5, created by Adam Peterson on 06/08/2018.
Author: Adam Peterson
Language: English
Views: 12
Tags: cpsi 3413
Rating: No ratings yet
Rate this quiz
Rate this quiz