CDM Smith Interview Questions and Answers

I have been part of various stages of software development including requirements gathering, design, development, testing, and deployment.

• Participated in requirement gathering sessions with clients to understand their needs

• Contributed to the design phase by creating technical specifications and architecture diagrams

• Developed software using various programming languages and frameworks

• Performed unit testing and integration testing to ensure the quality of the code

• Deployed softw...read more

Domain refers to a specific area of knowledge or expertise, while data element is a single piece of information within a domain.

• Domain is a broader concept that encompasses multiple data elements.

• Data element is a specific piece of information within a domain.

• For example, in the domain of medicine, 'patient name' and 'blood pressure' are data elements.

• While the domain itself is 'medicine' which includes various data elements like patient information, medical history, etc.

TMG stands for Threat Management Gateway. It is a network security tool used for web protection, firewall, and VPN.

• TMG provides protection against malware, viruses, and other online threats.

• It can be used as a firewall to control network traffic and prevent unauthorized access.

• TMG also offers VPN connectivity for remote access to the network.

• It is commonly used in enterprise environments for secure web access and network protection.

Write SELECT query as per requirement

• Understand the requirement and identify the tables to be queried

• Select the columns to be retrieved

• Apply filters and sorting as per requirement

• Use joins if necessary

• Test the query for accuracy

Expectation is a belief or hope about something that is likely to happen in the future.

• Expectation is a mental state that involves anticipating a certain outcome or result.

• It can be based on past experiences, assumptions, or predictions.

• Expectations can be realistic or unrealistic, and can lead to disappointment or satisfaction depending on the outcome.

• For example, a student may have the expectation of getting an A on a test based on their preparation and past performance.

• In ...read more

Schema in a database is a collection of tables, views, procedures, and other database objects.

• Schema defines the structure of the database, including tables, columns, relationships, and constraints.

• It helps in organizing and managing data in a database.

• Schema can also define access permissions for different users or roles.

• Example: In a library database, the schema may include tables for books, authors, borrowers, and transactions.