Welcome To Datawarehouse World

 7. How do you copy file from one host to other? Many options but you can say by using "scp" command. You can also use rsync command to answer this UNIX interview question or even sftp would be ok. 8. How do you find which process is taking how much CPU? By using "top" command in UNIX, there could be multiple follow-up UNIX command interview questions based upon response of this because “TOP” command has various interactive options to sort result based upon various parameter. 9. How do you check how much space left in current drive ? By using "df" command in UNIX. For example "df -h ." will list how full your current drive is. This is part of anyone day to day activity so I think this Unix Interview question will be to check anyone who claims to working in UNIX but not really working on it. Intermediate UNIX Interview Questions Answers 1. What is the difference between ps -ef and ps -auxwww? UNIX interview questions answers, UNIX Linux questionsT...

  How data can be copied from one table to another table? INSERT INTO SELECT This command is used to insert data into a table which is already created. SELECT INTO This command is used to create a new table and its structure and data can be copied from existing table. How to delete duplicate rows in SQL Server? Duplicate rows can be deleted using CTE and ROW NUMER feature of SQL Server. What is an IDENTITY column in insert statements? IDENTITY column is used in table columns to make that column as Auto incremental number or a surrogate key.  What is recursive stored procedure? SQL Server supports recursive stored procedure which calls by itself. Recursive stored procedure can be defined as a method of problem solving wherein the solution is arrived repetitively. It can nest up to 32 levels. CREATE PROCEDURE [dbo].[Fact] ( @Number Integer, @RetVal Integer OUTPUT ) AS DECLARE @In Integer DECLARE @Out Integer IF @Number != 1 BEGIN SELECT @In = @Number – 1 EXEC Fact @In, @Out OUTP...

  What Is SQL Profiler? SQL Profiler is a tool which allows system administrator to monitor events in the SQL server. This is mainly used to capture and save data about each event of a file or a table for analysis. What are the differences between local and global temporary tables? Local temporary tables are visible when there is a connection, and are deleted when the connection is closed. CREATE TABLE #<tablename> Global temporary tables are visible to all users, and are deleted when the connection that created it is closed. CREATE TABLE ##<tablename> 2.2M Top 10 Behavioral Interview Questions and Answers  What is recursive stored procedure? SQL Server supports recursive stored procedure which calls by itself. Recursive stored procedure can be defined as a method of problem solving wherein the solution is arrived repetitively. It can nest up to 32 levels. CREATE PROCEDURE [dbo].[Fact] ( @Number Integer, @RetVal Integer OUTPUT ) AS DECLARE @In Integer DECLARE @Out ...

  Useful & Important Teradata SQL queries: SQL to changing the default Database DATABASE EMP_DATA_BASE; SQL to find Information about a Database HELP DATABASE EMP_DATA_BASE; SQL to get Sample number of rows         SELECT * FROM EMP_TBL SAMPLE 10; SQL to get a sample Percentage of rows SELECT * FROM EMP_TBL SAMPLE .50; SQL to find information about a Table SHOW TABLE EMP_TBL; SQL to Use an Access Locked Table LOCKING ROW FOR ACCESS SELECT * FROM EMP_TBL; SQL Keywords that describe you SELECT DATABASE, USER, SESSION, ACCOUNT, PROFILE, ROLE;" "SELECT DATE, CURRENT_DATE, TIME, CURRENT_TIME, CURRENT_TIMESTAMP; SQL to Use Aggregates functions SELECT TOP 10  STUDENT_NO, FIRST_NAME, LAST_NAME, CLASS_CODE FROM STUDENT_TBL ORDER BY GRADE DESC;" "SELECT DEPT_NO ,MAX(SALARY) AS ""MAXIMUM"" ,MIN(SALARY) AS ""MINIMUM"" ,AVG(SALARY) AS ""AVERAGE"" ,SUM(SALARY) AS ""SUM"" ,COUNT(*) AS ""C...