Computer 10: Date and Time, String Manipulation Functions

Which of the following concepts refers to a programmed routine that accepts argument/s and returns an output or a value?

• Function

• String Interval

• Parameter

• Procedure

What do you call the functions used to manipulate date and time values?

• Date Argument

• Date and Time String Interval

• Date and Time Function

• Data Conversin Function

What do you call the values used to help Functions to perform programming tasks?

• Instances

• Numeric and Non-numeric Values

• Data Types

• Parameters

Which of the following is NOT a valid Date and Time String Interval?

• yyyy

• ms

• h

• d

Which of the following is NOT TRUE about the String Manipulation Functions?

• String Manipulation Functions are built-in Functions.

• All String Manipulation Functions use parameters.

• String Manipulation Functions can generate string and/or numeric output.

• String Manipulation Functions work with string parameters only.

What is the value stored in a variable given below?

num = Chr(112) & Chr(85) & Chr(103)

• pUf

• pUg

• pug

• puF

• Pug

What is the value that will be stored in a variable given below?

code = Len(“Integrated School”) & Mid(“Batangas”, 4, 5)

• 16atanga

• 16angas

• 17angas

• 17Batan

• 17ngas

What is the value stored in the variable given below?

x = DatePart(“q”, “7/15/1988”)

• 2

• 3

• 7

• 15

• 1988

What is the value that will be stored in the variable given below?

y = DateAdd(“q”, 4, "01/31/2019")

• 01/31/2020

• 02/01/2019

• 01/31/2019

• 01/31/2023

• 02/04/2019

Which of the the following Date and Time Functions returns the number of date/time intervals between two dates/times?

• DateAdd

• DateDiff

• DatePart

• DateSerial

• DateInterval