Refer to the exhibit. The exhibit shows the structures of the Drivers and Orders data tables for a pizza delivery service. The same driver may deliver multiple orders on an average day. What type of relationship exists between the Drivers table and the Orders table?

There is a one-to-many relationship between the two tables because one driver may have many orders, but an order can have only one driver.

The two tables have a one-to-one relationship because both have DriverID as the primary key.

There is a many-to-many relationship between the two tables because there are many drivers and many orders in the tables.

There is a one-to-one relationship between the two tables because DriverID is a common identifier for the records in both tables.

Refer to the exhibit. You need to get information about customer purchases that is stored in the two tables. You would like to see data from the OrderID, CustomerName, OrderAmount, and OrderDate columns. To obtain this information, how would you complete the following partial SQL query? SELECT Orders.OrderID, Customers.CustomerName, Orders.OrderAmount, Orders.OrderDate FROM Orders INNER JOIN _______ ON _____________ = _____________;

INNER JOIN Customers ON Orders.CustomerID=Customers.CustomerID;

INNER JOIN Orders ON Orders.OrderID=Orders.CustomerID;

INNER JOIN Customers ON Customer.CustomerID=Customers.CustomerID;

INNER JOIN Orders ON Orders.CustomerID=Customers.CustomerID;

Which JOIN clause would join the two tables Orders and Customers, using the CustomerID field in both tables as the relationship between the two tables? SELECT * FROM Orders LEFT JOIN Customers ON ____________ = ______________;

ON Orders.CustomerID=Customers.CustomerID

ON Customers.CustomerID=Orders.CustomerID

ON Orders.CustomerID=Orders.CustomerID

ON Customers.CustomerID=Customers.CustomerID

What is the function of a foreign key in a relational database table?

to define a relationship with a primary key in a different table

to uniquely identify a row within the table

to create a many-to-one relationship within the table

to add additional unique columns to the data table

Review the columns and descriptions in each table, Movie, and Award . Data from the two tables need to be combined to extract the title and cost of movies that won awards. Can a NATURAL JOIN be used to accomplish the desired result? Movie table: MovieID - primary key Title - name of the movie Date - date the movie was released Cost - total cost of production Award table: AwardID - primary key MovieID - foreign key Category - award category Name - name of the award Date : day the award was received

No, because the Date column contains different data types in each table.

Yes, because both tables have two common columns.

Yes, because both tables have the MovieID column.

No, because an OUTER JOIN should be used to extract all of the information.

What is the result of the query shown in the example? UPDATE Review SET Comment = 'This is the new comment' WHERE MovieId = 3456 AND AuthorName = 'PuzoFan76';

The comment made by PuzoFan76 for the movie with the ID 3456 will be modified to say, “This is a new comment.”

A new comment will be added to the movie with the ID 3456 for the author PuzoFan76.

All of the comments for the movie with the ID 3456 will be modified to say, “This is a new comment.”

A new row will be added to the table Review with the MovieId= 3456 and the AuthorName =PuzoFan76.

What are two types of data that benefit from NoSQL data storage? (Choose two.)

data with flexible formats that can change over time

high volumes of unstructured data

data easily organized in tables of columns and rows

data that conforms to a structured schema

form data requiring input validation

SQL and Database Quiz

Quiz

•

Computers

•

University

•

Practice Problem

•

Medium

John Ulakovich

Used 36+ times

FREE Resource

21 questions

Show all answers

1.

MULTIPLE SELECT QUESTION

1 min • 3 pts

Which three elements of a relational database are defined in the schema? (Choose 3.)

relationships

attributes

tables

SQL keywords

aliases

2.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

In the SQL statement " SELECT genre FROM movies" what is specified by "genre"?

the table

the column

the database

the folder

3.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

What is a flat file database?

a database that stores records in a single file with no hierarchical structure

a database that requires SQL to store, manipulate, and retrieve data

a database that is used to store large amounts of complex data

a database that stores data in a sheet using a hierarchical tabular format of columns and rows

4.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

What is used to show how the tables in a database are related to one another?

ERD

CSV

DML

DDL

5.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Which commonly used SQL statement is necessary to retrieve data from one or more tables in a database?

INSERT

TRUNCATE

CREATE

SELECT

6.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Which structure in a table represents an individual record contained in the database?

relationship

row

column

foreign key

7.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Which SQL statement is used to filter data in a database?

DISTINCT

ORDER BY

WHERE

FROM

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

16 questions

Principles of Information Technology

Quiz

•

9th Grade - University

16 questions

Gerência do Processador

Quiz

•

University

20 questions

Infrastructure (Network)

Quiz

•

University

20 questions

C Quest 2.0

Quiz

•

University

20 questions

PHP First Internal Practical Viva

Quiz

•

University

20 questions

quizz tkinter

Quiz

•

11th Grade - University

20 questions

Software Testing and Maintenance Quiz

Quiz

•

University

Popular Resources on Wayground

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

54 questions

Analyzing Line Graphs & Tables

Quiz

•

4th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

15 questions

Equivalent Fractions

Quiz

•

4th Grade

Discover more resources for Computers

20 questions

CompTIA Network+ - Ports and Protocols

Quiz

•

University

SQL and Database Quiz

21 questions

Which three elements of a relational database are defined in the schema? (Choose 3.)

In the SQL statement " SELECT genre FROM movies" what is specified by "genre"?

What is a flat file database?

What is used to show how the tables in a database are related to one another?

Which commonly used SQL statement is necessary to retrieve data from one or more tables in a database?

Which structure in a table represents an individual record contained in the database?

Which SQL statement is used to filter data in a database?

What is represented by the comma-separated list of items following the SELECT command in this example?

Refer to the exhibit. The exhibit shows the structures of the Drivers and Orders data tables for a pizza delivery service. The same driver may deliver multiple orders on an average day. What type of relationship exists between the Drivers table and the Orders table?

Which two SQL statements are used to create and change a database schema? (Choose two.)

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers