Intelligent SQL Subjective Assessment Test

10 Questions | Total Attempts: 277

SettingsSettingsSettings
Intelligent SQL Subjective Assessment Test - Quiz

Here we 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! Please make sure to read all the questions very carefully before attempting. All the questions carry one mark. You are expected to attempt all the questions in the quiz. Your final scores will be given once the quiz is completed. There is no time bar on the quiz. Hope you learn and have fun with the quiz. All the very best!


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
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.