Search Header Logo

Activity#2 - IT Software Solutions for Business

Authored by Dima Zoaiter

Computers

11th Grade

Used 1+ times

Activity#2 - IT Software Solutions for Business
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

15 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What type of join returns all rows when there is a match in either of the tables?

INNER JOIN

LEFT JOIN

FULL OUTER JOIN

RIGHT JOIN

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does an INNER JOIN do in SQL?

Returns all rows from both tables

Returns rows where there is a match in both tables

Returns rows from the left table

Returns rows from the right table

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which join will return all the rows from the left table and matching rows from the right table?

INNER JOIN

LEFT JOIN

RIGHT JOIN

FULL OUTER JOIN

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which SQL statement will return all the rows from both tables, along with NULLs for non-matching rows from the left or right table?

LEFT JOIN

RIGHT JOIN

FULL OUTER JOIN

INNER JOIN

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which SQL keyword is used to define a unique value for each record in a table?

PRIMARY KEY

FOREIGN KEY

UNIQUE

INDEX

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which SQL constraint is used to link two tables together?

PRIMARY KEY

FOREIGN KEY

UNIQUE

CHECK

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What SQL constraint ensures that all values in a column are different?

UNIQUE

NOT NULL

DEFAULT

PRIMARY KEY

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?

Discover more resources for Computers