ITS Databases Practice Exam #7 | American Baptist College - Edubirdie

University:
American Baptist College
Course:
CIT370 | Database Design and Processing
Academic year:

2024
Views:

100

Pages:

2
Author:

Muthia M.

Answer these question bellows. 1. Which are the reasons for normalizing data within a database? (Choose two) A. Reduce the number of tables in a database. B. Reduces dependencies on data. C. Reduces the size of a database. D. Reduces redundancies of data. 2. Evaluate the following query: SELECT LastName, FirstName FROM Employees WHERE EmployeeID = ALL (SELECT EmployeeID from Sales WHERE Amount > 50000); There are five employees who sold over 50000, but none are showing in the results. What keyword needs to change to allow for the five employees to be returned? A. Change ALL to IN B. Change ALL to ANY C. Change ALL to WHERE D. Change ALL to JOIN 3. A sales manager needs to see orders that have been completed and are the order type is not a pre-order. Specifically, the orderID, orderdate, and customerID are needed. Which SQL statement fulfills that need? A. SELECT orderid, ordertype, orderdate, customerid FROM orders WHERE orderdate IS NOT NULL OR NOT ordertype = 'pre-order' B. SELECT orderid, ordertype, orderdate, customerid FROM orders WHERE orderdate IS EMPTY AND NOT ordertype = 'pre-order' C. SELECT orderid, ordertype, orderdate, customerid FROM orders WHERE orderdate <> NULL AND NOT ordertype = 'pre-order' D. SELECT orderid, ordertype, orderdate, customerid FROM orders WHERE orderdate IS NOT NULL AND NOT ordertype = 'pre-order' 4. You need to create a query that will display all records from the clients table that have the state New Mexico and the city of Roswell. Answer: SELECT * FROM clients WHERE state = 'New Mexico' AND city = 'Roswell' 5. You have the following table definition: CREATE TABLE Cookies (CookielD INTEGER, Name VARCHAR (20)) You need to insert a new product. The cookie name is Snickerdoodle and the cookie ID is 77. Which SQL should you use? Answer: INSERT INTO Cookies (Name, CookielD) VALUES ('Snickerdoodle', 77)

Related Documents

ITS Databases Practice Exam #7

ITS Databases Practice Exam #7 - Page 1

ITS Databases Practice Exam #7 - Page 2

of 2

Recommended Documents

Quiz 1: Fundamental Of Data Visualization - Knowledge And Comprehension

Quiz 1: Fundamental Of Data Visualization - Knowledge And Comprehension

American Baptist College CIT370 | Database Design and Processing

Assignment

Quiz 3: Fundamental Of Data Visualization - Synthesis And Creation

Quiz 3: Fundamental Of Data Visualization - Synthesis And Creation

American Baptist College CIT370 | Database Design and Processing

Assignment

Quiz 4: Fundamental Of Data Visualization - Evaluation And Reflection

Quiz 4: Fundamental Of Data Visualization - Evaluation And Reflection

American Baptist College CIT370 | Database Design and Processing

Assignment

Data Analytics Practice Exam 18

Data Analytics Practice Exam 18

American Baptist College CIT370 | Database Design and Processing

Answer Key

Quiz 5: Fundamental Of Data Visualization - Application To Real-World Scenarios

Quiz 5: Fundamental Of Data Visualization - Application To Real-World Scenarios

American Baptist College CIT370 | Database Design and Processing

Assignment

Quiz 8 : Fundamental Of Data Visualization – Effectiveness Of Chart Usage

Quiz 8 : Fundamental Of Data Visualization – Effectiveness Of Chart Usage

American Baptist College CIT370 | Database Design and Processing

Assignment

ITS Databases Practice Exam #12

ITS Databases Practice Exam #12

American Baptist College CIT370 | Database Design and Processing

Assignment

Data Analytics Practice Exam #5

Data Analytics Practice Exam #5

American Baptist College CIT370 | Database Design and Processing

Assignment

Data Analytics Practice Exam #16

Data Analytics Practice Exam #16

American Baptist College CIT370 | Database Design and Processing

Assignment

ITS Databases Practice Exam

ITS Databases Practice Exam

American Baptist College CIT370 | Database Design and Processing

Assignment

ITS Databases Practice Exam #2

ITS Databases Practice Exam #2

American Baptist College CIT370 | Database Design and Processing

Assignment

ITS Databases Practice Exam #10

ITS Databases Practice Exam #10

American Baptist College CIT370 | Database Design and Processing

Assignment

New Documents from this Course

ITS Databases Practice Exam #5

ITS Databases Practice Exam #5

American Baptist College CIT370 | Database Design and Processing

Assignment

Data Analytics Practice Exam #13

Data Analytics Practice Exam #13

American Baptist College CIT370 | Database Design and Processing

Assignment

Data Analytics Practice Exam #17

Data Analytics Practice Exam #17

American Baptist College CIT370 | Database Design and Processing

Assignment

Data Analytics Practice Exam #14

Data Analytics Practice Exam #14

American Baptist College CIT370 | Database Design and Processing

Assignment

Data Analytics Practice Exam #12

Data Analytics Practice Exam #12

American Baptist College CIT370 | Database Design and Processing

Assignment

Data Analytics Practice Exam #9

Data Analytics Practice Exam #9

American Baptist College CIT370 | Database Design and Processing

Assignment

Data Analytics Practice Exam #6

Data Analytics Practice Exam #6

American Baptist College CIT370 | Database Design and Processing

Assignment

Data Analytics Practice Exam #2

Data Analytics Practice Exam #2

American Baptist College CIT370 | Database Design and Processing

Assignment

Data Analytics Practice Exam #10

Data Analytics Practice Exam #10

American Baptist College CIT370 | Database Design and Processing

Assignment

Data Analytics Practice Exam #3

Data Analytics Practice Exam #3

American Baptist College CIT370 | Database Design and Processing

Assignment

Storytelling With Data

Storytelling With Data

American Baptist College CIT370 | Database Design and Processing

Lecture Note