Advertisement
Advertisement
Advertisement

T SQL Quizzes & Trivia

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

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: 1555   |  Last updated: Nov 10, 2020
  • 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;

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: 208   |  Last updated: Feb 6, 2018
  • Sample Question
    You can fetch only one row at a time.


Questions: 26  |  Attempts: 63   |  Last updated: Jan 24, 2013
  • 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.
Advertisement

Advertisement