Activity#2 - IT Software Solutions for Business

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

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

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

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

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

• PRIMARY KEY

• FOREIGN KEY

• UNIQUE

• INDEX

Which SQL constraint is used to link two tables together?

• PRIMARY KEY

• FOREIGN KEY

• UNIQUE

• CHECK

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

• UNIQUE

• NOT NULL

• DEFAULT

• PRIMARY KEY

Which constraint ensures that a column cannot have a NULL value?

• NOT NULL

• UNIQUE

• CHECK

• FOREIGN KEY

Which SQL command is used to delete all records from a table without deleting the table itself?

• TRUNCATE

• DELETE

• DROP

• ALTER

Which SQL command is used to delete specific records from a table?

• TRUNCATE

• DELETE

• DROP

• REMOVE