ITS Databases Practice Exam #1 - Edubirdie

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

2024
Views:

445

Pages:

2
Author:

Muthia M.

Answer these question bellows. 1. Using drag and drop, complete the query below. The goal of the query is to display a list of customers from Utah, sorted by last name. SELECT lastname, firstname FROM customers (a) state = ‘UT’ (b) lastname A. SORT BY B. ORDER BY (b) C. WHEN D. WHERE (a) E. HAVING 2. Evaluate each statement regarding aggregates in queries. Select Yes if the statement is true and No if the statement is false. A. A GROUP BY clause must be paired with a HAVING clause. (NO) B. A GROUP BY clause must contain all non-aggregated fields in a (YES) query. C. A GROUP BY clause must be paired with a WHERE clause. (NO) 3. Evaluate the following SQL code: SELECT LastName, FirstName, COUNT(OrderID) FROM Customers GROUP BY LastName HAVING COUNT(OrderID) >=5 What would cause this statement to have a runtime error? A. A schema is missing. B. The GROUP BY clause is incomplete. C. A WHERE clause is required due to the presence of the HAVING clause. D. Semicolons are needed. 4. Evaluate the following SQL code: UPDATE Customers SET Status = 'Gold' IF TotalAmount > 10000 What would cause this statement to have a runtime error? A. The object type needs to be specified within the UPDATE statement B. The IF clause needs to be at the beginning of the statement C. The IF clause needs to be a WHERE clause D. The statement needs semicolons 5. Which statement will insert multiple rows? A. INSERT INTO table_name VALUES (value1, value2, value3,...) B. INSERT INTO table_name SELECT (column1, column2, column3) C. INSERT INTO table_name(column1, column2) VALUES (valuela, value1b), (value2a, value2b) D. INSERT INTO table_name (column1, column2, column3,...) VALUES (value1, value2, value3,...)

Related Documents

ITS Databases Practice Exam #1

ITS Databases Practice Exam #1 - Page 1

ITS Databases Practice Exam #1 - 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