JotForm e-Skills Assessment: C#.NET

JotForm e-Skills Assessment: SQL Server - Intermediate

20 Questions - Level: Intermediate
Name

First NameLast Name
Email
example@example.com
SQL SERVER TECHNICAL ASSESSMENT

20 QUESTIONS - 30 MINUTES
1. How do you select all the rows of a table?
2. How do you count the number of rows in a table?
3. What command will run a stored procedure or function in T-SQL?
4. What does the Try-Catch do in T-SQL?
5. What does WAITFOR do in T-SQL?
6. Which is a null value?
7. In T-SQL, what is the difference between Truncate and Delete?
8. What is the SQL command for sorting results from a SELECT query?
9. What is one of the differences between an INNER join and an OUTER join?
10. A Join that returns all records where the first table is combined with each row from the second table is called what? ?
11. In T-SQL, what characters can be used as a wildcard character in conjunction with the LIKE command to represent a single character? (select 1-4 answers)
12. in T-SQL What is used to return the error message of the last T-SQL statement executed?
13. What is database normalization?
14. Which of the following is true concerning a procedure?
15. A CASE SQL statement is which of the following?
16. Which of the following is true concerning triggers?
17. The command used to return only unique values from a table in a Select statement is?
18. What does ETL stand for in a data warehouse process?
19. To put a new row of data into a table, what statement would you use?
20. The process for sharing/distributing data between different databases and synchronizing between those databases is called?
Click on Submit Button below once you have completed all questions.
Should be Empty:

JotForm e-Skills Assessment: SQL Server - Intermediate