Intelligent MS SQL Advanced Assessment Test

10 Questions

Settings
Please wait...
Intelligent MS SQL Advanced Assessment Test

The Intelligent MS SQL Advanced Assessment Test is a standard test used by employers to evaluate the knowledge of potential advanced employees in the area of Microsoft SQL.


Questions and Answers
  • 1. 
    A topic covered in the test include?
    • A. 

      MS Office

    • B. 

      Stored Procedure

    • C. 

      Work Systems

    • D. 

      Programming

  • 2. 
    According to Microsoft SQL Server, what is the ideal statistics language?
    • A. 

      Wolfram Language

    • B. 

      MATLAB

    • C. 

      R

    • D. 

      Stata

  • 3. 
    What type of join is needed when you wish to include rows that do not have matching values?
    • A. 

      Outer join

    • B. 

      Inner join

    • C. 

      Natural join

    • D. 

      Equal join

  • 4. 
      A CASE SQL statement is used to establish...
    • A. 

      IF-THEN-SAVE

    • B. 

      IF-THEN-DEFINE

    • C. 

      IF-THEN-RUN

    • D. 

      IF-THEN-ELSE

  • 5. 
    Which of the following statements is true concerning routines and triggers?
    • A. 

      Both run alongside codes

    • B. 

      One is an operator

    • C. 

      Both consist of procedural code

    • D. 

      Both run automatically

  • 6. 
    What type of join is needed when you wish to return rows that do have matching values?
    • A. 

      Natural join

    • B. 

      Close out

    • C. 

      Low join

    • D. 

      Open join

  • 7. 
    How many tables may be included with a join?
    • A. 

      3

    • B. 

      10

    • C. 

      12

    • D. 

      15

  • 8. 
    Which of these is a feature of triggers?
    • A. 

      Row

    • B. 

      Potential

    • C. 

      Line

    • D. 

      Action

  • 9. 
    What kind of query uses the result of an outer query to determine the processing of an inner query?
    • A. 

      Correlated subquery

    • B. 

      Inner query

    • C. 

      Random query

    • D. 

      Inner subquery

  • 10. 
    A feature of triggers is...
    • A. 

      Lineup

    • B. 

      Memory

    • C. 

      Condition

    • D. 

      Query