SQL - True/False Questions

12 Questions | Total Attempts: 1117

SettingsSettingsSettings
SQL - True/False Questions - Quiz


Questions and Answers
  • 1. 
    It is mandatory to define constraint for each attribute of a table.
    • A. 

      True

    • B. 

      False

  • 2. 
    Each table can contain more than one primary key.
    • A. 

      True

    • B. 

      False

  • 3. 
    SQL Server automatically sets the NOT NULL constraint for all the primary key columns if the NOT NULL constraint is not specified for these columns.
    • A. 

      True

    • B. 

      False

  • 4. 
    Unique constraints ensures that all the values in a column  are distinct/unique.
    • A. 

      True

    • B. 

      False

  • 5. 
    The result of a SELECT statement can contain duplicate rows.  
    • A. 

      True

    • B. 

      False

  • 6. 
    Primary Key does allow the Null Values. where as in Unique key doesn't accept the Null values
    • A. 

      True

    • B. 

      False

  • 7. 
    A NULL value is treated as a blank or  zero.
    • A. 

      True

    • B. 

      False

  • 8. 
    By default, each attribute can take NULL values except for the primary key.
    • A. 

      True

    • B. 

      False

  • 9. 
    A relation may have multiple foreign keys.
    • A. 

      True

    • B. 

      False

  • 10. 
    Each foreign key is defined on a multiple attribute.
    • A. 

      True

    • B. 

      False

  • 11. 
    We can use DROP statement to remove a database or table permanently from the system.
    • A. 

      True

    • B. 

      False

  • 12. 
    We can insert two records with same roll number in a table if roll is assigned as primary key.
    • A. 

      True

    • B. 

      False

Related Topics
Back to Top Back to top