ASU Computer Information Systems CIS 360/ "CIS 360 all Quizzes 1-9 Questions and Answers" | Latest Updated 100% 2025/26.

Quiz 1 Which of the following is NOT among the classical stages for designing, building, and using a database? Physical implementation phase (i.e., building the database using a programming language) Conceptual phase (i.e., getting to know the business processes and drawing a blueprint of the database) Data analysis and visualization phase Marketing phase Data is the result of processing raw facts to reveal meaning. True False What is metadata? Data collected from Meta (aka Facebook) Data about data. Data used in metaphysics, a branch of philosophy. Data that can metamorphose (i.e., change shape) A database management software (DBMS) is a software that allows the user to interact with a database. True False Which of the following is NOT a database management software? Microsoft Excel MySQL Microsoft Access Microsoft SQL Server Oracle Database IBM DB2 CIS 360 All Quizzes 1- 9 Questions and Answers.Redundant data in databases are NO LONGER A PROBLEM because today's IT systems have enough space to store billions of records. True FalseQuiz 2 In the description of a business process, the verb gets translated into an entity when drawing an entity relationship diagram (ERD) True False At Franklin Ford Auto, a local dealership, a customer can buy one or many cars, and a car is bought by one customer only. For each customer, the dealership records their first name, last name, address, telephone number, and driver's license number. In the language used in database design, what are the customer's first name, last name, address, telephone number, and driver's license number called? Group of answer choices Relationships of the Customer entity Verbs of the Customer entity Attributes of the Customer entity Models of the Customer entity In the process below, select the entity(ies) to be included in an entity relationship diagram (ERD) (check all that apply): A physician can treat one or many patients. A patient is treated by one or many physicians. Group of answer choices Physician Patient Treat Can Select the relationship (s) in this business process of a restaurant (check all that apply): A patron can place one or more than one order. An order is placed by one and only one patron. Group of answer choices CustomerPlace Order Restaurant Which type of relationship is described in the process below? A football team can have up to 52 players, but a player belongs to only one team. Group of answer choices One-to-one relationship One-to-many relationship Many-to-many relationship No relationship Which type of relationship is described in the process below? A customer can rent one or many cars, but a car is rented by one customer only. Group of answer choices One-to-one relationship One-to-many relationship Many-to-many relationship No relationship Which type of relationship is described in the process below? For Taylor Swift's next concert in Phoenix, a concertgoer can buy only one ticket, and a ticket is bought by one customer only. Group of answer choices One-to-One relationship One-to-many relationship Many-to-many relationship No relationshipWhich type of relationship between student and apartment is described in the process below? In this university apartment complex, a student lives in one apartment, and an apartment is assigned to one student. Group of answer choices One-to-One relationship One-to-Many relationship Many-to-Many relationship No relationshipQuiz 3 Which of the following is NOT a requirement for selecting a primary key? A value of a primary key cannot be null. Values of a primary key should not change overtime. Values of a primary key should uniquely identify an entity instance. Values of a primary key should be three-letter long. Which of the following attributes of a car entity would you select as the primary key? The car's make (e.g. Toyota) The car's model (e.g., Camry) The car's Vehicle Identification Number (VIN) The car's year of manufacturing (e.g. 2023) In an American university with both American and international students, which attribute would you select as a primary key for identifying students? Driver's license number Social Security Number (SSN) Country of citizenship Customized numbers created by the university administration that uniquely identify each student. US Social Security Number Which of the following process(es) require(s) an associative entity? (Check all that apply). A teacher can teach many classes, and a class is taught by one teacher only. A player can play at one or many team positions, and a team position can be played by many players. A physician can treat many patients and a patient can be treated by many physicians. A car is rented by one customer only, but a customer can rent many cars. A primary key cannot be null, but a foreign key can be null. TrueFalse Given the following business process: A hotel room can host one or many guests, and a guest is hosted in only one hotel room. True or False: The entity Guest gives its primary key (GuestID) as a foreign key to the entity Room. Group of answer choices True False This is a one-to-many relationship:  One Room → can host many Guests  One Guest → is in one Room In a one-to-many relationship, the primary key from the "one" side goes into the "many" side as a foreign key. So:  RoomID should go into Guest as a foreign key  GuestID does NOT go into Room Given the following business process of a veterinary clinic: A dog has one owner. An owner may have more than one dog. Check all that apply: The entity Dog gives its primary key (DogID) to the Owner entity. The entity Owner gives its primary key (OwnerID) to the entity Dog. This relationship needs an associative entity This is a one-to-many relationship.Quiz 5 As of February 18th, 2025 Forbes Magazine estimates Elon Musk's net worth to be 394.2 billion USD. Select the most appropriate data type that can be used to record this number (in USD). DECIMAL (4,2) DECIMAL(15,2) DECIMAL (8,2) NUMERIC (5,2) None of the above Given the ERD and its corresponding SQL code below: CREATE TABLE Employee (EmployeeID INTEGER UNIQUE NOT NULL, LastName VARCHAR(35) NOT NULL, FirstName VARCHAR(35) NOT NULL, MiddleName VARCHAR(35), DateOfBirth DATE NOT NULL CHECK (DateOfBirth ''), SSN CHAR(9) UNIQUE NOT NULL, Salary DECIMAL (10,2) NOT NULL,ManagerID VARCHAR(10), PRIMARY KEY (EmployeeID), FOREIGN KEY (ManagerID) REFERENCES Employee (EmployeeID)); Select the correct statement: This code will NOT run because using the data type DECIMAL for Salary is wrong. This code will NOT run because you cannot use CHECK with the data type DATE. This code will NOT run because ManagerID and EmployeeID do NOT have the same data type. This code will run. All is fine. Select the correct statement(s) about coding in SQL: In the SELECT clause, commas are used to separate column names. In SQL, a semi-colon (;) is used to terminate a statement. In SQL, values for dates and texts are between single quotes. In SQL, DROP TABLE is used to delete a table. Select the clause(s) that are mandatory in an SQL statement. SELECT FROM WHERE GROUP BY HAVING ORDER BY True or False: The SQL code given below will run without any issue: SELECT StudentID, FirstName, LastName, DOB WHERE Major='Accounting' ORDER BY StudentID; True FalseIn the SQL code below, which clause will be executed first by the computer? SELECT EmployeeID, FirstName, LastName, DateOfHire FROM Employee WHERE Department='Accounting' ORDER BY EmployeeID; Group of answer choices SELECT EmployeeID, FirstName, LastName, DateOfHire FROM Employee WHERE Department='Accounting' ORDER BY EmployeeID; In the SQL code below, which clause will be executed last by the computer? SELECT Brand, ItemID, ItemName, ItemDescription FROM Inventory WHERE ItemType='Shoes' GROUP BY Brand ORDER BY Brand; SELECT Brand, ItemID, ItemName, ItemDescription FROM Inventory WHERE ItemType='Shoes' GROUP BY Brand ORDER BY Brand; True or False: The SQL code below will return the employee ID, first name, last name, and salary of the five employees with the highest salaries in the company. SELECT TOP 5 EmployeeID, FirstName, LastName, Salary FROM Employee ORDER BY Salary; Group of answer choices TrueFalse True or False: When running the SQL code below, the 'WHERE' clause will be executed by the computer before the 'GROUP BY' clause. SELECT Department, EmployeeID, LastName, FirstName, Salary FROM Employee WHERE Position='Manager' GROUP BY Department ORDER BY Department; Group of answer choices True FalseQuiz 6 In SQL Server, the two WHERE expressions below are equivalent: 1) WHERE YEAR(SalesDate) =2024 2) WHERE DATEPART(YEAR, SalesDate) =2024 True False Which of the following SQL codes will list the names of students who got a grade of 90 or above from the table ExamGrade? SELECT StudentName, Grade FROM ExamGrade WHERE Grade = 90; SELECT StudentName, Grade FROM ExamGrade HAVING Grade = 90; SELECT StudentName, Grade FROM ExamGrade WITH Grade = 90; SELECT StudentName, Grade = 90 FROM ExamGrade; You are the database manager of a pizza delivery service. Which of the following SQL expressions computes the time duration (in minutes) between ordering a pizza and delivering it to the customer? DATEDIFF(MINUTE, Order Time, GETDATE()) DATEDIFF (MINUTE, OrderTime - Delivery Time) DATEDIFF(MINUTE, Order Time, DeliveryTime) MINUTE(OrderTime - DeliveryTime) You are given a portion of the ERD that describes the processes of a local hospital:Which of the following SQL codes computes the number of medical visits conducted by every physician working in the hospital? SELECT PhysicianID, COUNT(VisitID) GROUP BY PhysicianID FROM MedicalVisit SELECT PhysicianID, SUM(VisitID) GROUP BY PhysicianID FROM MedicalVisit SELECT PhysicianID, COUNT (VisitID) FROM MedicalVisit SELECT PhysicianID, COUNT(VisitID) FROM MedicalVisit GROUP BY PhysicianID You are given a portion of the ERD that describes the processes of a local hospital: Given that a physician often sees the same patient many times, select the SQL code that computes the number of (different) patients seen by every physician working in the hospital. SELECT PhysicianID, COUNT(DISTINCT PatientID) FROM MedicalVisit GROUP BY PhysicianID SELECT PhysicianID, COUNT(PatientID) FROM MedicalVisit GROUP BY PhysicianID SELECT PhysicianID, SUM(DISTINCT PatientID) FROM MedicalVisit GROUP BY PhysicianID SELECT PhysicianID, SUM (PatientID) FROM MedicalVisit GROUP BY PhysicianID Given the table below, select the WHERE statement that will return Nike shoes only:WHERE Shoe = 'Nike' WHERE Shoe IN 'Nike' WHERE Shoe LIKE '%Nike' WHERE Shoe LIKE 'Nike%' Given the table below, select the WHERE statement that will include all the customers who live in Arizona or in California.WHERE State = 'California' AND 'Arizona' WHERE State IN ('California', 'Arizona') WHERE State ='California' AND State='Arizona' None of the aboveHere is a portion of the ERD of a small company: The two SQL codes below will output similar results: 1) SELECT * FROM Employee E, Job J WHERE E.EmployeeID = J.EmployeeID 2) SELECT * FROM Employee E JOIN Job J ON E.EmployeeID = J.EmployeeID True FalseQuiz 7: Given the ERD below, which tables would you join to answer the following question: List the first name, last name, and address of loyalty customers for each theater location. Theater , LoyaltyCustomer Theater, Worker, Bill LoayaltyCustomer, Ticket, Bill, Worker, Theater LoyaltyCustomer, Ticket, Theater Given the ERD below, which tables would you join to answer the following question:List the prices of menu items purchased by customers when the movie with the title "Top Gun Maverick" was on. ShowTime, Movie, Bill Bill, Purchase, MenuItem, ShowTime Movie, Ticket, MenuItem, ShowTime MenuItem, Purchase, Bill, Ticket, Movie, ShowTime Given the ERD below, which tables would you join to answer the following question:Count the number of workers supervised by each manager. Theater, Worker Worker, Ticket Worker only. No other table needed Worker, LoayaltyCustomer Given two tables Sales_Invoice (with InvoiceID as primary key) and Cash_Receipt (with ReceiptID as primary key and InvoiceID as foreign key):Select the FROM ± WHERE clause of the SQL Code that you need to run to get a table showing the accounts receivable (i.e., amounts for sales not yet paid for by customers). FROM Sales_Invoice SI JOIN Cash_Receipt CR ON SI.InvoiceID = CR.InvoiceID FROM Sales_Invoice SI LEFT JOIN Cash_Receipt CR ON SI.InvoiceID = CR.InvoiceID FROM Cash_Receipt CR LEFT JOIN Sales_Invoice SI ON CR.InvoiceID=SI.InvoiceID FROM Sales_Invoice SI LEFT JOIN Cash_Receipt CR ON SI.InvoiceID = CR.InvoiceID WHERE CR.InvoiceID IS NULL Given two tables Purchase_Invoice (with PurchaseID as primary key) and Cash_Outflow (with OutflowID as primary key and PurchaseID as foreign key):Select the FROM ± WHERE clause of the SQL Code that you need to run to get a table showing the accounts payable (i.e., amounts for purchases not yet paid for by your company). FROM Cash_Outflow CO INNER JOIN Purchase_Invoice PI ON CO.PurchaseID = PI.PurchaseID FROM Cash_Outflow CO RIGHT JOIN Purchase_Invoice PI ON CO.PurchaseID = PI.PurchaseID FROM Cash_Outflow CO RIGHT JOIN Purchase_Invoice PI ON CO.PurchaseID = PI.PurchaseID WHERE CO.PurchaseID IS NULL FROM Cash_Outflow PI INNER JOIN Purchase_Invoice PI ON CO.PurchaseID = PI.PurchaseID WHERE CO.PurchaseID IS NULL Given two tables Order (with OrderID as primary key) and Delivery (with DeliveryID as primary key and OrderID as foreign key):Select the FROM ± WHERE clause(s) of the SQL code that you need to run to get a table showing data on ordered packages that were delivered (Hint: there are three correct answers). FROM Order O JOIN Delivery D ON O.OrderID=D.OrderID FROM Order O FULL OUTER JOIN Delivery D ON O.OrderID=D.OrderID FROM Order O RIGHT JOIN Delivery D ON O.OrderID=D.OrderID FROM Order O INNER JOIN Delivery D ON O.OrderID=D.OrderID FROM Order O, Delivery D WHERE O.OrderID = D.OrderIDYour company asks you to audit its operations. You want to focus on the order and delivery of items. You suspect that some employees may be delivering items to their friends/relatives without these items being paid for. Select the FROM ± WHERE clause of the SQL code that you need to run to get a table showing data about packages that were not ordered but were delivered. FROM Order O RIGHT JOIN Delivery D ON O.OrderID=D.OrderID WHERE O.OrderID IS NULL FROM Order O LEFT JOIN Delivery D ON O.OrderID=D.OrderID WHERE O.OrderID IS NULL FROM Order O RIGHT JOIN Delivery D ON O.OrderID=D.OrderID FROM Order O FULL JOIN Delivery D ON O.OrderID=D.OrderIDSenior management needs a list of all employees and their managers. For that, you want to join the table employee to itself. Select the two correct FROM ± WHERE clauses that allow you to do so. FROM Employee E, Employee M WHERE M.EmpID = E.MgrID FROM Employee E, Manager M WHERE E.EmpID = M.MgrID FROM Employee E JOIN Manager M ON E.EmpID = M.MgrID FROM Employee E JOIN Employee M ON M.EmpID = E.MgrIDQuiz 8 You can use aggregate functions (e.g., COUNT, SUM, AVG) with the HAVING clause, but not with the WHERE clause. TRUE FALSE As a database administrator, you want to write a code that simultaneously removes items from the company's inventory (Inventory table) and adds them to the Sales table when these items are sold. Which SQL Server function would you use to do so? CREATE REMOVAL... BEGIN TRANSACTION... CREATE VIEW... CREATE PROCESS... Which of the SQL functions below would you use to "save" a code that you can easily reuse later? CREATE PROCEDURE... CREATE CODE... CREATE TABLE... BEGIN TRANSACTION.. Which SQL function would you use to automatically record a sale in the Sales table when a cashier in your store scans the barcode of an item bought by a customer? RECORD BARCODE... CREATE BARCODE... RECORD ITEM... CREATE TRIGGER... As a database administrator, which of the following SQL functions would you use to create a virtual Employee table that excludes private information (such as social security numbers and dates of birth) of employees for an auditor who wants to audit the company's salaries and wages?CREATE VIEW... ALTER PROCEDURE... DROP TRIGGER... INSERT INTO... After you send the virtual table to the auditor, she calls you and requests that you provide her with the employees' dates of birth as well for her auditing purposes. Which of the SQL functions below would you use to make the needed changes? ALTER VIEW... ALTER PROCEDURE... ALTER TRIGGER... UPDATE TABLE... Which of these SQL functions or clauses would you use to run again a code that you previously saved as a procedure? RUN... RERUN... EXECUTE... COMMIT... Which of these SQL functions or clauses would you use to undo the changes made by an SQL transaction that you just ran? SAVEPOINT ROLLBACK COMMIT EXECWhich of the following is not used to encode information for data visualization? Shape Wave Length Height Color Which of the following types of graphs uses angle as a method of information encoding? Vertical bar chart Horizontal bar chart Bubble chart Pie chart Line chart Which of the following types of graphs uses slope as a method of information encoding? Vertical bar chart Horizontal bar chart Bubble chart Pie chart Line chart Which of the following information encoding methods are humans not good at identifying relatively small differences? Angle Height Length Size Slope Which pair of colors is usually considered "safe" for color-blind individuals?Red and Green Blue and Green Blue and Orange Orange and Yellow The table below presents U.S. pet ownership statistics for 2024 (Source: American Veterinary Medical Association). Pet Total number of U.S. households owning (in millions) Percentage of U.S. households owning (%) Dog 59.8 45.5 Cat 42.2 32.1 Fish 3.9 2.9 Reptiles 2.3 1,8 Birds 2.1 1.6 Small mammals (gerbils, hamsters, etc.) 1.3 1.0 Rabbits 0.9 0.7 Horses 0.7 0.5 Poultry 0.7 0.5 Which type of visualization (graph) would you use to show the second column (Total number of U.S. households owning, by type of pet)? Vertical bar chart Line chart Pie chart Scatter plot The table below presents Tesla stock prices from May 1, 2024 through April 1, 2025.Date Adjusted close price (USD) 1-May-24 178.08 1-Jun-24 197.88 1-Jul-24 232.07 1-Aug-24 214.11 1-Sep-24 261.63 1-Oct-24 249.85 1-Nov-24 345.16 1-Dec-24 403.84 1-Jan-25 404.6 1-Feb-25 292.98 1-Mar-25 259.16 1-Apr-25 252.31 Which graph would you use to visualize these stock prices? Pie chart Horizontal bar chart Line chart Bubble chart Which of these two graphs is a good visualization of the number of people over the age of 16 years per US state?A) Bar Chart B) Pie Chart Which of these two graphs is a good visualization of the total revenues of the 10 largest accounting firms in the world (year 2023)? A) Bar Chart B) HistogramWhich type of graph would you use to show the number of customers for each of the 12 Palermo theaters locations? Pie chart Bubble chart Line chart Area chart