If you are preparing for a SQL Server Developer or DBA interview as the interviewer or interviewee, todays tip should offer value to you. This tip has interview style questions graded as either easy, moderate or advanced related to T-SQL, the relational engine programming language. Check out the questions and answers to help gauge your skills. Good luck!
TOP 23 SQL INTERVIEW QUESTIONS & ANSWERS! (SQL Interview Tips + How to PASS an SQL interview!)
t sql interview questions
TOP limits the rows returned in a query result set to a specified number of rows or percentage of rows in SQL Server. When TOP is used in combination with the ORDERBY clause, the result set is limited to the first N number of ordered rows. Otherwise, it retrieves the first N number of rows in an undefined order.
“GO” is not a Transact-SQL statement but a batch separator. It is a command identified by the sqlcmd and osql utilities and SQL Server Management Studio Code editor. SQL Server utilities read “GO” as a signal that they should send the current batch of TSQL statements to an instance of SQL Server.
Part #1 – TSQL Interview Questions And Answers (Basic)
Below are the basic interview questions and answers
Answer: T-SQL stands for Transact-Structured Query Language, which is an extension of SQL functionality supported by Microsoft SQL Server and Sybase ASE.
Answer: The difference between T-SQL and SQL is that SQL is a query language to operate on sets, while TSQL is a proprietary procedural language used by MS SQL Server. Also, T-SQL has a different implementation of DELETE and UPDATE than SQL.
Answer: •LEFT(character_expression, integer_expression ) – It returns the left part of a character expression with the specified number of characters. •CHARINDEX( findTextData, text data, [startingPosition] ) – It returns starting position of an expression in a character string, and starting position is optional. •REPLACE( textData, findTextData, replaceWithTextData ) – It replaces a new value for occurrences of text found in the string. •REVERSE( character_expression ) – It returns the reverse of a character expression. •LEN( textData ) – It returns the length of the string, excluding trailing blanks. •LOWER ( character_expression ) – After converting an uppercase character to lowercase, it will return a character expression. •LTRIM( textData) – Leading blanks will be removed. •PATINDEX( findTextData, textData ) – It returns the starting position integer value of text found in the string. •REPLICATE(character_expression, integer_expression ) – It repeats a character expression for a specified number of times. •RTRIM( textData) – Removes trailing blanks. SPACE( number of spaces ) – It repeats the space value specified a number of times. •STUFF( textData, start, length, insert text data ) – It deletes a specified length of characters and inserts another set of characters at a specified starting point. •SUBSTRING( textData, startPosition, length ) – It returns portion of the string. •UPPER( character_expression ) – It returns a character expression with lowercase character to uppercase.
Answer: Yes – There are Six commands available to import data directly into the T-SQL language. These commands include: •BCP •Bulk Insert •OpenRowSet •OPENDATASOURCE •OPENQUERY •Linked Servers
Answer: ‘GO’ is not a Transact-SQL statement but a batch separator. It is a command identified by the sqlcmd and osql utilities and SQL Server Management Studio Code editor. SQL Server utilities read “GO” as a signal that they should send the current batch of TSQL statements to an instance of SQL Server.
Answer: With the use of the DELETE and TRUNCATE command, all data will be lost in a table. The difference between the DELETE statement and TRUNCATE statement is that, •DELETE is used for conditional removal of data records from Tables. These operations are logged. •TRUNCATE is used for the unconditional removal of data records from Tables. Truncate operations are not logged.
t sql interview questions
T-SQL is the transact sql used by MS SQL Server. It is an extension to the SQL developed by Sybase. It is different from generic SQL which is used by Oracle. It functions similar to sql like connecting with database and executing the statements to add, delete and update the databases. Database developers use this language to interact with DB. Having experienced in sql is very helpful in giving preference to you. There are number of positions available across all the locations. Wisdomjobs focus on providing interview questions and answers to help you in clearing the interview with ease. T-SQL interview questions and answers are useful to attend job interviews and get shortlisted for job position. Check out interview questions page to get more information.