Mastering Access SQL Queries

Mastering Access SQL Queries

12th Grade

5 Qs

quiz-placeholder

Similar activities

Dependency Functions Quiz

Dependency Functions Quiz

12th Grade

10 Qs

2º Quiz de Login em HTML e CSS

2º Quiz de Login em HTML e CSS

12th Grade

10 Qs

Diagnostik awal ASJ

Diagnostik awal ASJ

9th - 12th Grade

10 Qs

ICT in Business & Employment Quiz

ICT in Business & Employment Quiz

12th Grade - University

10 Qs

Teknik Pencarian Mesin Pencari

Teknik Pencarian Mesin Pencari

12th Grade

10 Qs

Quiz về HTML và CSS

Quiz về HTML và CSS

12th Grade

10 Qs

Agile Project Management

Agile Project Management

12th Grade

5 Qs

Qualities of Successful Entrepreneurs

Qualities of Successful Entrepreneurs

7th Grade - University

10 Qs

Mastering Access SQL Queries

Mastering Access SQL Queries

Assessment

Quiz

Information Technology (IT)

12th Grade

Medium

Created by

Clinton Lough

Used 1+ times

FREE Resource

5 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which SQL statement would you use in Microsoft Access to display all columns from a table named `Students`?

SELECT * OF Students;

SELECT * FROM Students;

SHOW ALL FROM Students;

DISPLAY * FROM Students;

2.

OPEN ENDED QUESTION

3 mins • 1 pt

Fill in the blank: Write the SQL query to select only the `FirstName` and `LastName` columns from the `Teachers` table.

Evaluate responses using AI:

OFF

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which SQL statement would you use to join the `Orders` table and the `Customers` table on the `CustomerID` field?

SELECT * FROM Orders JOIN Customers ON Orders.CustomerID = Customers.CustomerID;

SELECT * FROM Orders, Customers WHERE Orders.CustomerID = Customers.CustomerID;

SELECT * FROM Orders INNER JOIN Customers ON Orders.CustomerID = Customers.CustomerID;

SELECT * FROM Orders OUTER JOIN Customers ON Orders.CustomerID = Customers.CustomerID;

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

If you want to display all records from the `Employees` table, even if there is no matching record in the `Departments` table, which join should you use?

INNER JOIN

LEFT JOIN

RIGHT JOIN

CROSS JOIN

5.

OPEN ENDED QUESTION

3 mins • 1 pt

Fill in the blank: Write the SQL query to list all books along with their author's name, assuming `Books.AuthorID = Authors.AuthorID`.

Evaluate responses using AI:

OFF