MTA Software Development Fundamentals Practice Exam

These questions are part of the practice quiz. Start practicing

• What does the term "thrown" refer to in programming?
• What is a Windows Service application?
• What are the five steps of the page life cycle in ASP.NET?
• Which type of class cannot be instantiated?
• Which of the following is **not** a role of IIS (Internet Information Services)?
• What distinguishes a console application from other types of applications?
• Which of the following is considered a client-side technology?
• What does UML do?
• What does a primary key define in a table?
• Which of the following is an advantage of using a disconnected access model?
• Which of the following is an advantage of using disconnected data access?
• What can be established by setting up a foreign key constraint?
• What are three common sort algorithms?
• What is a cookie in web development?
• What type of user interface do most Windows Services use?
• What algorithm would you use to arrange data in alphabetical order?
• In the context of databases, what is a key feature of a disconnected access model?
• In which scenario would visual inheritance be most beneficial?
• Which variable type would be appropriate for storing a player's gender?
• Where do reference data types usually get allocated in memory?
• Which type of interface do recent applications favor?
• What does SOAP stand for?
• What is a virtual directory?
• What characterizes the execution of a do..while loop?
• Which loop type is better for situations where the number of iterations isn't predetermined?
• Which of the following is NOT an example of an integral data type?
• In the context of exception handling, what is a 'catch' block?
• What is the difference between an event model and a client application?
• Which of the following allows page information to be retained in a web application?
• What is the purpose of the new keyword as a modifier in C#?
• What is the main function of a while loop?
• A Windows Service generally has three different states after being started: running, stopped, and what?
• Which of the following statements is true about arrays?
• Which statement is true about the DELETE command?
• What does a connection string contain?
• What is the primary role of the Windows Services Control Manager?
• What type of access model do most developers use?
• What is the main feature of a Stack data structure?
• What type of application would be good for storing, viewing, and updating a large number of inventory records?
• Phenomena of a user lacking clarity on how to interact with software interfaces can be attributed to what?
• What is a queue?
• What is the function of the base keyword?
• Which command is used to filter records based on certain conditions?
• What is the primary advantage of a relational database?
• In what scenario is a for loop most effective?
• Which of the following data types would be the best choice for keeping track of player's ages using the least amount of memory?
• When the sealed keyword is applied to a member, what does it accomplish?
• What does XML stand for?
• Which sorting algorithm is known for its simplicity in implementation?
• Visual inheritance allows for which of the following advantages?
• What characterizes floating point data types?
• Which of the following components is essential for a Windows Service to run successfully?
• Which data structure would typically be used for first-in, first-out data management?
• Which structure uses pointers to connect elements?
• What does the acronym CRUD stand for in database management?
• In C#, what does the term encapsulation refer to?
• What does the override keyword allow you to do?
• What accessibility level is typically assigned to instance variables?
• When using the Bing API, what is the role of Bing in relation to web services?
• What does the acronym CSS stand for?
• In an if statement, what must the code within the parentheses be?
• What must be established to bring data into an application?
• Which control structure is commonly recommended for a login system?
• What logic do queues follow?
• What term describes an in-memory cache of a database?
• Which structure allows developers to prevent program crashes when exceptions occur?
• How does LINQ facilitate data manipulation?
• What do relational databases consist of?
• What are the two primary functions of IIS?
• Which of the following allows access to encapsulated class members?
• Which data type consumes the least amount of memory?
• What is an example of a Graphical User Interface?
• How does a web service typically function in an application?
• What is the purpose of protected variables in a class?
• What is a significant advantage of linked lists?
• Queries can be saved to a database as:
• What is the effect of the SELECT statement in SQL?
• What characterizes a Single Document Interface (SDI)?
• Which of the following is not a characteristic of WSDL?
• What logic do stacks follow?
• Which of these correctly defines server-side scripting?
• What is a key advantage of using CSS?
• What keyword would you use to hide a member of a base class?
• How does a for loop operate?
• Which of the following types is likely to be used for a player's height?
• What does a sort algorithm do?
• What are Windows Services managed by?
• What does the SELECT statement do in SQL?
• Which of the following is NOT a feature of Command-Line Interfaces?
• Which programming construct allows for iteration based on a collection of elements, rather than a condition?
• How many times is a do..while loop guaranteed to execute?
• Why is client-side scripting typically faster than server-side scripting?
• What happens when a boolean expression in a while loop evaluates to false?
• Where can virtual directories be configured?
• Which keyword is used to indicate that a method can be overridden?
• Which command is used to remove data from a database?
• What is an event handler?
• What is the purpose of a database index?
• What is the purpose of the WHERE clause in a SQL statement?
• What are the two basic styles of Windows interfaces?
• What do logical operators enable programmers to accomplish?
• What are flat files?
• Which of the following services is an example of a SOAP service?
• Which data type is typically used to store whole numbers?
• What does SDI stand for in relation to user interfaces?
• What is the maximum value for a byte data type?
• How does a Windows Service differ from regular applications?
• Which component contains attributes and methods in object-oriented programming?
• What is a disadvantage of using web services?
• Which command would you use to combine rows from two or more tables based on a related column?
• What does inheritance allow developers to do?
• What is another term commonly used for black-boxing in software development?
• What does encapsulation refer to in object-oriented programming?
• What does LINQ stand for?
• What is the definition of an exception in programming?
• What does LINQ allow developers to do?
• How can an element be accessed in an array?
• Which of the following is a valid SQL command?
• What do constructors do in a class?
• Which service is typically included in an ISP's offerings?
• Which keyword is used to create objects in programming?
• What do the advantages of flat files generally include?
• What is a server-side script?
• What is the primary function of web services?
• What is the main reason for restricting access to data?
• What is SQL primarily used for?
• What is the primary role of the connection string?
• What defines an array?
• What does SQL stand for?
• What is a relational database?
• What does the UPDATE command accomplish in database operations?
• What distinguishes a do..while loop from a while loop?
• Which of the following is NOT typically provided by an ISP?
• What is an advantage of using JavaScript in web development?
• Why are many users comfortable working with XML files?
• What is required for user input in a user interface?
• Which benefit does a disconnected access model provide regarding file access?
• What does the term instantiated refer to?
• Why is the ALM process iterative?
• Which data type should be used to store a timestamp or date?
• What is an example of a Windows Service application?
• What is the primary function of the INSERT command in a database?
• How many bytes does a double data type typically consume?
• What is a stack?
• Which of the following describes a major advantage of Graphical User Interfaces over Command-Line Interfaces?
• What is a client-side script?
• How can a company ensure a new version of an application will work on old computers with limited RAM and hard drive space?
• What is polymorphism in programming?
• Which technology uses tags to indicate how information should be displayed in a web browser?
• What are the four most common data structures?
• Which type of application typically uses command-line interfaces?
• Which process is critical for the functionality of dynamic web applications?
• What does IIS stand for?
• What is a web service?
• Which of the following is not a characteristic of many Windows Services?
• How is a linked list structured?
• What is JavaScript?
• Where do value data types typically reside in memory?
• What is the outcome of using the DELETE command?
• What type of interface does a user interface provide?
• What type of data exchange does SOAP facilitate?
• In which of the following scenarios is a stack primarily used?
• What are the two types of scripts that can run in a web application?
• What is the page life cycle in ASP.NET?
• What is the primary function of a class?
• What is a field in the context of a class?
• What is the primary purpose of HTML?
• What is defined as the portion of a program where users interact?
• What can the UPDATE command not do?
• The IIS is a component of which operating system?
• What is the role of derived classes?
• What does the FROM clause specify in a SQL statement?
• What happens when an exception is caught in a try-catch block?
• Which data structure is commonly used for organizing large amounts of data?
• A new row can be added to a database with which command?
• What does MDI stand for?
• Why might a developer choose a linked list over an array?
• What is meant by 'state management' in an ASP.NET application?
• What is the primary purpose of SOAP?
• How can "U2" be retrieved from a table of artists?
• What structure does a virtual directory provide within web servers?
• What does UML stand for?
• What is the primary purpose of a mock-up?
• What is the function of WSDL?
• What is one of the primary advantages of using XML?
• Which of the following scenarios typically involves the use of Windows Services?
• What is the term for a non-functioning demonstration of an application?
• What does state management refer to in web applications?
• What type of loop executes a block of code at least once, regardless of the condition?
• What does ALM stand for?
• Which user interface is more suitable for inexperienced users?
• Which of the following best describes the concept of a web service?
• Which of the following is NOT a floating point data type?
• What does the virtual keyword allow when applied to a method?
• What does ISP stand for?
• What does the acronym GUI stand for?
• What type of data will typically be stored on the heap?
• How are Windows Services run?
• Which of the following best describes server-side scripting?
• Which SQL command would you use to change existing data in a table?
• Which of the following provides means for reading and/or modifying private attributes?
• Which of the following is a benefit of using a virtual directory?
• What happens to a class marked as sealed?
• What advantage do Windows Services provide compared to standard applications?
• What is a characteristic of a Multiple Document Interface (MDI)?
• Which data structure follows a "last in, first out" model?
• What are the 5 phases of ALM, in order?
• Which of the following describes a common characteristic of flat files?
• What does WSDL stand for?
• Why may some developers prefer flat files over relational databases?
• What is one capability of a virtual directory?
• What is the function of the sealed keyword when applied to a class?
• What kind of diagrams are generally drawn as UML diagrams?
• What is Windows Forms primarily used for?
• Which access modifier should be used for primary methods to make them accessible from anywhere?
• In what way can cookies enhance user experience on a website?
• What is the purpose of a try statement in programming?
• Which of the following is a framework commonly used to access a web service?
• What is a disadvantage of a disconnected access model?
• What is the strategy called when teams test their classes independently?