UST Interview Questions, Process, and Tips

Q1. Explain about your college life
Add your answer

Q1. About 4g network
Add your answer
Q2. Self intro in brief
Add your answer

Q1. How to use pivot in SQL server
Ans. 
Pivot in SQL server is used to transform rows into columns, based on a specified column value.
• Pivot is used to rotate rows into columns

• It requires an aggregate function to be applied on the values being pivoted

• The PIVOT operator is used in conjunction with the SELECT statement

• The PIVOT operator requires a unique identifier column and one or more columns to pivot

• The PIVOT operator can be used to perform dynamic pivoting
Answered by AI
Add your answer
Q2. Two files have different sets of columns in a file how to manage this in ssis
Ans. 
In SSIS, you can manage different sets of columns in two files by using conditional splits and dynamic column mapping.
• Use a conditional split transformation to separate the data flow based on the file type or column presence

• Create separate data flows for each file type and handle the columns accordingly

• Use dynamic column mapping to map the columns dynamically based on the file type

• You can use expressions and variables ...read more
Answered by AI
Add your answer

React with typescript and 5 questions are there very medium based but if we have to complete 1 by 1 and pass all test cases then only other questions will appear

Q1. Not qualified for the first round so don't know
Add your answer

Q1. What is assertion
Ans. 
Assertion is a validation point in automated testing to verify expected outcomes against actual outcomes.
• Assertion is used to validate whether a certain condition is true or false in the test script.

• It helps in determining the pass or fail status of a test case.

• Common assertion methods include assertEqual, assertTrue, assertFalse, etc.

• Example: Assert.assertEquals(expectedResult, actualResult);
Answered by AI
Add your answer

Q1. Oops Sql Java
Add your answer