
DIFFICULT LEVEL PSITE QUIZBOWL
Quiz by MARY GRACE PEROCHO
Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.
Consider a hash table with collisions resolvedusing double hashing. If the primary hash function is h1(key)=key(modm) and the secondary hash function is h2(key)=1+(key(modm−1)),where m is the tablesize. To insert a key that hashes to the same initial location as an existingkey, the probe sequence of indices will be:
Consider a relational database schema with tables R(A, B) and S(B, C), where B is a foreign key in S referencing A in R. Which of the following SQL queries correctly expresses the natural join of R and S?
In the context of Service-Oriented Architecture (SOA), which of the following principles emphasizes that services should have minimal dependencies on each other and that a change in one service should have minimal impact on others?
A network segment has a network address of 192.168.1.0/27. What is the range of valid host IP addresses for this subnet?
Which of the following security mechanisms is primarily designed to protect against Cross-Site Request Forgery (CSRF) attacks?
Consider the following Python code snippet:
Python
def outer(x):
def inner(y):
return x + y
return inner
add_five = outer(5)
result = add_five(3)
What is the value of the result variable?
A server is experiencing intermittent high CPU utilization. Initial investigation shows no single process consistently consuming excessive CPU. Which of the following tools would be most effective for identifying transient spikes in CPU usage by various processes over time on a Linux system?
In computer architecture, what is the primary purpose of cache coherence protocols in a multi-processor system?
In the context of blockchain technology, what is the "Byzantine Fault Tolerance" (BFT) property primarily designed to address?
Given a binary search tree, which traversal method would output the keys in non-decreasing sorted order?
Consider a transaction in a database system that involves multiple read and write operations. Which of the following ACID properties ensures that if the transaction completes successfully, all the changes it made to the database are permanently saved?
In component-based development, what is the role of an "interface"?
What is the primary difference between TCP (Transmission Control Protocol) and UDP (User Datagram Protocol)?
What is the Same-Origin Policy (SOP) in web security primarily designed to prevent?
What is "memoization" in programming?
A virtual machine (VM) on a hypervisor is experiencing network connectivity issues. The host machine has a working internet connection. What is a common area to investigate within the VM's network configuration?
What is the fundamental principle behind asymmetric cryptography (public-key cryptography)?
What is a primary challenge associated with the widespread adoption of microservices architecture?
In the context of NoSQL databases, which of the following consistency models offers the strongest guarantee of data consistency across distributed nodes?
What is the purpose of BGP (Border Gateway Protocol) in the internet?
In agile methodologies, what does the concept of "technical debt" refer to?
What is the primary function of a Content Delivery Network (CDN)?
Consider a scenario where multiple threads are trying to access and modify a shared resource. What mechanism can be used to prevent race conditions and ensure data integrity?
What is a key characteristic of "serverless computing"?