ITS Databases Practice Exam #11 - Edubirdie

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

2024
Views:

415

Pages:

2
Author:

Muthia M.

Answer these question bellows. 1. Evaluate each SQL statement. Select Yes if the statement has a syntax error in it and No if there is no syntax error within the statement. a. SELECT INTO Customers FROM CustomersNew (NO) b. INSERT INTO Customers FROM Customers New (YES) c. INSERT INTO Customers (LastName, FirstName) SELECT LastName, FirstName from Customers New (NO) 2. What statement is used to retrieve data from a database? A. READ B. SELECT C. EXTRACT D. GET 3. A sales manager wants to see a list of customers that are not in Los Angeles nor the states of Washington and Oregon. Which SQL statement fulfills this request? A. SELECT lastname, firstname FROM customers WHERE city != 'Los Angeles' AND state NOT IN ('Oregon', 'Washington') B. SELECT lastname, firstname WHERE city <> 'Los Angeles' AND state <> ('Oregon', 'Washington') FROM customers C. SELECT lastname, firstname FROM customers WHERE city <> 'Los Angeles' AND state NOT IN ('Oregon', 'Washington') D. SELECT lastname, firstname FROM customers WHERE city != 'Los Angeles' AND state != ('Oregon', 'Washington') 4. A research analyst wants to see research projects with a status of active, and be able to see this list of projects any time with a single SELECT * FROM active_projects statement. Which SQL statement allows one to build this list? A. CREATE PROCEDURE active_projects AS SELECT projectid, projectname FROM projects WHERE status = 'Active' B. INSERT PROCEDURE active_projects AS SELECT projectid, projectname WHERE status = 'Active' FROM projects C. CREATE VIEW active_projects AS SELECT projectid, projectname FROM projects WHERE status = 'Active' D. INSERT VIEW active_projects AS SELECT projectid, projectname FROM projects WHERE status = 'Active' 5. A developer needs to build a function, named grand_total, that accepts an orderid input, calculates and adds the sales tax to the order, and returns the grand total. Using drag and drop, arrange the lines for the function in the correct order. Step 1: CREATE FUNCTION grand_total(@orderid int) RETURNS decimal AS Step 2: BEGIN Step 3: DECLARE @grandtotal decimal Step 4: SELECT @grandtotal = subtotal 1.07 FROM * orders WHERE @orderid orderid Step 5: RETURN @grandtotal Step 6: END

Related Documents

ITS Databases Practice Exam #11

ITS Databases Practice Exam #11 - Page 1

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