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

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

2024
Views:

207

Pages:

2
Author:

Muthia M.

Answer these question bellows. 1. A flower shop wants to see every flower ordered, but each flower should only show once. Which SQL statement will fulfill that need? A. SELECT UNIQUE flowername FROM flowers B. SELECT flowername FROM flowers DISTINCT C. SELECT DISTINCT flowername FROM flowers D. SELECT TOP 1 flowername FROM flowers 2. A view named vw_customers exist with a firstname and lastname column from the customers’ table. The customerid field needs to be added to the view and should be the first field in the view. Which SQL statement makes the needed change to the view? A. DROP VIEW vw_customers CREATE VIEW vw_customers AS SELECT customerid, firstname, lastname FROM customers B. ALTER VIEW vw_customers AS SELECT customerid, firstname, lastname FROM customers C. The result of the execution of a query. D. CREATE VIEW vw_customers AS SELECT customerid, firstname, lastname FROM customers 3. You have been tasked to delete a row from a database table. You execute the following SQL statement without a WHERE clause: DELETE FROM table_name What will be the result of executing the statement above without a WHERE clause? A. No records will be deleted. B. All records will be deleted. C. An error message will be returned. D. The first record will be deleted by default. 4. Which SQL statements, as part of creating a column in a table, will format the orderdate field in YYYY-MM-DD HH:MI:SS format? (Choose two) A. orderdate DATETIME B. orderdate TIMESTAMP C. orderdate DATE D. orderdate SMALLDATETIME 5. Match each JOIN type to its function. To answer, drag the JOIN type from the column on the left to its correct function on the right. Each JOIN type may be used once, more than once, or not at all. a. RIGHT OUTER JOIN: Returns all rows from the right table, even if there are no matches in the left table. b. LEFT OUTER JOIN: Returns all rows from the left table, even if there are no matches in the right table. c. INNER JOIN: Returns rows when there is at least one match in both tables. d. FULL OUTER JOIN: Returns rows when there is a match in one of the tables.

Related Documents

ITS Databases Practice Exam #8

ITS Databases Practice Exam #8 - Page 1

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