you are querying a database of manufacturing company suppliers. the column name for supplier identification numbers is supplier_id. what is the correct clause to retrieve only data about the supplier with identification number 85317?

Category :

Mohammed

Guys, does anyone know the answer?

get you are querying a database of manufacturing company suppliers. the column name for supplier identification numbers is supplier_id. what is the correct clause to retrieve only data about the supplier with identification number 85317? from screen.

9 Question 9 You are querying a database of manufacturing company suppliers The

9 Question 9 You are querying a database of manufacturing company suppliers The from COMPUTER SCIENCE EN CST259 at Chandigarh University

9 question 9 you are querying a database of

Chandigarh University

COMPUTER SCIENCE EN CST259

akasumitlamba 6 67% (3)

This preview shows page 5 - 6 out of 6 pages.

9.Question 9You are querying a database of manufacturing company suppliers. The column name for supplieridentification numbers is supplier_id. What is the correct clause to retrieve only data about the supplier withidentification number 85317?1 / 1 pointSELECT supplier_id 85317COLUMN supplier_id = 85317WHERE supplier_id = 85317FROM supplier_id 85317CorrectThe correct clause is WHERE supplier_id = 85317. This clause tells the database to return only informationabout the supplier whose ID is 85317.

10.Question 10Imagine you are sharing your data with a company stakeholder. Why might you display data with a datavisualization instead of a table? Select all that apply.

Get answer to your question and much more

End of preview. Want to read all 6 pages?

Upload your study docs or become a

Course Hero member to access this document

Term Spring Professor Surya Tags Analyst Report

Students also studied

Students also studied Related Q&A

Bookmarked 0 Recently viewed

COMPUTER SCIENCE EN CST259

quiz coursera.pdf Viewing now

Interested in quiz coursera.pdf

Bookmark it to view later.

More like this

Google Data Analytics: Course 1

Study with Quizlet and memorize flashcards containing terms like 01-001 - Definition of Data, 01-002 - Definition of Analytics, 01-003 - Definition of Analysis and more.

Google Data Analytics: Course 1 - Foundations

4.7 (7 reviews) Term 1 / 93

01-001 - Definition of Data

Click the card to flip 👆

Definition 1 / 93

facts, observations, numbers, measurements, videos, pics

Click the card to flip 👆

Created by lisatbuy

Terms in this set (93)

01-001 - Definition of Data

facts, observations, numbers, measurements, videos, pics

01-002 - Definition of Analytics

science of logical analysis, science of data

01-003 - Definition of Analysis

collection, transformation, organization, conclusions, predictions, decision-making

01-004 - Steps in Data Analysis Process

ask, prepare, process, analyze, share, act

01-005 - One way to think of analysis is that it turns data into _____.

insights

01-006 - List 5 ways to use data

(IP, IOT, LNP, SC, MD)

improve processes, identify opportunities and trends, launch new products, serve customers, make decisions

01-007 - Definition of Business Analytics (UMS,DMFD,MD)

use of math and statistics to derive meaning from data to make better decisions

01-008 - What are the 3 types of business analytics?

descriptive, predictive, prescriptive

01-009 - Which type of business analytics interprets historical data to identify trends and patterns?

descriptive

01-010 - Which type of business analytics centers on taking information on trends and patterns to forecast future outcomes?

predictive

01-011 - Which type of business analytics uses testing and other techniques to determine which outcome will yield the best result for a given scenario?

prescriptive

01-012 - Definition of People Analytics

improve workplace and business processes

01-013 - Definition of Regression Analysis

a statistical method used to examine relationships between variables

01-014 - Definition of Root-Mean-Square Error

difference between predicted and observed values

01-015 - What are the 3 disciplines of Data Science?

machine learning/AI, statistics, analytics

01-016 - What is the excellence of a machine learning/AI engineer?

performance

01-017 - What is the excellence of a statistician?

rigor

01-018 - What is the excellence of an analyst?

speed in discovering gems of insight

01-019 - Analysts thrive on creative and ___-____ projects.

open-ended

01-020 - Analysts enjoy the fun and thrill of ____.

exploration

01-021 - What does a Data Scientist do? (NWMUURD)

create new ways of modeling and understanding the unknown by using raw data

01-022 - What are 3 reasons you analyze data? (PRT)

find patterns, relationships, trends

