SQL Concepts

A vibrant and modern illustration of a computer database with SQL query structures visible, featuring elements like tables, primary keys, foreign keys, and graphical representations of data relationships.

SQL Concepts Quiz

Test your knowledge of SQL with our comprehensive quiz! Whether you're a beginner or looking to refresh your skills, this quiz covers essential SQL concepts.

Understand primary and foreign keys
Identify valid SQL data types and operators
Enhance your SQL querying skills

12 Questions3 MinutesCreated by QueryMaster47

Definition of a Primary Key

A Master Account With Unlimited Access to Data

A Unique Identifier Used To Identify an Entity

A Stored Procedure To Decrypt Sensitive Data

A Backdoor to Access a DataBase

What Will This Statement Return.... "Select * From MyTable Where Myfield Not = 1"?

All the data in all the columns in MyTable

All the data in all the columns from MyTable where MyField does not equal 1

Nothing, will return syntax error

The first 1000 from MyTable where MyField does not equal 1

What is the proper syntax to join all the records in a table, assuming both have a column sharing the same values called OID?

Select Table1.OID, Table1.Col2,Table1.Col3, Table2.OID,Table2.Col1,Table2.Col2,Table3.Col3 inner join on Table1.OID=Table2.OID, DBName.dbo.Table2 from DBName.dbo.Table1

Select Table1.OID, Table1.Col2,Table1.Col3, Table2.OID,Table2.Col1,Table2.Col2,Table3.Col3 on Table1.OID=Table2.OID inner join DBName.dbo.Table2 from DBName.dbo.Table1

Get Table1.OID, Table1.Col2,Table1.Col3, Table2.OID,Table2.Col1,Table2.Col2,Table3.Col3 from DBName.dbo.Table1 inner join on DBName.dbo.Table2 = Table1.OID =Table2.OID

Select Table1.OID, Table1.Col2,Table1.Col3, Table2.OID,Table2.Col1,Table2.Col2,Table3.Col3 from DBName.dbo.Table1 inner join DBName.dbo.Table2 on Table1.OID=Table2.OID

What is a foreign key?

A password from another DB that works in this DB

A vulnerability gleaned from another db

A primary key used as a reference in a different table than the entity it represents

A key defined in another language

What is the number one reason to avoid redundancy or replication in a db?

Integrity, so that one record is represented by one key

To prevent the database from being unnecessarily large

To keep data easily organized

To make data easier to understand

What is the definition of a Subquery?

A query inside of a query

A query that returns a smaller set of data than its parent

A Query that can be substituted for another

A query that pulls from a table deeper in the data structure

Bonus What Question did you find the most difficult?

Definition of a Primary Key

What Does SQL Stand For?