Data Manipulation with Strings in Studio

Question 1

What is data manipulation?

Answer 1

Data manipulation is the process of modifying, structuring, formatting, or sorting data in order to facilitate its usage and increase its management capabilities.

Question 2

What does String.Concat method do?

Answer 2

Concatenates the string representations of two specified objects.

Expression: String.Concat (VarName1, VarName2)

Output datatype: String

Question 3

What is the method that can be used to check whether a specified substring occurs within a String?

Answer 3

Contains method. It returns true or false.

Expression: VarName.Contains (“text”)

Output datatype: Boolean

Question 4

What is String.Format method do?

Answer 4

Converts the value of objects to strings (and inserts them into another text).

Expression: String.Format(“{0} is {1}”, VarName1, VarName2)

Output datatype: String

Question 5

What does the IndexOf method do?

Answer 5

Returns the zero-based index of the first occurrence of a specified Unicode character or string within this instance.

Expression: VarName1.IndexOf(“a”)

Output datatype: Int32

Question 6

What does LastIndexOf method do?

Answer 6

Reports the zero-based index position of the last occurrence of a specified Unicode character or string within this instance.

Expression: VarName1.LastIndexOf(“author”)

Output datatype: Int32

Question 7

What is the method to use to concatenate the elements in a collection and displays them as String.

Answer 7

String.Join

Expression: String.Join(“|”, CollVarName1)

Output datatype: String

Question 8

What method should you use to replace all the occurrences of a substring in a string.

Answer 8

Replace.

Expression: VarName.Replace (“original”, “replaced”)

Output datatype: String

Question 9

What is the output data type of Split method?

Answer 9

Array of Strings

Question 10

What does Substring method do?

Answer 10

Extracts a substring from a string using the starting index and the length.

Expression: VarName1.Substring(startIndex, length)

Output datatype: String

Question 11

What is the function of the Matches method in RegEx Builder?

Answer 11

Searches an input string for all the occurences and returns all the successful matches.

Output datatype: System.Collections.Generic.IEnumerable<System.Text.RegularExpressions.Match></System.Text.RegularExpressions.Match>

Question 12

What is the function of the IsMatch method in RegEx Builder?

Answer 12

Indicates whether the specified regular expression finds a match in the specified input string.

Output datatype: Boolean

Question 13

What is the function of the Replace method in RegEx Builder?

Answer 13

Replaces strings that match a regular expression pattern with a specified replacement string.

Output datatype: String

Question 14

Choose four typical uses of RegEx:
A. String Parsing
B. Data Scraping
C. Interacting with UI Elements
D. String manipulation
E. Debugging
F. Input validation

Answer 14

A. String Parsing
B. Data Scraping
D. String manipulation
F. Input validation

Question 15

Consider the string variable Letters = “abcdefg”.

Which out of the four values would the expression Letters.Substring(1,2) return?

1. “ab”
   2.”bcd”
   3.”abc”
   4.”bc”

Answer 15

4. “bc”

Question 16

Which out of the three activities can be used to process every item in a collection individually?
1. While
2. For Each
3. Do While

Answer 16

2. For Each

Question 17

Pair the following methods that use the RegEx builder with the correct explanations.
A. Matches
B. Replace
C. IsMatch

1.Searches an input string for all occurrences and returns all the successful matches.
2. Indicates if the specified regular expression finds a match in the specified input string.
3. Replaces strings that match a Regex pattern with a specified replacement string.

Answer 17

A. 1
B. 3
C. 2

Question 18

Which out of the four options is the correct way to concatenate a string variable (Username) with a string (“ is online”)?
1. Username + is online
2. Username + “ is online”
3. “Username” + “ is online”

Answer 18

2. Username + “ is online”

Question 19

What will the following expression return?

String.Format(“{1} is {0}”, “home”, “John”, “far away”, 0, 1)

A. “John is far away”
B. “1 is 0”
C. “Home is far away”
D. “John is home”

Answer 19

D. “John is home”

Question 20

Consider the list of strings ListOfContinents = {“Africa”, “Antarctica”, “Asia”, “Australia”, “Europe”, “North America”, “South America”}.

What value will the expression ListOfContinents(2) return?

Answer 20

Asia

Question 21

Which of the three collection data types is the best to store several cake recipes (names and ingredients)?

Answer 21

Dictionary

Question 22

Which of the following string modifications can be performed using the Modify Text activity?
1. Combine Text
2. Trim
3. Text to Upper/Lower
4. Find and Replace
5. Split

Answer 22

1. Combine Text
2. Trim
3. Text to Upper/Lower
4. Find and Replace