Intelligent SQL Subjective Assessment Test

10 Questions | Total Attempts: 190

SettingsSettingsSettings
Please wait...
Intelligent SQL Subjective Assessment Test

Here you are with an intelligent SQL subjective assessment test to help evaluate your knowledge and skills of SQL using a descriptive approach. Let's see what you got!


Questions and Answers
  • 1. 
    SQL stands for__
    • A. 

      Structured query language

    • B. 

      Software query language

    • C. 

      Structured questionnaire language

    • D. 

      Standard query language

  • 2. 
    Which of these stores and manages SQL triggers? 
    • A. 

      Tables

    • B. 

      Scala

    • C. 

      Groovy

    • D. 

      DMBS

  • 3. 
    Data which are updated in a view are__ in a table
    • A. 

      Cleaned

    • B. 

      Deleted

    • C. 

      Removed

    • D. 

      Updated

  • 4. 
    Which of the following is not true? 
    • A. 

      The result of using a view are permanently stored in the database

    • B. 

      Views are created by standard T-SQL select command

    • C. 

      The result of using a view are not permanently stored in the database

    • D. 

      Views can be used for deleting rows

  • 5. 
    Which of these is a physical structure containing pointers to a data? 
    • A. 

      Insert

    • B. 

      Views 

    • C. 

      Index

    • D. 

      Table

  • 6. 
    What are the two parts of SQL? 
    • A. 

      DML and DMBS

    • B. 

      DMBS and DDL

    • C. 

      DDL and DML

    • D. 

      DML and JAVA

  • 7. 
    Why is truncate faster than delete in SQL? Because 
    • A. 

      It deletes only from the database

    • B. 

      It changes data instead of deleting them

    • C. 

      It writes the deleted records into rollback

    • D. 

      It moves data out of the database instead of deleting them

  • 8. 
     All of these are queries and commands on the DML part of SQL except__
    • A. 

      Select

    • B. 

      Update 

    • C. 

      Drop table

    • D. 

      Delete

  • 9. 
    In what objects are the data stored in RDBMS? 
    • A. 

      Columns

    • B. 

      Tables

    • C. 

      Views

    • D. 

      Doc

  • 10. 
    What processe is used optimize databases to remove potential for redundancy? 
    • A. 

      Nomination

    • B. 

      Normalization

    • C. 

      Nomination

    • D. 

      Notifystack

Related Topics
Back to Top Back to top