eClerx
10+ Vstretch Imageworks Interview Questions and Answers
Q1. What type of order will you place if the market is expected to go upward?
I will place a buy order if the market is expected to go upward.
I will analyze the market trends and indicators to confirm the upward trend.
I will place a limit order to buy at a specific price point.
I will monitor the market closely to ensure the order is executed at the desired price.
I will set a stop loss order to minimize potential losses if the market unexpectedly turns downward.
Q2. 1.What do you understand by derivative markets and types 2. Types of cryptocurrency 3. Questions over internship or work exp.
Answering questions related to derivative markets, types of cryptocurrency, and work experience.
Derivative markets are financial markets where investors can trade financial instruments that derive their value from an underlying asset.
Types of derivative markets include futures, options, swaps, and forwards.
Cryptocurrency is a digital or virtual currency that uses cryptography for security.
Types of cryptocurrency include Bitcoin, Ethereum, Litecoin, and Ripple.
Questions about ...read more
Q3. How to fetch multiple rows dynamically in SSRS,
To fetch multiple rows dynamically in SSRS, use parameters and SQL queries.
Create a parameter to accept multiple values
Use the IN operator in SQL query to fetch multiple rows
Example: SELECT * FROM table WHERE column IN (@parameter)
Ensure the parameter is set to allow multiple values
Preview the report to test the dynamic fetching
Q4. How to deployed bulk report in ssrs
Bulk reports in SSRS deployment
Create a data-driven subscription
Use the Report Manager to upload and deploy the report
Use PowerShell scripts to automate the deployment process
Q5. Count the duplicate values in table.
To count duplicate values in a table, use the COUNT and GROUP BY functions in SQL.
Write a SQL query that selects the column with the duplicate values.
Use the COUNT function to count the number of times each value appears.
Use the GROUP BY function to group the results by the column with the duplicate values.
Filter the results to only show values with a count greater than 1.
Alternatively, use Excel's COUNTIF function to count duplicate values in a table.
Q6. Difference between auto transformer and Normal transformer?
Auto transformer has a single winding with a common portion while normal transformer has two separate windings.
Auto transformer has a single winding with a common portion for both input and output voltage
Normal transformer has two separate windings for input and output voltage
Auto transformer is smaller in size and lighter in weight compared to normal transformer
Auto transformer is less efficient and has limited isolation compared to normal transformer
Q7. How to optimize query
Optimizing queries involves reducing the time and resources required to retrieve data from a database.
Use indexes to speed up data retrieval
Avoid using SELECT * and instead specify the required columns
Use JOINs instead of subqueries
Avoid using functions in WHERE clauses
Limit the number of rows returned using LIMIT
Use EXPLAIN to analyze query performance
Normalize the database to reduce redundancy
Consider using caching mechanisms
Q8. What is sql queries you did
I have experience writing SQL queries for data retrieval, manipulation, and analysis.
Used SELECT, INSERT, UPDATE, and DELETE statements to retrieve and modify data
Utilized JOINs to combine data from multiple tables
Used WHERE clause to filter data based on specific conditions
Used GROUP BY and HAVING clauses for data aggregation and filtering
Used ORDER BY clause to sort data in ascending or descending order
Q9. 2nd highest salary in sql
To find 2nd highest salary in SQL, use the ORDER BY and LIMIT clauses.
Use ORDER BY to sort the salaries in descending order
Use LIMIT to select the second highest salary
Example: SELECT salary FROM employees ORDER BY salary DESC LIMIT 1,1
Q10. What are Interest rate swap?
Interest rate swaps are financial derivatives where two parties exchange interest rate cash flows, often to manage interest rate risk.
Interest rate swaps involve two parties exchanging interest rate payments based on a notional principal amount.
One party pays a fixed interest rate while the other pays a floating interest rate, typically based on a benchmark rate like LIBOR.
The purpose of interest rate swaps is to hedge against interest rate fluctuations or to take advantage o...read more
Q11. Trade life cycle in OTC derivatives
The trade life cycle in OTC derivatives involves several stages from trade initiation to settlement.
Trade initiation: Counterparties agree on terms and execute the trade.
Confirmation: Parties confirm the trade details to ensure accuracy.
Valuation: Mark-to-market valuation of the trade is performed regularly.
Margining: Margin calls may be made to cover potential losses.
Settlement: Cash flows are exchanged on agreed-upon dates.
Risk management: Monitoring and managing risks asso...read more
Q12. Tell me about derivatives
Derivatives are financial instruments whose value is derived from an underlying asset or group of assets.
Derivatives can be used for hedging, speculation, or arbitrage
Common types of derivatives include options, futures, forwards, and swaps
Derivatives allow investors to take on leverage and potentially amplify returns
Derivatives markets are often used by institutional investors and traders
Q13. Difference between drop delete truncate
Drop, delete, and truncate are SQL commands used to remove data from a database table, but they differ in their functionality and impact.
DROP: Removes an entire table from the database along with all its data and structure.
DELETE: Removes specific rows from a table based on a condition, but keeps the table structure intact.
TRUNCATE: Removes all rows from a table, but keeps the table structure intact and resets auto-increment values.
Example: DROP TABLE employees; DELETE FROM e...read more
Q14. What are derivatives
Derivatives are financial instruments whose value is derived from an underlying asset or group of assets.
Derivatives can be used for hedging, speculation, or arbitrage.
Common types of derivatives include options, futures, forwards, and swaps.
Derivatives allow investors to take positions on the price movements of assets without owning the assets themselves.
They can be traded on exchanges or over-the-counter (OTC) markets.
Q15. Explain Relays?
Relays are electrically operated switches used to control high power circuits with low power signals.
Relays consist of a coil, an armature, and contacts.
When current flows through the coil, it creates a magnetic field that moves the armature to open or close the contacts.
Relays are commonly used in automotive, industrial, and household applications.
Examples include controlling the starting motor in a car, turning on/off lights in a building, and managing heating elements in a...read more
Top HR Questions asked in Vstretch Imageworks
Interview Process at Vstretch Imageworks
Reviews
Interviews
Salaries
Users/Month