COSC 3380 Exam 2 with all Correct & 100% Verified Answers |Actual Complete Exam |Already Graded A+

COSC 3380 Exam 2 with all Correct & 100% Verified
Answers |Actual Complete Exam |Already Graded A+

Stored functions have no parameters ✔Correct Answer-False

ID in Faculty is the PRIMARY KEY. Code in Department is the PRIMARY KEY
If DepartmentView is a materialized view, against what tables is the query executed?
✔Correct Answer-DepartmentView

Which statement correctly inserts Sales ✔Correct Answer-INSERT INTO Department
VALUES(82, 'Sales', 6381)

Feedback: the column names are omitted, so the values must be in the same order as the
columns produced by SHOW COLUMNS

Stored functions may be executed from the MySQL command line ✔Correct Answer-True

Select the database programming technique that best matches the description.
- Usually generates a network round trip for each SQL query ✔Correct Answer-Embedded SQL

What cities are selected?
SELECT * FROM city WHERE ID < 300 OR Population > 7500000 ✔Correct Answer-Rio de
Janeiro

What cities are selected?
SELECT Name FROM City WHERE id >= 2000; ✔Correct Answer-No cities

How many rows are returned?
SELECT * FROM Country WHERE Population IS NULL; ✔Correct Answer-1

What is missing to select rows except Aruba?
SELECT * FROM Country WHERE IndepYear _____; ✔Correct Answer-IS NOT NULL

Compiles and stores complex data processing tasks on the database server. ✔Correct Answer-
Procedural SQL

The driver manager communicates with all drivers using the same commands. ✔Correct
Answer-True

In the animation below, the close() method is called if the password is incorrect ✔Correct
Answer-False

, What is B? ✔Correct Answer-Financial

Which name refers to a single value selected by flightCursor? ✔Correct Answer-airport

What districts are selected?
SELECT District FROM City WHERE Name = 'Rio de Janerio'; ✔Correct Answer-Rio de Janerio

In a join, what are the first and second tables in the FROM clause called? ✔Correct Answer-
Left and right, respectively

Each database requires a different driver manager ✔Correct Answer-False

Which MYSQLCursor method should always be called prior to closing the cursor's connection?
✔Correct Answer-close()

What is wrong with the statement below?
EXEC SQL
SELECT ID, Name
INTO :employeeNumber, :employeeName
FROM Employee ✔Correct Answer-The statement should return one row, not many

A secondary API can be layered on top of a third API, for a total API layer ✔Correct Answer-
True

Which columns can be compared in a join? ✔Correct Answer-Only columns with comparable
data types

Which line assigns the correct tuple for the UPDATE statement?
flightQuery = ('UPDATE Flight ' 'SET AirlineName = %s ' 'WHERE FlightNumber = %s')
flightCursor.execute(flightQuery, flightData) ✔Correct Answer-flightData = ('United Airlines',
105)

In the animation below, the secondaryt API IS ODBC ✔Correct Answer-True

Which statement correctly inserts Engineering? ✔Correct Answer-INSERT INTO Department
(Name, ManagerID)
VALUES('Engineering', 2538)

The Library of Congress scans all books and documents in the collection. Scanned images are
converted to characters with optical character recognition software. Each book is associated
with a title and author ✔Correct Answer-Unstructured