GroundTruth GIS Technician Interview Questions and Answers

Q1. Difference between SQL and PL/SQL
Ans. 
SQL is a standard language for managing relational databases, while PL/SQL is Oracle's proprietary extension for SQL with procedural features.
• SQL is a standard language used to manage and manipulate relational databases.

• PL/SQL is Oracle's proprietary extension to SQL that adds procedural programming capabilities.

• SQL is used for querying and updating data, while PL/SQL is used for writing stored procedures, functions, a...read more
Answered by AI
Add your answer
Q2. What is trigger
Ans. 
A trigger is a special kind of stored procedure that is automatically executed when certain events occur in a database.
• Triggers can be used to enforce business rules, perform data validation, or automate tasks.

• Examples of trigger events include INSERT, UPDATE, and DELETE operations on a table.

• Triggers can be defined to execute before or after the triggering event.
Answered by AI
Add your answer

Q1. Questions on vlook up, h-look up, pivot and if else condition
Add your answer
Q2. You must know how to use vlook up, h-look up and if-else condition
Add your answer

Excel file was give, used sumifs, countifs , index match formulas

Q1. What is invoke controller?
Ans. 
Invoke controller is a component in a software application that manages the flow of requests and responses between the user interface and the backend services.
• Manages the communication between user interface and backend services

• Handles the routing of requests to appropriate functions or methods

• Coordinates the flow of data and actions within the application
Answered by AI
Add your answer
Q2. What is facade in laravel?
Ans. 
Facade in Laravel is a design pattern that provides a simple interface to a complex subsystem.
• Facade provides a static interface to classes that are available in the application's service container.

• It is used to simplify the usage of complex classes by providing a simpler interface.

• Facade allows you to access Laravel's features without needing to instantiate objects or use dependency injection.

• Example: The Auth facade ...read more
Answered by AI
Add your answer

Q1. Laravel framework question.
Add your answer

Q1. Laravel framework question
Add your answer

Q1. Reasons for the drop in CPM
Ans. 
Possible reasons for drop in CPM include seasonality, changes in ad inventory, shifts in audience demographics, and increased competition.
• Seasonal fluctuations in advertising demand

• Changes in available ad inventory

• Shifts in audience demographics affecting targeting effectiveness

• Increased competition leading to lower bids
Answered by AI
Add your answer
Q2. Types of floor in GAM
Ans. 
Types of floors in GAM include carpet, hardwood, tile, and laminate.
• Carpet

• Hardwood

• Tile

• Laminate
Answered by AI
Add your answer

HTML, HTML5 ,CSS , Bootstrap, javaScript

First there was aptitude round

The coding question was average level

Q1. Resumes and project related questions were asked
Add your answer
Q2. Explain you project
Add your answer
Q3. How to create external tab link
Ans. 
To create an external tab link, use HTML anchor tag with target attribute set to _blank.
• Use <a> tag in HTML with href attribute pointing to the external link

• Set the target attribute of the <a> tag to _blank to open the link in a new tab

• Example: <a href='https://www.example.com' target='_blank'>External Link</a>
Answered by AI
Add your answer

Software testing and coding related questions

Programming test coding

Q1. Myself intro HR subject question with answer
Add your answer
Q2. Subject related questions
Add your answer
Q3. What is types software testing
Ans. 
Types of software testing include unit testing, integration testing, system testing, and acceptance testing.
• Unit testing focuses on testing individual components or modules of the software.

• Integration testing involves testing how different modules work together.

• System testing checks the entire system as a whole.

• Acceptance testing ensures that the software meets the requirements of the end users.
Answered by AI
View 1 more answer
Q4. What is unit testing
Ans. 
Unit testing is a software testing method where individual units or components of a software are tested in isolation.
• Unit testing helps in identifying bugs early in the development process.

• It ensures that each unit of code is working as expected.

• Unit tests are automated and can be run frequently to catch regressions.

• Mocking and stubbing are often used in unit testing to isolate the unit being tested.

• Example: Testing a ...read more
Answered by AI
Add your answer
Q5. What is integration testing
Ans. 
Integration testing is testing the interactions between different components/modules of a software system.
• Tests how well different parts of the system work together

• Ensures that data flows correctly between components

• Identifies any issues with communication or data transfer

• Examples: testing API integrations, testing database connections
Answered by AI
Add your answer
Q6. What is types of software testing
Ans. 
Types of software testing include unit testing, integration testing, system testing, and acceptance testing.
• Unit testing focuses on testing individual components or modules of the software.

• Integration testing involves testing the interactions between different components/modules.

• System testing tests the entire system as a whole.

• Acceptance testing is performed to validate if the software meets the requirements of the st
Answered by AI
Add your answer
Q7.  What is integration testing
Ans. 
Integration testing is testing the interactions between different components or systems to ensure they work together correctly.
• Integration testing verifies that different modules or components of a software work together as expected.

• It focuses on testing the interfaces and interactions between components.

• Examples include testing the integration between a front-end user interface and a back-end database, or between diff
Answered by AI
Add your answer