Valley Infosystems Interview Questions and Answers

Completley based on plsql and problem solving

Q1. How to get comma seperated values in field
Ans. 
Use string join method to concatenate array elements with comma
• Use the join method to concatenate array elements with a comma separator

• Example: let arr = ['apple', 'banana', 'orange']; let csv = arr.join(','); // 'apple,banana,orange'
Answered by AI
Add your answer
Q2. About project and your contribution and improvement
Add your answer
Q3. Using listaggregate orDBMS package or pipeline function
Add your answer
Q4. Improved performance by materialized views and used key words in queries
Ans. 
Materialized views and key words in queries can improve performance by reducing the need for expensive joins and aggregations.
• Materialized views store the results of a query and can be used to avoid expensive calculations when querying the data.

• Using key words in queries can help optimize the search process by narrowing down the results based on specific criteria.

• Examples: Creating a materialized view for frequently ac...read more
Answered by AI
Add your answer

Python, sql, Pyspark questions

Q1. Pyspark, aws, python, sql questions
Add your answer