T SQL Quizzes, Questions & Answers
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: 2726 | Last updated: Apr 28, 2024
-
Sample QuestionWhat 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: 298 | Last updated: Mar 20, 2023
-
Sample QuestionYou can fetch only one row at a time.
Popular Topics
Recent Quizzes
This introductory quiz on T-SQL and SQL queries tests knowledge of data insertion, date formats, and query execution in SQL Server Management Studio. It assesses understanding of case sensitivity in queries and the use of SQL...
Questions: 26 | Attempts: 243 | Last updated: Mar 20, 2023
-
Sample QuestionT-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