ITS Databases Practice Exam #13 - Edubirdie

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

2024
Views:

292

Pages:

2
Author:

Muthia M.

Answer these question bellows. 1. Evaluate the following table: Location Main Warehouse Sales Address1 3 Main St 45 Stockman St 555 Shoreline Dr Address2 Suite 101 Suite 2 Which column needs to be moved to another table for this table to be in 3NF? A. Winner B. EventID C. Birthdate D. Event 2. A clustered index improves the performance of which types of queries? A. Queries that return large result sets. B. Queries that return a range of values by using the = operator. C. Queries that do not use ORDER BY or GROUP BY clauses. D. Queries that are accessed randomly. 3. Refer to the table below to evaluate the statements. Use the dropdown menus to select the answer choice that completes each statement. Student Lastname Firstname Address City State Postal ID Code Char(7) Vchar(20) Vchar(20) Vchar(20) Vchar(2) Vchar(20) Vchar(10) a. The primary key in this table should be... (STUDENT ID) b. The best example of valid data for the first field would (1234567) be... 4. You are working on a query on a table named totalsales that will total the sales and display an average sale by region and salesperson. Which statement fulfills this need? A. SELECT region, salesperson, SUM(sales), AVG(sales) FROM totalsales B. SELECT region, salesperson, SUM(sales), AVERAGE(sales) FROM totalsales C. SELECT region, salesperson, SUM(sales), AVG(sales) FROM totalsales GROUP BY region, salesperson D. SELECT region, salesperson, SUM(sales), AVERAGE(sales) FROM totalsales GROUP BY region, salesperson, sales 5. A database administrator creates custom roles to assign to users and groups to ensure that the users and group have only the permissions they need to perform the tasks they need to perform on the company inventory database. What database principle is being implemented? A. Referential Integrity B. Normalization C. Least Privilege D. Metadata

Related Documents

ITS Databases Practice Exam #13

ITS Databases Practice Exam #13 - Page 1

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