MTA Exam Study Guide

MTA Exam Study Guide

1. Flowchart: You need to gain a better understanding of the solution before writing the program.You decide to develop an algorithm that lists all necessary steps to perform an operation in the correct order. Any technique that you use should minimize complexity and ambiguity. Which of the following techniques should you use? 2. Requirements analysis, design, coding, testing, and release: Arrange the various activities of an application lifecycle in the order in which they are likely to occur. 3. Common Intermediate Language (CIL): Which of the following languages is not considered a high-level programming language? 4. void: You are writing a method named PrintReport that doesn't return a value to the calling code.Which keyword should you use in your method declaration to indicate this fact? 5. switch: You need to provide complex multi-way branching in your C# program. You need to make sure that your code is easy to read and understand. Which of the following C# statements should you use? 6. foreach: You are writing a C# program that iterates through a collection such as arrays and lists.You need to make sure that you process each item in the collection once.You also need to ensure that your code is easy to read and debug. Which of the following C# statements provide the best solution for this requirement? 7. long: You are writing a C# program that needs to manipulate very large integer values that may exceed 12 digits.The values can be positive or negative.Which data type should you use to store a variable like this? 8. Inside the finally block: You have written a C# method that opens a database connection by using the SqlConnect object. The method retrieves some information from the database and then closes the connection.You need to make sure that your code fails gracefully when there is a database error. To handle this situation, you wrap the database code in a try-catch-finally block.You use two catch blocks—one to catch the exceptions of type SqlException and the second to catch the exception of type Exception.Which of the following places should be the best choice for closing the SqlConnection object? 9. do-while statement: You are writing a C# program and need to select an appro- priate repetition structure for your requirement. You need to make sure that the test for the termination condition is performed at the bottom of the loop rather than at the top. Which repletion structure should you use? 10. for: You are writing a C# program that needs to iterate a fixed number of times. You need to make sure that your code is easy to understand and maintain even when the loop body contains complex code. Which of the following C# statements provide the best solution for this requirement?