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
A. Select * from tablenameB. Select allrows from tablenameC. Select tablenameD. Show * from tablenameE. Show tablename allrows
A. Select * from tablenameB. Select count(*) from tablenameC. Select count tablenameD. Select tablename (count)
A. StartB. BeginC. RunD. Execute
A. Interface initiationB. Error handlingC. String manipulationD. Data handling
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
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
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
A. SORT (field1, field2, ...)B. ORDER (field1, field2,...)C. SORT BY field1, field2D. ORDER BY field1, field2
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
A. Inner JoinB. Right Outer JoinC. Full Outer JoinD. Cross Join
A. * (asterik)B. % (percent)C. # (pound)D. _ (underline)
A. ERROR_CODEB. #ERRORC. @@RETURNERRORD. @@ERROR
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.
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.
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.
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).
A. UNIQUEB. DISTINCTC. DATAUNIQUED. NAMEDATA
A. Examine, Transfer, LoadB. Extract, Truncate, ListC. Extract, Transer, ListD. Extract, Transform, LoadE. Examine, Terminate, Lead
A. UPDATEB. SELECTC. INPUTD. INSERT
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