Download MTA Software Development Fundamentals Ultimate Exam and more Exams Technology in PDF only on Docsity!
Ultimate Exam
Question 1. Which of the following data types typically occupies 4 bytes of memory in most modern programming languages? A) short B) int C) long D) byte Answer: B Explanation: An int is commonly implemented as a 32‑bit (4‑byte) signed integer on most platforms. Question 2. In a stack‑based memory model, which region is used for storing local variables and function call information? A) Heap B) Data segment C) Stack D) Code segment Answer: C Explanation: The stack holds local variables, return addresses, and other call‑frame data for each function invocation. Question 3. Which operator tests whether two values are not equal in C‑style languages? A) = B) <> C) != D) == Answer: C Explanation: != returns true when the operands differ; == tests for equality. Question 4. A flowchart uses a diamond shape to represent which construct? A) Process step
Ultimate Exam
B) Decision point C) Input/Output D) Loop start Answer: B Explanation: Diamonds denote decisions or conditional branches in flowcharts. Question 5. Which loop guarantees that its body executes at least once before the condition is evaluated? A) for B) while C) do‑while D) foreach Answer: C Explanation: A do‑while loop checks its condition after executing the loop body, ensuring one execution. Question 6. What term describes a function that calls itself directly or indirectly? A) Iteration B) Recursion C) Overloading D) Delegation Answer: B Explanation: Recursion is the technique where a method invokes itself to solve a problem. Question 7. In structured exception handling, which block always executes regardless of whether an exception occurs? A) try B) catch C) finally
Ultimate Exam
Explanation: “is‑a” relationships are modeled using inheritance; Car derives from Vehicle. Question 11. What keyword is used in C# to hide a base‑class member with a new implementation in a derived class? A) override B) new C) virtual D) abstract Answer: B Explanation: The new keyword hides the base member, creating a separate member in the derived class. Question 12. Which principle of OOP encourages keeping data fields private and exposing them through methods? A) Polymorphism B) Encapsulation C) Inheritance D) Abstraction Answer: B Explanation: Encapsulation restricts direct access to internal state, protecting integrity. Question 13. Which software development phase focuses on converting user requirements into detailed design diagrams and specifications? A) Planning B) Designing C) Testing D) Maintenance Answer: B Explanation: The design phase elaborates requirements into architecture, models, and technical plans.
Ultimate Exam
Question 14. Which testing level verifies that individual functions or methods work correctly in isolation? A) Unit testing B) Integration testing C) System testing D) Acceptance testing Answer: A Explanation: Unit tests target the smallest testable parts—typically single functions or methods. Question 15. Which data structure follows a “first‑in, first‑out” (FIFO) ordering? A) Stack B) Queue C) Linked list D) Tree Answer: B Explanation: Queues dequeue elements in the order they were enqueued, implementing FIFO behavior. Question 16. Which sorting algorithm has an average‑case time complexity of O(n log n) and is stable? A) Bubble sort B) Insertion sort C) Merge sort D) Selection sort Answer: C Explanation: Merge sort divides the list recursively and merges sorted halves, achieving O(n log n) and preserving order of equal elements.
Ultimate Exam
C) shift() D) unshift() Answer: A Explanation: push() appends a new element to the array’s tail. Question 21. During the ASP.NET Page Life Cycle, which event occurs first? A) Load B) PreRender C) Init D) Unload Answer: C Explanation: Init runs before view state is restored and before Load. Question 22. Which ASP.NET state‑management technique stores data on the client but is encrypted to prevent tampering? A) ViewState B) Session State C) Application State D) Cache Answer: A Explanation: ViewState is embedded in the page markup, base‑64 encoded and optionally encrypted. Question 23. In client‑side processing, which language runs directly in the browser without contacting the server? A) C# B) JavaScript C) VB.NET D) SQL
Ultimate Exam
Answer: B Explanation: JavaScript is interpreted by the browser, enabling interactivity without server round‑trips. Question 24. Which IIS feature allows hosting multiple web sites on a single server using different host headers? A) Application Pools B) Virtual Directories C) Host Name Binding D) URL Rewrite Answer: C Explanation: Host name bindings map distinct domain names to separate sites on the same IP/port. Question 25. Which protocol uses XML to encode its messages and is typically described by a WSDL document? A) REST B) SOAP C) FTP D) SMTP Answer: B Explanation: SOAP (Simple Object Access Protocol) relies on XML envelopes, with WSDL defining service contracts. Question 26. In a Windows Forms application, which event is raised when a button is clicked? A) MouseEnter B) Click C) Load D) Paint Answer: B Explanation: The Click event fires when the user activates the button.
Ultimate Exam
A) Foreign key B) Primary key C) Index D) Constraint Answer: B Explanation: The primary key enforces uniqueness and non‑null values for each row. Question 31. Which SQL clause is used to combine rows from two tables based on a related column? A) UNION B) WHERE C) JOIN D) GROUP BY Answer: C Explanation: JOIN merges rows from two tables using a specified relationship. Question 32. Which SQL command removes all rows from a table but retains its structure? A) DELETE B) DROP C) TRUNCATE D) REMOVE Answer: C Explanation: TRUNCATE quickly deletes all data while preserving the table definition. Question 33. What is the default isolation level in SQL Server that prevents dirty reads? A) READ UNCOMMITTED B) READ COMMITTED C) REPEATABLE READ
Ultimate Exam
D) SERIALIZABLE
Answer: B Explanation: READ COMMITTED ensures that only committed transactions are visible, avoiding dirty reads. Question 34. Which XML schema language is used to define the structure, content, and data types of an XML document? A) DTD B) XSD C) XSLT D) XPath Answer: B Explanation: XSD (XML Schema Definition) provides a rich type system for XML validation. Question 35. In C#, which keyword makes a class member accessible only within its own class? A) protected B) internal C) private D) public Answer: C Explanation: private restricts access to the declaring class only. Question 36. Which of the following best describes method overloading? A) Same method name with different parameter lists in the same class B) Same method name in a derived class that replaces the base implementation C) A method that calls itself recursively D) A method that can accept any number of arguments Answer: A
Ultimate Exam
Question 40. In RESTful services, which HTTP method is conventionally used to update an existing resource partially? A) POST B) GET C) PATCH D) DELETE Answer: C Explanation: PATCH applies partial modifications, while PUT replaces the entire resource. Question 41. Which of the following statements about static members in C# is true? A) They belong to an instance of a class. B) They can be accessed without creating an object. C) They can be overridden in derived classes. D) They must be declared as abstract. Answer: B Explanation: Static members are associated with the type itself and can be accessed via the class name. Question 42. Which loop construct is guaranteed to execute its body zero or more times, depending on the condition evaluated before each iteration? A) for B) while C) do‑while D) foreach Answer: B Explanation: while checks the condition first; if false, the body may never execute. Question 43. In object‑oriented design, which principle states that a class should have only one reason to change?
Ultimate Exam
A) Open/Closed Principle B) Liskov Substitution Principle C) Single Responsibility Principle D) Interface Segregation Principle Answer: C Explanation: The Single Responsibility Principle (SRP) advocates that a class encapsulate only one responsibility. Question 44. Which SQL aggregate function returns the average value of a numeric column? A) SUM() B) COUNT() C) AVG() D) MAX() Answer: C Explanation: AVG() computes the mean of the selected numeric values. Question 45. In a Windows Forms application, which property of a control determines its position relative to its container? A) Size B) Location C) Anchor D) Dock Answer: B Explanation: Location specifies the X‑Y coordinates of the control within its parent. Question 46. Which HTTP status code indicates that the request was successful and a new resource was created? A) 200 OK B) 201 Created
Ultimate Exam
Explanation: void specifies that the method has no return type. Question 50. Which data structure is most appropriate for implementing an undo feature in a text editor? A) Queue B) Stack C) Tree D) Hash table Answer: B Explanation: A stack allows last‑in‑first‑out retrieval, matching the reverse order of user actions. Question 51. In HTML5, which element is used to embed a video file? A) B) C) D) Answer: B Explanation: `` provides native support for playing video content. Question 52. Which CSS selector targets all <p> elements that are direct children of a </p>? A) div p B) div > p C) .div > p D) p.div Answer: B Explanation: The > combinator selects only immediate child elements.
Ultimate Exam
Question 53. In JavaScript, which keyword declares a block‑scoped variable that cannot be re‑assigned? A) var B) let C) const D) static Answer: C Explanation: const creates a read‑only binding; the variable cannot be reassigned after initialization. Question 54. Which ASP.NET control automatically maintains its state across postbacks without additional code? A) TextBox B) Label C) ViewState D) HiddenField Answer: A Explanation: Input controls like TextBox store their values in ViewState, persisting across postbacks. Question 55. Which of the following is a NoSQL database model? A) Relational B) Document C) Hierarchical D) Network Answer: B Explanation: Document databases (e.g., MongoDB) store semi‑structured JSON‑like documents. Question 56. Which algorithmic technique repeatedly divides a problem into two sub‑problems of the same type? A) Dynamic programming
Ultimate Exam
D) ICloneable Answer: A Explanation: IEnumerable (or IEnumerable) provides the GetEnumerator method required by foreach. Question 60. Which HTTP header is used by a server to instruct the client not to cache the response? A) Content-Type B) ETag C) Cache-Control: no-store D) Authorization Answer: C Explanation: Cache-Control: no-store tells browsers and proxies not to store the response. Question 61. In a relational database, which operation combines the result sets of two SELECT statements and removes duplicate rows? A) UNION ALL B) INTERSECT C) UNION D) EXCEPT Answer: C Explanation: UNION merges rows and eliminates duplicates; UNION ALL retains them. Question 62. Which of the following is a characteristic of a properly normalized database? A) Redundant data is minimized B) All columns are of type VARCHAR C) Tables contain only primary keys D) No foreign keys are used Answer: A
Ultimate Exam
Explanation: Normalization reduces data redundancy and improves integrity. Question 63. Which C# feature allows a method to accept a variable number of arguments? A) params keyword B) ref keyword C) out keyword D) async keyword Answer: A Explanation: params enables callers to pass a comma‑separated list or an array. Question 64. Which of the following is true about the sealed keyword in C#? A) It prevents a class from being inherited. B) It forces a class to be abstract. C) It makes all members static. D) It allows multiple inheritance. Answer: A Explanation: A sealed class cannot serve as a base class. Question 65. In JavaScript, which method converts a JSON string into a native object? A) JSON.stringify() B) JSON.parse() C) JSON.convert() D) JSON.objectify() Answer: B Explanation: JSON.parse() deserializes a JSON‑encoded string. Question 66. Which of the following best describes a “race condition”?