01-023 - A critical question to ask up-front is, "How do I define ____ for this project?

success

01-024 - Definition of a Data Set

a collection of data that can be manipulated or analyzed as one unit

01-025 - Definition of a Data Ecosystem

a group of elements that interact to create an environment in which to produce, store, manage, organize, analyze, and share information

01-026 - Definition Data-Driven Decision-Making

using facts to guide business strategy

01-027 - What are the 2 steps in Data-Driven Decision-Making?

define a problem and analyze it

01-028 - What does the phrase, Data Analysis Life Cycle describe?

the process of going from data to decision

01-029 - A clothing retailer collects and stores data about its sales revenue. Which of the following would be part of its data ecosystem? Select all that apply.

a. Inventory records

b. Sales database

c. Database of competing retailers

d. The cloud that stores its database

Inventory records, Sales database, the cloud that stores its database

01-030 - In data analytics, how is data described?

a. An aggregate of intelligence

b. A series of calculations and statistics

c. A technical business process

d. A collection of facts

a collection of facts

01-031 - What is the process of guiding business strategy using facts?

a. Strategic improvement

b. Identification of data and decisions

c. Analytical strategy

d. Data-driven decision-making

Data-driven decision-making

01-032 - Gap analysis is a process that could help accomplish which of the following tasks? Select all that apply.

a. Increase the efficiency of a mfg based on current assembly process

b. Improve accessibility for an education app based on its current functionality

c. Reduce a company's carbon footprint based on its current emissions

d. Spread awareness about income inequality based on local salaries

Increase the efficiency of a mfg based on current assembly process, and Improve accessibility for an education app based on its current functionality

01-033 - An analysis firm is conducting a data analysis of rainwater trends to give recommendations to agricultural companies. When they reach the manage stage of the data life cycle, which of the following might they do? Select all that apply.

a. Place their data in a location it can be accessed, even if it may not be used

b. Store and clean the data they have collected

c. Decide which security tools they will use to protect it

d. Collect and organize data relevant to rainwater

स्रोत : quizlet.com

google

google data analytics professional certificate. Contribute to elmoallistair/google-data-analytics development by creating an account on GitHub.

main

google-data-analytics/01_foundations-data/04_setting-up-a-data-toolbox/practice-quiz-sql.md

elmoallistair split c1 practice quizzes

1 contributor

62 lines (39 sloc) 1.45 KB

L3 Learn about Structured Query Language (SQL)

Question 1

SELECT * FROM employee WHERE jobCode = 'FTE' AND LastName = 'James'

What does the asterisk (*) after SELECT tell the database to do in this query?

Select, then delete data.

Select and filter data.

Select and multiply data.

Select all data.

The asterisk tells the database to select all data in the table.

Question 2

SELECT * FROM employee WHERE jobCode = 'FTE' AND LastName = 'James'

In this query, the data analyst wants to retrieve data from which table?

LastName

employee

James jobCode

The data analyst wants to retrieve data from the employee table.

Question 3

SELECT * FROM employee WHERE jobCode = 'FTE' AND LastName = 'James'

In this query, the data analyst wants to retrieve all data from the employee table, where the jobCode is FTE and the last name is James.

True

False

This query asks the database to select all data from the employee table, where the jobCode is FTE and the last name is James.

Question 4

You are writing a query and want to instruct the database to retrieve data from the warehouse_inventory table. What is the SQL statement that follows SELECT *? Type your answer below.

FROM warehouse_inventory

The correct SQL statement is FROM warehouse_inventory. FROM indicates where the selected data comes from. And warehouse_inventory is the name of the table.

स्रोत : github.com

Do you want to see answer or more ?

Yes No

Mohammed 5 day ago

Guys, does anyone know the answer?

Navigation

Status

Categories

you are querying a database of manufacturing company suppliers. the column name for supplier identification numbers is supplier_id. what is the correct clause to retrieve only data about the supplier with identification number 85317?

Mohammed

9 Question 9 You are querying a database of manufacturing company suppliers The

9 question 9 you are querying a database of

Students also studied

More like this

Google Data Analytics: Course 1

Google Data Analytics: Course 1 - Foundations

Terms in this set (93)

google

google-data-analytics/01_foundations-data/04_setting-up-a-data-toolbox/practice-quiz-sql.md

Last Posts

Random Posts