NSE.IT Interview Questions, Process, and Tips

Q1. How would you shows any aggregation on whole data row by row in SQL. Example if I want total sales as a new column in existing table as a result.
Ans. 
To show aggregation on whole data row by row in SQL, you can use the OVER() function with appropriate window specification.
• Use the OVER() function to perform aggregation on the entire data set

• Specify the window specification to define the scope of aggregation

• Add the aggregated result as a new column in the existing table

• Example: SELECT *, SUM(sales) OVER() AS total_sales FROM table_name
Answered by AI
View 1 more answer
Q2. Difference between functions and store procedures?
Ans. 
Functions return a single value while stored procedures execute a set of SQL statements.
• Functions are used to perform calculations and return a single value while stored procedures are used to execute a set of SQL statements.

• Functions can be used in SELECT, WHERE, and HAVING clauses while stored procedures cannot.

• Functions can be called from within stored procedures while stored procedures cannot be called from within ...read more
Answered by AI
Add your answer
Q3. What does All function does in dax?
Ans. 
ALL function in DAX returns all the rows in a table, or all the values in a column, ignoring any filters that might have been applied.
• ALL function can be used to remove filters from a table or column.

• It can also be used to remove filters from a specific column in a table.

• ALL function can be combined with other functions like CALCULATE to perform complex calculations.

• Example: CALCULATE(SUM(Sales[Amount]), ALL(Sales[Prod...read more
Answered by AI
Add your answer

Numerical and logical question

Aptitude text contants basic mathematical and english languages questions

Q1. What is Linux? How it works
Ans. 
Linux is an open-source operating system based on Unix. It is free to use and highly customizable.
• Linux is a kernel that manages hardware resources and provides services to applications

• It is highly customizable and can be modified to suit specific needs

• Linux is open-source, meaning its source code is freely available for anyone to use and modify

• It is widely used in servers, supercomputers, and embedded systems

• Examples ...read more
Answered by AI
Add your answer
Q2. What are the commands used in linux
Ans. 
Linux commands are used to interact with the operating system and perform various tasks.
• ls - list directory contents

• cd - change directory

• mkdir - make directory

• rm - remove file or directory

• cp - copy file or directory

• mv - move or rename file or directory

• grep - search for a pattern in a file

• chmod - change file permissions

• sudo - execute a command as superuser

• apt-get - package manager for Debian-based systems
Answered by AI
Add your answer
Q3. How to copy file in linux
Ans. 
Copying files in Linux involves using the 'cp' command.
• Use the 'cp' command followed by the source file and destination directory to copy a file.

• If you want to keep the same file name, specify the destination directory only.

• To copy a file with a new name, provide the new name as the destination.

• You can also copy multiple files by providing multiple source files and a destination directory.

• Use the '-r' option to copy di
Answered by AI
View 1 more answer

Q1. Technical linux question
Add your answer

Q1. Technical linux questions
Add your answer

Q1. Manager round questions were asked. Are you comfotable working in shifts. How will you handle if you face any issue at midnight?
Add your answer

Q1. Salary negotiation
Add your answer

Q1. One to one and it's good
Add your answer

Q1. One to one with HR and comercial head
Add your answer

Q1. With RM regards process
Add your answer