DBMS- Section 6 Lessons 1 & 2 Joins

The _____ join is the ANSI-standard syntax used to generate a Cartesian product.

• NATURAL
• ALL
• FULL
• CROSS

The join column must be included in the select statement when you use the NATURAL JOIN clause.

• True
• False

A NATURAL JOIN is based on:

• Columns with the same name and datatype
• Columns with the same name
• Columns with the same datatype and width
• Tables with the same structure

Table aliases MUST be used with columns referenced in the JOIN USING clause

• True
• False

The following is a valid SQL statement:SELECT e.employee_id, e.last_name, d.location_id, department_idFROM employees e JOIN departments dUSING (department_id);

• True
• False

The keywords JOIN _____ should be used to join tables with the same column names but different datatypes.

• NATURAL ON
• ON
• WHEN
• USING

What is the name of the application that we use to enter SQL code?

• Application Express
• Application Basics
• Application Advancements
• ILearning

What are the two keywords to make a table?

• MY TABLE
• JOIN TABLE
• CREATE TABLE
• MAKE TABLE

All strings (ex. addresses) need to be enclosed in:

• single quotes
• double quotes
• parenthesis
• hashtags

A table must have a primary key

• True
• False