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?

A. Select * from tablenameB. Select allrows from tablenameC. Select tablenameD. Show * from tablenameE. Show tablename allrows
2. How do you count the number of rows in a table?

A. Select * from tablenameB. Select count(*) from tablenameC. Select count tablenameD. Select tablename (count)
3. What command will run a stored procedure or function in T-SQL?

A. StartB. BeginC. RunD. Execute
4. What does the Try-Catch do in T-SQL?

A. Interface initiationB. Error handlingC. String manipulationD. Data handling
5. What does WAITFOR do in T-SQL?

A. Skips the next statement based on conditionsB. Sets a specific period of time that must pass before execution of a batch, stored procedure, or transaction proceeds.C. Halts for error handlingD. Reverses any updates to the database
6. Which is a null value?

A. A value that is over the maximum value allowed for the field typeB. A value equal to zeroC. A value equal to 32767D. A value that was not set upon creation of the table
7. In T-SQL, what is the difference between Truncate and Delete?

A. Truncate is faster but does not log as much information. Delete logs all removed rows making it slower but recovery is easierB. Delete is faster but does not log as much information. Truncate logs all removed rows making it slower but recovery is easierC. They do the exact same thingD. Truncate will shorten the length of records. Delete will Delete the entire record
8. What is the SQL command for sorting results from a SELECT query?

A. SORT (field1, field2, ...)B. ORDER (field1, field2,...)C. SORT BY field1, field2D. ORDER BY field1, field2
9. What is one of the differences between an INNER join and an OUTER join?

A. Inner join returns all rows where there is a match in both tables. Outer join returns all the rows from one table and the matched rows from the other tableB Inner join returns all rows from both tables and outer join only returns rows from one tableC. Inner join returns only the fields, but no data. Outer join returns data.D. Outer join returns all rows where there is a match in both tables. Inner join returns all the rows from one table and the matched rows from the other table
10. A Join that returns all records where the first table is combined with each row from the second table is called what? ?

A. Inner JoinB. Right Outer JoinC. Full Outer JoinD. Cross Join
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)

A. * (asterik)B. % (percent)C. # (pound)D. _ (underline)
12. in T-SQL What is used to return the error message of the last T-SQL statement executed?

A. ERROR_CODEB. #ERRORC. @@RETURNERRORD. @@ERROR
13. What is database normalization?

A. Eliminating data that has not been used or accessed in a long time.B. Determining what table structures are too large for disk space.C. The process of efficiently organizing data to reduce redundancy and improve data integrity.D. The process of moving one database to a different server or platform.
14. Which of the following is true concerning a procedure?

A. You do not create them with SQL.B. They do not need to have a unique name.C. They include procedural and SQL statements.D. They are the same thing as a function.
15. A CASE SQL statement is which of the following?

A. A way to establish an IF-THEN-ELSE in SQL.B. A way to establish a loop in SQL.C. A way to establish a data definition in SQL.D. All of the above.
16. Which of the following is true concerning triggers?

A. You do not create them with SQL.B. They execute against only some applications that access a database.C. They have an event, condition, and action.D. They cannot cascade (cause another trigger to fire).
17. The command used to return only unique values from a table in a Select statement is?

A. UNIQUEB. DISTINCTC. DATAUNIQUED. NAMEDATA
18. What does ETL stand for in a data warehouse process?

A. Examine, Transfer, LoadB. Extract, Truncate, ListC. Extract, Transer, ListD. Extract, Transform, LoadE. Examine, Terminate, Lead
19. To put a new row of data into a table, what statement would you use?

A. UPDATEB. SELECTC. INPUTD. INSERT
20. The process for sharing/distributing data between different databases and synchronizing between those databases is called?

A. ReplicationB. StandarizationC. NormalizationD. Referential Integrity
Click on Submit Button below once you have completed all questions.
Should be Empty:

JotForm e-Skills Assessment: SQL Server - Intermediate