Question 1

When is it necessary to qualify a column name while joining tables in MySQL?

Accepted Answer

A)  It is necessary when the tables have identical column names. 
B)  It is necessary when the tables have different column names. 
C)  It is never necessary when you join tables in MySQL. 
D)  It is necessary every time you join tables in MySQL. 
A)  It is necessary when the tables have identical column names. 
B)  It is necessary when the tables have different column names. 
C)  It is never necessary when you join tables in MySQL. 
D)  It is necessary every time you join tables in MySQL.

Question 2

Which statement about nested queries in SQL is FALSE?

Accepted Answer

A)  In small databases, there is not a significant time difference between nested subqueries and table joins. 
B)  Typically, nested subqueries perform faster than queries that join tables. 
C)  A nested query is a subquery within a subquery. 
D)  Executing each subquery in a nested query produces a temporary table. 
A)  In small databases, there is not a significant time difference between nested subqueries and table joins. 
B)  Typically, nested subqueries perform faster than queries that join tables. 
C)  A nested query is a subquery within a subquery. 
D)  Executing each subquery in a nested query produces a temporary table.

Question 3

There are three set operations: union, intersection, and difference. Define each of these operations. Which are supported by Oracle?

Accepted Answer

The union of two tables creates a tempor

Question 4

You can join tables by using a condition in the _____.

Accepted Answer

A)  FROM clause 
B)  WHERE clause 
C)  SELECT clause 
D)  JOIN clause 
A)  FROM clause 
B)  WHERE clause 
C)  SELECT clause 
D)  JOIN clause

Question 5

The product of two tables is formally called the _____.

Accepted Answer

A)  inner join 
B)  outer join 
C)  SQL product 
D)  Cartesian product 
A)  inner join 
B)  outer join 
C)  SQL product 
D)  Cartesian product

Question 6

When a subquery involves a table listed in the outer query, the subquery is called a(n) _____.

Accepted Answer

A)  inner outer subquery 
B)  correlated subquery 
C)  reverse subquery 
D)  parameter subquery 
A)  inner outer subquery 
B)  correlated subquery 
C)  reverse subquery 
D)  parameter subquery

Question 7

The _____ of two tables is a table containing every row that is in either the first table, the second table, or both tables.

Accepted Answer

A)  intersection 
B)  union 
C)  minus 
D)  difference 
A)  intersection 
B)  union 
C)  minus 
D)  difference

Question 8

When tables are listed in the FROM clause of an SQL query, you can give them alternate names, also known as _____.

Accepted Answer

A)  sets 
B)  qualifiers 
C)  groups 
D)  aliases 
A)  sets 
B)  qualifiers 
C)  groups 
D)  aliases

Question 9

When a query includes the clause FROM CLIENT A, CLIENT B, SQL will _____.

Accepted Answer

A)  perform an inner join 
B)  perform an outer join 
C)  treat it as a query of two tables, A and B 
D)  treat it as a union of two tables, A and B 
A)  perform an inner join 
B)  perform an outer join 
C)  treat it as a query of two tables, A and B 
D)  treat it as a union of two tables, A and B

Question 10

Describe the types of outer joins.

Accepted Answer

There are actually three types of outer

Question 11

Suppose you have an ADDRESS_BOOK table containing the first and last names, addresses, and birthdays of many people you know. How can you write a query to display the names of pairs of your acquaintances who have the same birthday?

Accepted Answer

A)  create a new set using ADDRESS_BOOK 
B)  perform an outer join on ADDRESS_BOOK 
C)  self-join ADDRESS_BOOK to itself 
D)  create a second BIRTHDAY table 
A)  create a new set using ADDRESS_BOOK 
B)  perform an outer join on ADDRESS_BOOK 
C)  self-join ADDRESS_BOOK to itself 
D)  create a second BIRTHDAY table

Question 12

A condition is true if it satisfies any value (one or more) produced by a subquery that is preceded by the _____.

Accepted Answer

A)  IS SOME operator 
B)  ALL operator 
C)  SOME operator 
D)  ANY operator 
A)  IS SOME operator 
B)  ALL operator 
C)  SOME operator 
D)  ANY operator

Question 13

In which type of join will all rows from the table listed second in the query be included regardless of whether they match rows from the table listed first in the query?

Accepted Answer

A)  left inner join 
B)  left outer join 
C)  right outer join 
D)  right inner join 
A)  left inner join 
B)  left outer join 
C)  right outer join 
D)  right inner join

Question 14

One use case for an alias is a query that joins a table to itself, known as a(n) _____.

Accepted Answer

A)  inner join 
B)  outer join 
C)  union 
D)  self-join 
A)  inner join 
B)  outer join 
C)  union 
D)  self-join

When is it necessary to qualify a column name while joining tables in MySQL?

Which statement about nested queries in SQL is FALSE?

There are three set operations: union, intersection, and difference. Define each of these operations. Which are supported by Oracle?

You can join tables by using a condition in the _____.

The product of two tables is formally called the _____.

When a subquery involves a table listed in the outer query, the subquery is called a(n) _____.

The _____ of two tables is a table containing every row that is in either the first table, the second table, or both tables.

When tables are listed in the FROM clause of an SQL query, you can give them alternate names, also known as _____.

When a query includes the clause FROM CLIENT A, CLIENT B, SQL will _____.

Describe the types of outer joins.

Suppose you have an ADDRESS_BOOK table containing the first and last names, addresses, and birthdays of many people you know. How can you write a query to display the names of pairs of your acquaintances who have the same birthday?

A condition is true if it satisfies any value (one or more) produced by a subquery that is preceded by the _____.

In which type of join will all rows from the table listed second in the query be included regardless of whether they match rows from the table listed first in the query?

One use case for an alias is a query that joins a table to itself, known as a(n) _____.

Introduction to Kimtay Pet Supplies and Staywell Student Accommodation Databases

Database Design Fundamentals

Creating Tables

Single Table Queries

Updating Data

Database Administration

Functions Procedures and Triggers

Filters

Exam 5: Multiple Table Queries

When is it necessary to qualify a column name while joining tables in MySQL?

Which statement about nested queries in SQL is FALSE?

There are three set operations: union, intersection, and difference. Define each of these operations. Which are supported by Oracle?

You can join tables by using a condition in the _____.

The product of two tables is formally called the _____.

When a subquery involves a table listed in the outer query, the subquery is called a(n) _____.

The _____ of two tables is a table containing every row that is in either the first table, the second table, or both tables.

When tables are listed in the FROM clause of an SQL query, you can give them alternate names, also known as _____.

When a query includes the clause FROM CLIENT A, CLIENT B, SQL will _____.

Describe the types of outer joins.

Suppose you have an ADDRESS_BOOK table containing the first and last names, addresses, and birthdays of many people you know. How can you write a query to display the names of pairs of your acquaintances who have the same birthday?

A condition is true if it satisfies any value (one or more) produced by a subquery that is preceded by the _____.

In which type of join will all rows from the table listed second in the query be included regardless of whether they match rows from the table listed first in the query?

One use case for an alias is a query that joins a table to itself, known as a(n) _____.

Introduction to Kimtay Pet Supplies and Staywell Student Accommodation Databases

Database Design Fundamentals

Creating Tables

Single Table Queries

Updating Data

Database Administration

Functions Procedures and Triggers

Filters