Quiz: MidTerm Exam

Flag question: Question 1

What property describes a database? Select all the property(ies) that apply.

Group of answer choices

Any collection of data is a database

A database is designed, built, and populated with data for a specific purpose.

A database is a spreadsheet

A logically coherent collection of data with some inherent meaning.

Flag question: Question 2

Basic Terminology: Match the word with a definition.

Group of answer choices

Schema

Relational Instance

Tuple

Attribute

Relation

Flag question: Question 3

Match the definition of the constraint and its definition

Group of answer choices

Domain Constraint

Key Constraint

Entity Integrity Constraint

Referential Integrity Constraint

Flag question: Question 4

Which of the following set of columns could be used for super keys for the following table. Select all possible choices.

Group of answer choices

Name, Address, Age

Name, Age, GPA

Email, Address, Age

GPA, SSN, Email

Name, SSN, Email

Flag question: Question 5

What would you choose as foreign keys in the following schema. Specify your answers in the form:

TableName(ColumnName) references TableName(ColumnName)

p

Flag question: Question 6

Write the SQL DDL commands to create the tables with all necessary constraints for the following equestrian school database:

The database contains a Horse table, with columns:

ID
RegisteredName

The database contains a Student table, with columns:

ID
FirstName
LastName
PhoneNumber

The database contains an Instructor table,table with columns:

ID
FirstName
LastName
PhoneNumber

and a LessonSchedule table, with columns:

HorseID
StudentID
InstructorID
LessonDateTime

p

Flag question: Question 7

Given the following employee table

employee table

Which employee_id's will appear in the output of

SELECT employee_id FROM employee WHERE dept <> 'Research' AND Salary >= 128000;

Group of answer choices

1001, 1006, 1019,1044, 1067,

1012, 1018, 1028, 1039

1006, 1012, 1018, 1019, 1028, 1039

1006, 1018, 1019, 1039

Flag question: Question 8

If the following query is executed against the table in question 7

SELECT dept, MAX(Salary) FROM employee
GROUP BY dept
HAVING COUNT(name)>2

How many rows will be displayed

Group of answer choices

4

1

2

9

3

Flag question: Question 9

How many rows will be impacted if the following update statement is executed against the employee table of question 7

UPDATE employee
SET salary = 1.05*salary
WHERE dept NOT IN ('Research', 'Legal')

Group of answer choices

6

7

2

4

Flag question: Question 10

Given The following schema for a movie database

Formulate SQL statement to output the following:

List the title of movies released in the year 2023 with the total number of actors featured in that movie, sorted alphabetically by the title of the movie
For each category name list the number of movies released in the year 2023 and the total revenue generated by those movies, sorted alphabetically by category name
List all the actors that acted in movies released in 2022 that featured the actor Tom Cruise
List all the movies that were filmed in more than 3 locations between the years 2010 and 2020.
List all the movies released in 2023 that had a revenue less than the cost, including the amount of loss, sorted by loss largest to smallest.

p

Loading...

MidTerm Exam

Quiz Instructions