SQL And Database Quiz

8 Questions | Total Attempts: 321

SettingsSettingsSettings
Please wait...
SQL Quizzes & Trivia

Questions and Answers
  • 1. 
    How do you create a database? Which command is correct?
    • A. 

      Create database ;

    • B. 

      Create database NAME;

  • 2. 
    What are databases generally used for? Which is correct?
    • A. 

      The storage of data for business/schools or universities

    • B. 

      Manage your shopping

  • 3. 
    What would the statement 'Select * from Student;' do?
    • A. 

      Select some data from the student table

    • B. 

      Select all of the data from the student table

  • 4. 
    Why are WHERE statements useful in SQL?
    • A. 

      They let the user only see where their data is in the database

    • B. 

      They allow the user to select what they want to see from a criteria in the WHERE statement

  • 5. 
    Fill in the blank: Select StudentID, StudentName, StudentCourseNo [Blank] Student?
  • 6. 
    Advanced question: Why would you use a JOIN in a SQL statement?
    • A. 

      To join multiple tables together in a statement

    • B. 

      To have all the tables joined together in a statement

  • 7. 
    Advanced Question: From the list below, select the correct DMBS's
    • A. 

      Oracle

    • B. 

      MIcrosoft SQL

    • C. 

      Potatoe

    • D. 

      MYSQL

Related Topics
Back to Top Back to top