Answer:
A) Switch
Explanation:
In Java and most programming Languages, A Switch Statement provides a multi branch statements which provides a more flexible way for transfer of execution to the branch that fulfills the condition of the expressed value. This is a better way of handling if...elseif....else statements. In this way, a variable is tested for equality against some values. Variables used in switch expressions can only be primitives (int, byte, char), enums and strings. A switch statement has
1. A default statement (optional), appears at the end of the switch and acts as the else condition.
2. A break statement which terminates the switch when reached.
The syntax of a switch statement is given below:
switch(expression) {
case x:
// code block
break;
case y:
// code block
break;
default:
// code block
}
Answer:
Hi there! The answer is C:
Explanation:
The scope of the LOWER function is limited to the select clause it is being used in. Outside of the select statement, the column will be returned as it is currently present in the database. Using the LOWER function will not automatically store data in lower case letters in the database tables. As an exercise, try creating a simple database table called "Employees" with columns "id" and "name". Then input a row using an insert statement with id as 1 and name as "BLAH". Try using the select statement with LOWER function and then without the LOWER statement.
