C - Puts a list of items into order
Answer:
1.
DIM myArray(10) as INTEGER
LET A = 0
FOR I = 1 TO 10 STEP 2
INPUT “INPUT NUMBER”; myArray(i)
LET A = A + myArray(i)
NEXT
PRINT A
END
2.
REM PROGRAM FOR CALCULATING THE SIMPLE INTEREST
CLS
INPUT “INPUT THE PRINCIPAL”; P
INPUT “INPUT THE TIME”; T
INPUT “INPUT THE RATE”;R
SI = P* T * R / 100
PRINT “SIMPLE INTEREST =”; SI
END
Explanation:
Please find the respective programs in the answer section.
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.
