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 Quizzes


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: 2312   |  Last updated: Mar 21, 2022
  • 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;
    Radio Button
    Radio Button
    Radio Button
    Radio Button


Questions: 26  |  Attempts: 233   |  Last updated: Mar 20, 2022
  • 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.
    Radio Button
    Radio Button

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: 260   |  Last updated: Mar 20, 2022
  • Sample Question
    You can fetch only one row at a time.
    Radio Button
    Radio Button

Recent Quizzes

Advertisement
Advertisement