T SQL Quizzes, Questions & Answers

This is not just SQL. This is T-SQL, or Transact-SQL; it doesn’t really matter which form you prefer. If you enjoy programming, then maybe you will also enjoy this trivia and all of the questions within it. The following are just some samples for you to get used to.

Transact-SQL (T-SQL) is Microsoft's and Sybase's proprietary extension to SQL, a standardised computer language that was originally developed by what company? T-SQL expands on the SQL standard to include procedural programming, local variables, various support functions for string processing, data processing, mathematics etc. and changes to what statements? Transact-SQL is central to using what? Do you think these were easy questions? Then you should try out the others that we have in store you.

Top Trending Quizzes

SQL Server T-SQL Quiz-I

If you are a computer nerd that is really into programming then this quiz is specifically for you. It aims to find out how much knowledge you have on the SQL server T-SQL. All the best.

Questions: 10 | Attempts: 2686 | Last updated: Apr 28, 2024

Sample Question
What does the select statement return? Create Table #T ( N1 Real , N2 Float); Insert Into #T Values (99.99999999991 , 99.99999999997); Select * From #T; Drop Table #T;

The select statement returns < 100 for N1 and 100 for N2

The select statement returns 100 for N1 and < 100 for N2

The select statement returns < 100 for both columns

The select statement returns 100 for both columns

Sort Quiz Over SQL And T-SQL

SQL is a language used in programming for managing data held in a relational database management system. T-SQL, on the other hand, is Microsoft's and Sybase's version. How well do you understand these two? Find out...

Questions: 10 | Attempts: 293 | Last updated: Mar 20, 2023

Sample Question
You can fetch only one row at a time.

True

False

T-SQL And General SQL: Unit 1 - Introduction To SQL Queries

Questions: 26 | Attempts: 243 | Last updated: Mar 20, 2023

Sample Question
T-SQL: You have a table with a colum entitled 'job', whose values are all lower case. If you execute the following query: SELECT ename, job, deptno FROM dbo.emp WHERE job = 'CLERK' you will not get any results back buecase the match is case sensitve and so because all values of the 'job' colum are lowercase, uppercase 'CLERK' will not be found.

True

False

T SQL Quizzes, Questions & Answers

Top Trending Quizzes

Popular Topics

Recent Quizzes