SQL SERVER 2020 QUESTIONS

  1. (SQL SERVER): What is the difference between NULL and blank?
    • NULL has no bounds, it can be used for string , integer , date , etc. fields in a database.
    • NULL isn't allocated any memory.

    Empty
    IS allocated to a memory location; although the  value stored in the memory is"".
  2. (SQL SERVER): What is a default value in sql?
    The DEFAULT keyword provides a default value to a column when the SQL Server INSERT INTO statement does not provide a specific value.

    • Image Upload 1
    • Insert:
    • Image Upload 2
  3. (SQL SERVER): What  Arithmetic Operators opperators are available in SQL SERVER?
    • + (Add)       Addition
    • - (Subtract)  Subtraction
    • * (Multiply)  Multiplication
    • / (Divide)    Division% (Modulo)
  4. (SQL SERVER): (DEF'N): What are arithmetic operators?
    Arithmetic operators run mathematical operations on two expressions of one or more data types. They're run from the numeric data type category.
  5. (SQL SERVER): (True/False) : The plus (+) and minus (-) operators can also be used to run arithmetic operations on datetime and smalldatetime values.
    TRUE.
  6. (SQL SERVER): What is the difference between global temporary tables and local temporary tables?
    Local temporary tables are visible only in the current session, while global temporary tables are visible to all sessions.
  7. (SQL SERVER): What is normalization in database terms?
    The process of organizing data to minimize redundancy. It usually involves dividing a database into two or more tables and defining relationships between the tables. ... For example, in an employee list, each table would contain only one birthdate field.
Author
geschw66
ID
350421
Card Set
SQL SERVER 2020 QUESTIONS
Description
questions that came up in Spectrum interview.
Updated