AM Software Test 3 1 Comment / By fawadtwopointo@gmail.com / August 22, 2025 Welcome to your AM Software Test 3 Which of the following languages uses a virtual machine for execution? Assembly Java C C++ None Which concept allows a function in C++ to have the same name but different parameters? Overloading Overriding Inheritance Polymorphism None Which keyword in C++ prevents a class from being inherited? static protected private final None Which of the following is NOT a linear data structure? Stack Tree Queue Array None What is the time complexity of searching in a balanced binary search tree? O(n log n) O(n) O(log n) O(1) None Which isolation level prevents dirty reads? Serializable Read Committed Repeatable Read Read Uncommitted None What is the purpose of ACID properties in transactions? To reduce memory To ensure consistency To compress data To improve speed None Which type of join returns only matching rows from both tables? LEFT JOIN FULL OUTER JOIN CROSS JOIN INNER JOIN None What does the SQL command GRANT do? Updates data Removes permissions Gives permissions Deletes a table None Which indexing technique improves query performance in DBMS? Deadlock prevention Normalization Hashing Denormalization None Which testing is performed by end users? System testing Integration testing Unit testing Acceptance testing None Which of the following is NOT an Agile framework? Spiral Kanban Scrum XP (Extreme Programming) None Which of the following is NOT an Agile framework? Kanban Scrum Spiral XP (Extreme Programming) None Which software cost estimation model is widely used? COCOMO V-Model SRS Agile None What is the main advantage of modular programming? No compilation needed Code reusability Faster CPU None Which metric measures how modules depend on each other? Reliability Cohesion Efficiency Coupling None In paging, what does TLB stand for? Transfer Load Balancer Temporary Logic Buffer Translation Lookaside Buffer Table Lookup Block None Which of the following is NOT a page replacement algorithm? Optimal FIFO LRU Binary Search None In process states, which state comes after "Ready"? Terminated Running Waiting New None IPv6 uses how many bits for addresses? 256 32 128 64 None Which protocol is connection-oriented? TCP ICMP IP UDP None In hashing, what problem does open addressing solve? Collisions Data redundancy Indexing Normalization None Dijkstra’s algorithm is used for: Minimum spanning tree Multiplication Shortest path Sorting None Which data structure is used in Depth First Search (DFS)? Stack Linked list Array Queue None Heap sort uses which data structure? Heap Graph Stack Queue None What is the worst-case time complexity of QuickSort? O(n log n) O(n) O(log n) O(n²) None Who invented the World Wide Web? Bill Gates Mark Zuckerberg Tim Berners-Lee Larry Page None First computer virus was: Blaster ILOVEYOU Creeper Melissa None Which is the smallest ocean in the world? Southern Arctic Atlantic Indian None Synonym of “Ambiguous”? Clear Confusing Exact Simple None Antonym of “Artificial”? Real Synthetic Fake False None Time's upTime is Up!
Anonymous August 28, 2025 at 7:26 am In AM Software Test 3, correct the following: Which isolation level prevents dirty reads? Read Committed Read Uncommitted Repeatable Read Serializable Correct answer: Read Committed [but highlighting wrong answer] Which indexing technique improves query performance in DBMS? Hashing Denormalization Normalization Deadlock prevention Correct answer: Hashing [but highlighting Denormalization] Which of the following is NOT an Agile framework? [repeated MCQ] Which software cost estimation model is widely used? COCOMO V-Model SRS Agile Correct answer: COCOMO [but not highlighting it] IPv6 uses how many bits for addresses? 256 32 64 128 Correct answer: 128 [but marking it wrong in red color] Reply
In AM Software Test 3, correct the following:
Which isolation level prevents dirty reads?
Read Committed
Read Uncommitted
Repeatable Read
Serializable
Correct answer: Read Committed [but highlighting wrong answer]
Which indexing technique improves query performance in DBMS?
Hashing
Denormalization
Normalization
Deadlock prevention
Correct answer: Hashing [but highlighting Denormalization]
Which of the following is NOT an Agile framework? [repeated MCQ]
Which software cost estimation model is widely used?
COCOMO
V-Model
SRS
Agile
Correct answer: COCOMO [but not highlighting it]
IPv6 uses how many bits for addresses?
256
32
64
128
Correct answer: 128 [but marking it wrong in red color]