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

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

2024
Views:

421

Pages:

3
Author:

Muthia M.

Answer these question bellows. 1. Evaluate the following code: SELECT bktitle, price FROM books WHERE publisher = 'stone' The query writer wants to ensure that any book title with the word "stone" in it is returned. What should the WHERE clause be to have the correct criteria for the writer's need? A. WHERE publisher IN '%stone%' B. WHERE publisher ='%stone%' C. WHERE publisher LIKE 'stone' D. WHERE publisher LIKE '%stone%" 2. An analyst needs to know the highest amount of sales in a list of daily sales amounts. Which keyword should the analyst use to obtain that amount? A. VALUES B. MOST C. MAX D. HIGH 3. Evaluate the following code: CREATE VIEW vw UtahCustomers AS SELECT lastname, firstname FROM customers WHERE state = 'Utah' What is a syntax error in this code? A. The view name is illegal. B. Semicolons are missing from the statements. C. The WHERE criteria needs to be in double quotes. D. The WHERE clause needs a == 4. Evaluate the following SQL Statement: DELETE view UtahCustomers; A developer runs this statement and gets an error message that this is unable to be deleted. What is the most likely cause of the error? A. The developer has insufficient permissions to delete the view. B. The TRUNCATE keyword should be used instead of DELETE. C. The DROP keyword should be used instead of DELETE. D. The REVOKE keyword should be used instead of DELETE. 5. Evaluate the following SQL Statement: SELECT LastName, FirstName, COUNT(OrderID) FROM Customers GROUPBY LastName, FirstName HAVING COUNT(OrderID) >=5 Where is the syntax error in this statement? A. The HAVING clause needs to be above GROUPBY. B. GROUPBY should be GROUP BY. C. The statement is missing semicolons. D. The fields in the SELECT portion need to be on separate lines.

Related Documents

ITS Databases Practice Exam #10

ITS Databases Practice Exam #10 - Page 1

ITS Databases Practice Exam #10 - Page 2

ITS Databases Practice Exam #10 - Page 3

of 3

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

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