Intelligent MS SQL Basic Assessment Test

10 Questions

Settings
Please wait...
Assessment Test Quizzes & Trivia

Developed by Microsoft, MS SQL is a relational database management system. Take this short basic assessment test to assess your knowledge of MS SQL.


Questions and Answers
  • 1. 
    What is a database?
    • A. 

      A collection of data

    • B. 

      A collection of structured data

    • C. 

      A collection of similar data

    • D. 

      A large collection of desimilar data

  • 2. 
    Which of these is referred to as a specified number of columns in a table?
    • A. 

      Row

    • B. 

      Records

    • C. 

      Fields

    • D. 

      Data

  • 3. 
    Which of these is a combination of fields which uniquely specify a row?
    • A. 

      Unique key

    • B. 

      Foreign key

    • C. 

      Surrogate key

    • D. 

      Primary key

  • 4. 
    The first normal form (1NF) is used to...
    • A. 

      Remove all duplicate columns

    • B. 

      Remove all duplicate rows

    • C. 

      Remove all duplicate records

    • D. 

      Remove all duplicate files

  • 5. 
    Which of these is a not a type of index?
    • A. 

      Unique index

    • B. 

      Ordinary index

    • C. 

      Clustered index

    • D. 

      Unclustered index

  • 6. 
    How many cluster indexes can be found in a table?
    • A. 

      1

    • B. 

      2

    • C. 

      3

    • D. 

      4

  • 7. 
    A code written to get information back from the database is called...
    • A. 

      Command

    • B. 

      Query

    • C. 

      Question

    • D. 

      SERP

  • 8. 
    What are the types of subquery?
    • A. 

      Correlated and non-correlated

    • B. 

      Query and question

    • C. 

      Regular and irregular

    • D. 

      Centralized and decentralized

  • 9. 
    The Scala user function is primarily used to return _____ from the database.
    • A. 

      Table

    • B. 

      Unit

    • C. 

      Clause

    • D. 

      Row

  • 10. 
    Which of these operators is used to return rows from the first query but not from the second query?
    • A. 

      INTERSECT

    • B. 

      UNION

    • C. 

      MINUS

    • D. 

      MULTIPLE