IT and Programming Concepts Flashcards
7 cards from real Robert Half Assessment Test practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 7 IT and Programming Concepts flashcards as text
What is the purpose of a 'JOIN' clause in SQL?
Answer: To combine rows from two or more tables based on a related column
A JOIN clause combines rows from multiple tables by matching values in related columns, enabling queries across relational data.
In software development, what is 'Agile'?
Answer: An iterative development methodology emphasizing collaboration and adaptability
Agile is a software development approach using short iterative cycles (sprints), continuous feedback, and cross-functional team collaboration.
Which of the following correctly describes the difference between RAM and ROM?
Answer: RAM is temporary and loses data when powered off; ROM is permanent and retains data
RAM (Random Access Memory) is volatile and loses its contents when power is off, while ROM (Read-Only Memory) retains data permanently.
What is the role of a 'constructor' in object-oriented programming?
Answer: To initialize a new object with default or specified values when it is created
A constructor is a special method called automatically when a new instance of a class is created, used to set initial state.
What does 'latency' mean in the context of networking?
Answer: The delay between sending a request and receiving a response
Latency is the time delay experienced in a network, typically measured in milliseconds from request to response.
Which of the following is a characteristic of an object-oriented 'abstract class'?
Answer: It cannot be instantiated and is designed to be subclassed
An abstract class defines a template for subclasses but cannot be instantiated directly; it may include abstract methods that subclasses must implement.
What is the primary function of the OSI model in networking?
Answer: To provide a standardized framework describing how data is transmitted across a network in seven layers
The OSI (Open Systems Interconnection) model divides network communication into 7 layers — from physical transmission to application-level protocols — to standardize interoperability.