Microsoft SQL Server Test! Trivia Quiz

10 Questions | Total Attempts: 112

SettingsSettingsSettings
Please wait...
Microsoft SQL Server Test! Trivia Quiz

Microsoft SQL server test trivia quiz! This database server was made to store and retrieve data needed for other applications to work. This system has a management system which a lot of companies make use for. The Oracle 12c is considered the most popular of SQL databases. Do take up this quiz and get to see how well you understand the SQL server and how it functions. All the best!


Related Topics
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