DATABASE FUNDAMENTALS
BASICS OF BIG DATA
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
How can we identify a column?
|
|
With a capital letter
|
|
|
with a number
|
|
|
with a capital letter and a number
|
|
|
we cannot identify it
|
Explanation:
Detailed explanation-1: -Capitalization. Use sentence-style capitalization for the table title and each column heading. Use sentence-style capitalization for the text in cells unless there’s a reason not to (for example, keywords that must be lowercase).
Detailed explanation-2: -In a blank cell, says Cell C1, enter the formula of =EXACT(B1, UPPER(B1)), and press the Enter key. This formula will identify whether the text in Cell B1 is uppercase or not. If the text in Cell B1 is uppercase, it will returns “TRUE"; if the text in Cell B1 is not uppercase, it will returns “FALSE".
There is 1 question to complete.