Robert Half Assessment Test IT and Programming Concepts 5

Question 1

What is the purpose of a 'JOIN' clause in SQL?

Accepted Answer

To combine rows from two or more tables based on a related column

Answer

To delete records from two tables simultaneously

Answer

To sort query results by multiple columns

Answer

To create a new table from an existing one

Question 2

In software development, what is 'Agile'?

Accepted Answer

An iterative development methodology emphasizing collaboration and adaptability

Answer

A compiled programming language used for system software

Answer

A type of database architecture

Answer

A network protocol for real-time communication

Question 3

Which of the following correctly describes the difference between RAM and ROM?

Accepted Answer

RAM is temporary and loses data when powered off; ROM is permanent and retains data

Answer

RAM is permanent storage; ROM is temporary

Answer

Both are types of hard drives

Answer

RAM stores the operating system; ROM stores user files

Question 4

What is the role of a 'constructor' in object-oriented programming?

Accepted Answer

To initialize a new object with default or specified values when it is created

Answer

To destroy an object when it is no longer needed

Answer

To convert an object to a string format

Answer

To copy the methods of one class into another

Question 5

What does 'latency' mean in the context of networking?

Accepted Answer

The delay between sending a request and receiving a response

Answer

The maximum bandwidth of a network connection

Answer

The number of devices connected to a router

Answer

The encryption strength of a network protocol

Question 6

Which of the following is a characteristic of an object-oriented 'abstract class'?

Accepted Answer

It cannot be instantiated and is designed to be subclassed

Answer

It can be instantiated directly like a regular class

Answer

It has no methods or properties

Answer

It can only contain static methods

Question 7

What is the primary function of the OSI model in networking?

Accepted Answer

To provide a standardized framework describing how data is transmitted across a network in seven layers

Answer

To encrypt all data transmitted over the internet

Answer

To assign IP addresses to network devices

Answer

To define programming syntax for network applications