SQL

A vibrant illustration showcasing a computer screen displaying SQL code, alongside database icons and a graduation cap symbolizing learning and knowledge.

Master SQL: Test Your Knowledge!

Welcome to the SQL Quiz! This engaging quiz will challenge your understanding of SQL (Structured Query Language) and its applications in database management. Whether you are a beginner or an expert, this quiz is designed to enhance your SQL skills.

Key features of the quiz include:

11 challenging questions
Multiple choice, checkboxes, and text responses
Real-world scenarios to test your knowledge

11 Questions3 MinutesCreated by QueryMaster247

What does SQL stand for?

Structured Query Language

Sequential Query Language

Stratified Query Language

Structured Query Lab

Who developed SEQUEL?

Google

Microsoft

IBM

Oracle

What type of data is SQL intended to operate on?

Tables

Documents

Pictures

None of the above

Which of the following is not a valid SQL command?

SELECT

INSERT

CREATE

FORM

Fill in the blank to pick/ display all contents of the Frontline table. SELECT __ FROM Frontline.

All

Which command allows you to control the number of output rows?

STOP

LIMIT

CHECK

END

The Employee table, hosted in AWS, stores Name, EmpId, Team, Location information. You need to export all information of employees based in Brisbane. Choose the correct statement(s).

Select * from Employee where Location='Brisbane'

Select Employee from Brisbane

Select * from employees where location == Brisbane

Select Name where Location="Brisbane" from Employee

Select * from Employee where Location like 'Brisbane'

Select * where Location like "Brisbane" from Employee

Consider 2 tables A & B. Which operator(s) allows you to pick only the matching rows between the tables?

Intersect

And

Inner join

Which of these is not a database service offered by popular public CSPs - Amazon/Microsoft/Google ?

Azure CosmosDB

Amazon Redshift

Google Cloud Spanner

Amazon Firehose

Which of these libraries allows you to interact with databases using python? Select all that apply.

Sqlite

Pyodbc

Boto3

Sqlalchemy

Any words of encouragement/ advise for Rithvik who's leaving us next week?

Master SQL: Test Your Knowledge!

More Quizzes