CST 8215 FINAL EXAM -DATABASE CONCEPTS & PRINCIPLES
03/29/2026
| VERIFIED QUESTIONS & ANSWERS
CST 8215 Final Exam -Database Concepts & Principles | Verified
Questions & Answers 2026/2027, Exams of Nursing
Which of the following queries will list Country Code, Country Name and City Name for each city in the
city table.
a) SELECT Country.Code, Country.Name, City.Name
FROM Country
INNER JOIN City
ON Country.Code = City.CountryCode;
b) SELECT *
FROM Country
INNER JOIN City
ON Country.Name = City.Name;
c) SELECT Country.Code, Country.Name, City.Name
FROM Country
SELF JOIN Country
ON Country.Code = City.CountryCode;
A JOIN operation combines two tables into one on the basis of common values in a common column.
(T/F)
T
3/29/2026
A join operation:
1
, CST 8215 FINAL EXAM -DATABASE CONCEPTS & PRINCIPLES
03/29/2026
| VERIFIED QUESTIONS & ANSWERS
a) causes two tables with a common attribute to be combined into a single table or view
b) causes two tables with a common attribute to be combined into a single table or view, the common
attribute must be a prime key in both tables
c) brings together data from two different fields
d) is used to combine indexing operations
An INNER JOIN operation is performed on two tables.
The common eld that is used for the join operation has a few NULL values in each of the two tables.
The join operation will:
a) not match NULL records from any of the two tables
b) match NULL values from the first table but not from the second table
c) match NULL values from the second table but not from the first table
d) match NULL values from both tables, since it is a JOIN operation
Identify the query that will list countries that have no cities listed in the city table
a) SELECT Country.Code, Country.Name
FROM Country
LEFT JOIN City
ON Country.Code = City.CountryCode
WHERE City.CountryCode IS NULL;
3/29/2026
b) SELECT Country.Code, Country.Name
FROM Country
2
, CST 8215 FINAL EXAM -DATABASE CONCEPTS & PRINCIPLES
03/29/2026
| VERIFIED QUESTIONS & ANSWERS
LEFT JOIN City
ON Country.Code = City.CountryCode
WHERE City.CountryCode IS NOT NULL;
c) SELECT Country.Code, Country.Name
FROM Country
LEFT JOIN City
ON Country.Code = City.CityID
WHERE City.CountryCode IS NULL;
d) SELECT Country.Code, Country.Name
FROM Country
LEFT JOIN City
ON Country.Name = City.CityID
WHERE City.CountryCode IS NULL;
Which query will list countries that do not have a language listed in the CountryLanguage Table
a) SELECT Country.Code, Country.Name, Language
FROM CountryLanguage
RIGHT JOIN Country ON Country.Code = CountryLanguage.CountryCode
WHERE CountryLanguage.CountryCode IS NULL;
b) SELECT Country.Code, Country.Name, Language
FROM CountryLanguage
3/29/2026
RIGHT JOIN Country ON Country.Name = CountryLanguage.CountryLanguage
WHERE CountryLanguage.CountryCode IS NULL;
3
, CST 8215 FINAL EXAM -DATABASE CONCEPTS & PRINCIPLES
03/29/2026
| VERIFIED QUESTIONS & ANSWERS
c) SELECT ALL
FROM CountryLanguage
WHERE CountryLanguage.CountryCode IS NOT IN Country;
An operation to join a table to itself is called a:
a) SELF JOIN
b) INNER JOIN
c) NATURAL JOIN
d) EQUI JOIN
e) OUTER JOIN
Identify the SQL operator that satisfies the following conditions:
1. Combines the result sets of two or more SELECT statements
2. Each SELECT statement must have the same number of columns
3. All columns must have the same data type
4. All columns must be in the same order
5. The result set will display DISTINCT values by default, the ALL keyword is used to display duplicate
values.
a) UNION
b) FULL OUTER JOIN
c) SELF JOIN
3/29/2026
d) NATURAL JOIN
4
03/29/2026
| VERIFIED QUESTIONS & ANSWERS
CST 8215 Final Exam -Database Concepts & Principles | Verified
Questions & Answers 2026/2027, Exams of Nursing
Which of the following queries will list Country Code, Country Name and City Name for each city in the
city table.
a) SELECT Country.Code, Country.Name, City.Name
FROM Country
INNER JOIN City
ON Country.Code = City.CountryCode;
b) SELECT *
FROM Country
INNER JOIN City
ON Country.Name = City.Name;
c) SELECT Country.Code, Country.Name, City.Name
FROM Country
SELF JOIN Country
ON Country.Code = City.CountryCode;
A JOIN operation combines two tables into one on the basis of common values in a common column.
(T/F)
T
3/29/2026
A join operation:
1
, CST 8215 FINAL EXAM -DATABASE CONCEPTS & PRINCIPLES
03/29/2026
| VERIFIED QUESTIONS & ANSWERS
a) causes two tables with a common attribute to be combined into a single table or view
b) causes two tables with a common attribute to be combined into a single table or view, the common
attribute must be a prime key in both tables
c) brings together data from two different fields
d) is used to combine indexing operations
An INNER JOIN operation is performed on two tables.
The common eld that is used for the join operation has a few NULL values in each of the two tables.
The join operation will:
a) not match NULL records from any of the two tables
b) match NULL values from the first table but not from the second table
c) match NULL values from the second table but not from the first table
d) match NULL values from both tables, since it is a JOIN operation
Identify the query that will list countries that have no cities listed in the city table
a) SELECT Country.Code, Country.Name
FROM Country
LEFT JOIN City
ON Country.Code = City.CountryCode
WHERE City.CountryCode IS NULL;
3/29/2026
b) SELECT Country.Code, Country.Name
FROM Country
2
, CST 8215 FINAL EXAM -DATABASE CONCEPTS & PRINCIPLES
03/29/2026
| VERIFIED QUESTIONS & ANSWERS
LEFT JOIN City
ON Country.Code = City.CountryCode
WHERE City.CountryCode IS NOT NULL;
c) SELECT Country.Code, Country.Name
FROM Country
LEFT JOIN City
ON Country.Code = City.CityID
WHERE City.CountryCode IS NULL;
d) SELECT Country.Code, Country.Name
FROM Country
LEFT JOIN City
ON Country.Name = City.CityID
WHERE City.CountryCode IS NULL;
Which query will list countries that do not have a language listed in the CountryLanguage Table
a) SELECT Country.Code, Country.Name, Language
FROM CountryLanguage
RIGHT JOIN Country ON Country.Code = CountryLanguage.CountryCode
WHERE CountryLanguage.CountryCode IS NULL;
b) SELECT Country.Code, Country.Name, Language
FROM CountryLanguage
3/29/2026
RIGHT JOIN Country ON Country.Name = CountryLanguage.CountryLanguage
WHERE CountryLanguage.CountryCode IS NULL;
3
, CST 8215 FINAL EXAM -DATABASE CONCEPTS & PRINCIPLES
03/29/2026
| VERIFIED QUESTIONS & ANSWERS
c) SELECT ALL
FROM CountryLanguage
WHERE CountryLanguage.CountryCode IS NOT IN Country;
An operation to join a table to itself is called a:
a) SELF JOIN
b) INNER JOIN
c) NATURAL JOIN
d) EQUI JOIN
e) OUTER JOIN
Identify the SQL operator that satisfies the following conditions:
1. Combines the result sets of two or more SELECT statements
2. Each SELECT statement must have the same number of columns
3. All columns must have the same data type
4. All columns must be in the same order
5. The result set will display DISTINCT values by default, the ALL keyword is used to display duplicate
values.
a) UNION
b) FULL OUTER JOIN
c) SELF JOIN
3/29/2026
d) NATURAL JOIN
4
