1. Which normal form specifically removes transitive dependencies on a non-key attribute?
2. In a relational database, which constraint ensures that a foreign-key value either matches a candidate-key value in the referenced table or is NULL where allowed?
3. Which SQL operation combines rows from two relations based on a related attribute and returns only matching rows from both sides?
4. A database transaction moves from the active state to which state immediately after its final statement executes successfully, before the commit becomes durable?
5. Which ACID property guarantees that concurrent transactions behave as though they were executed serially?
6. In B+ trees used for database indexing, where are actual record pointers typically stored?
7. Which index is most appropriate when a table column has very low cardinality, such as a status field with only a few possible values?
8. Which database anomaly occurs when deleting one tuple unintentionally removes the only stored fact about another entity?
9. In SQL, which clause filters groups after GROUP BY has been applied?
10. Which concurrency-control technique orders conflicting operations according to transaction timestamps and may roll back transactions that violate that order?
11. A schedule is conflict-serializable if its precedence graph is:
12. Which RAID level provides block-level striping with distributed parity and can tolerate the failure of any one disk?
13. Which DBMS component is primarily responsible for choosing an efficient execution plan for a SQL query?
14. What is a materialized view?
15. Which property of a candidate key requires that no proper subset of the key can uniquely identify a tuple?
16. Which OS scheduling algorithm can cause starvation of low-priority processes unless aging is used?
17. In virtual memory, a page fault occurs when:
18. Which page-replacement algorithm is theoretically optimal because it replaces the page that will not be used for the longest time in the future?
19. What is the necessary condition for deadlock represented by a process holding at least one resource while waiting for additional resources?
20. Which technique lets an operating system move an entire process temporarily from main memory to secondary storage?
21. A semaphore initialized to 1 is commonly used as a:
22. Which scheduling metric is the total time from process submission to process completion?
23. Which of the following is a non-preemptive CPU scheduling algorithm in its standard form?
24. The primary purpose of a Translation Lookaside Buffer (TLB) is to:
25. Thrashing in a virtual-memory system is characterized by:
26. At which OSI layer does IP operate?
27. Which transport-layer protocol provides connection-oriented, reliable byte-stream delivery?
28. Which protocol maps an IPv4 address to a MAC address on a local network?
29. Which protocol is used by a host to obtain an IP configuration automatically from a server?
30. Which subnet mask corresponds to a /26 IPv4 prefix?
Quiz Summary
Final Score: 0.0
