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