StratTek Consulting Interview Questions and Answers

Q1. Tell me about yourself and standard tell me about a project
Add your answer

Basic level appitude and reasoning test

Case scenario will be given to solve

Q1. General family back ground, location questions.
Add your answer

Interviewer gave business scenarios and asked what will do in this problem statement

Q1. Asked sql, python query questions
Add your answer

Q1. Pivot table in excel
Ans. 
Pivot table is a data summarization tool in Excel.
• Pivot table allows users to summarize and analyze large datasets.

• It can be used to group data by categories, calculate totals, and create custom calculations.

• Users can easily change the layout of the table to view data in different ways.

• Pivot table is a powerful tool for data analysis and reporting.

• Example: A sales manager can use pivot table to analyze sales data by re
Answered by AI
Add your answer
Q2. How to count data in excel
Ans. 
To count data in Excel, use the COUNT function or select the data and look at the status bar.
• Use the COUNT function to count the number of cells that contain numbers or dates

• Use the COUNTA function to count the number of cells that are not empty

• Select the data and look at the status bar to see the count of selected cells

• Use the COUNTIF function to count cells that meet a specific criteria
Answered by AI
Add your answer

Q1. IAM & PAM Operations
Add your answer
Q2. Related to Sailpoint
Add your answer

Q1. Difference between Asp.net and Ado.net? Explain about Ado.net complete briefly?
Ans. 
ASP.NET is a web development framework while ADO.NET is a data access technology for connecting to databases.
• ASP.NET is used for building web applications, while ADO.NET is used for accessing and manipulating data from databases.

• ASP.NET provides a framework for creating dynamic web pages, handling user input, and managing state, while ADO.NET provides a set of classes for interacting with databases.

• ASP.NET includes fea...read more
Answered by AI
Add your answer
Q2. Difference between Functions and stored procedure?
Ans. 
Functions return a value while stored procedures do not.
• Functions are used to perform a specific task and return a value to the caller.

• Stored procedures are used to execute a set of SQL statements and do not return a value.

• Functions can be used in SQL statements while stored procedures cannot.

• Functions can be called from within stored procedures.

• Functions are deterministic while stored procedures may not be.

• Functions c...read more
Answered by AI
Add your answer
Q3. Interface Inheritance Difference between overloading and overriding
Ans. 
Interface is a contract that defines the methods a class must implement. Inheritance is the ability of a class to inherit properties and methods from another class.
• Interface is used to achieve abstraction and multiple inheritance in Java.

• Inheritance allows code reuse and promotes code organization.

• Overloading is having multiple methods with the same name but different parameters.

• Overriding is providing a different impl...read more
Answered by AI
Add your answer

Q1. DevOps tools related questions
Add your answer
Q2. And python programming questions
Add your answer