Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Which of the following is not a valid aggregate function

03/12/2021 Client: muhammad11 Deadline: 2 Day

https://learn.umuc.edu/d2l/lms/quizzing/user/attempt/quiz_start_frame_auto.d2l?ou=416120&isprv=&drc=0&qi=1047977&cfql=0&dnb=0 1/4

Question 1 (0.5 points)

Question 2 (0.5 points)

Question 3 (0.5 points)

Question 4 (0.5 points)

Question 5 (0.5 points)

Saved

Saved

Saved

Saved

Saved

If a primary key is not a unique number for each ID entered in as part of the INSERT command, an error message will be displayed.

True

False

What is the error in this SQL statement?

CREATE vehicletype (carid INTEGER PRIMARY KEY, typeofvehicle TEXT, manufacturer TEXT);

(True/False). Will this SQL statement create a table called vehicletype?

CREATE TABLE vehicletype (carid PRIMARY KEY, typeofvehicle TEXT, manufacturer TEXT);

True

False

If this command correctly enters a row of data into a table, which of the following would be the correct command to create that table? INSERT INTO vehicletype VALUES (1, “truck”, “Chevrolet”);

(True/False). This command was used to create a table: CREATE TABLE vehicletype (carid INTEGER PRIMARY KEY, typeofvehicle TEXT, manufacturer TEXT); Will the following instruction add a row to the table?

The CREATE command is incomplete

There are too many columns designated for the table.

CREATE vehicletype (carid INTEGER PRIMARY KEY, typeofvehicle TEXT, manufacturer TEXT);

CREATE TABLE vehicletype (carid INTEGER PRIMARY KEY, typeofvehicle TEXT, manufacturer TEXT);

9/13/2019 Quiz - IFSM 201 6364 Concepts and Applications of Information Technology (2198) - UMUC Learning Management System

https://learn.umuc.edu/d2l/lms/quizzing/user/attempt/quiz_start_frame_auto.d2l?ou=416120&isprv=&drc=0&qi=1047977&cfql=0&dnb=0 2/4

Question 6 (0.5 points)

Question 7 (0.5 points)

Saved

Saved

INSERT INTO vehicletype (1, “SUV”,” Honda”);

True

False

This command was used to create a table: CREATE TABLE vehicletype (carid INTEGER PRIMARY KEY, typeofvehicle TEXT, manufacturer TEXT,year INTEGER);

At least 25 rows have been inserted with different types of vehicles (truck, sedan, SUV, sport) and manufacturer (Chevrolet, Ford, Toyota, etc.), and year the vehicle was manufactured. What would be the result of this command: Select * FROM vehicletype WHERE typeofvehicle=”truck” ORDER BY year;

This table has been created (Database Schema) and populated with values listed in RESULTS.

Database Schema

vehicletype 10 rows

Id (PK) INTEGER

typeofvehicle TEXT

manufacturer TEXT

year INTEGER

inventoryonhand INTEGER

RESULTS

Id typeofvehicle manufacturer year inventoryonhand

1 Pickup Chevrolet 2009 12

2 SUV Ford 2017 13

3 SUV Toyota 2015 7

4 Sedan Toyota 2014 8

5 Sedan Ford 2017 10

6 Coupe Hyundai 2010 8

7 Pickup Honda 2015 7

8 Sedan Honda 2017 23

9 SUV Hyundai 2013 6

10 Pickup Ford 2017 16

Which of the following commands would result in a value of 6 (six) being displayed?

A list of all the vehicles in the database would be displayed and ordered by year manufactured.

A list of only the trucks would be displayed and those vehicles would be listed in order of the year the vehicle was manufactured.

9/13/2019 Quiz - IFSM 201 6364 Concepts and Applications of Information Technology (2198) - UMUC Learning Management System

https://learn.umuc.edu/d2l/lms/quizzing/user/attempt/quiz_start_frame_auto.d2l?ou=416120&isprv=&drc=0&qi=1047977&cfql=0&dnb=0 3/4

Question 8 (0.5 points)

Question 9 (0.5 points)

Saved

Saved

This table has been created (Database Schema) and populated with values listed in RESULTS.

Database Schema

vehicletype 10 rows

Id (PK) INTEGER

typeofvehicle TEXT

manufacturer TEXT

year INTEGER

inventoryonhand INTEGER

RESULTS

Id typeofvehicle manufacturer year inventoryonhand

1 Pickup Chevrolet 2009 12

2 SUV Ford 2017 13

3 SUV Toyota 2015 7

4 Sedan Toyota 2014 8

5 Sedan Ford 2017 10

6 Coupe Hyundai 2010 8

7 Pickup Honda 2015 7

8 Sedan Honda 2017 23

9 SUV Hyundai 2013 6

10 Pickup Ford 2017 16

Which of the following commands would result in a value of 2009 (two thousand nine) being displayed?

Which of the following is NOT a valid aggregate function?

SELECT MIN(inventoryonhand) FROM vehicletype;

SELECT MAX(inventoryonhand) FROM vehicletype;

SELECT MIN(year) FROM vehicletype;

SELECT MAX(year) FROM vehicletype;

SELECT AVG(inventoryonhand) FROM vehicletype;

SELECT COUNT(YEAR) FROM vehicletype;

9/13/2019 Quiz - IFSM 201 6364 Concepts and Applications of Information Technology (2198) - UMUC Learning Management System

https://learn.umuc.edu/d2l/lms/quizzing/user/attempt/quiz_start_frame_auto.d2l?ou=416120&isprv=&drc=0&qi=1047977&cfql=0&dnb=0 4/4

Question 10 (0.5 points) Saved

Assuming that a table has been correctly constructed with the command CREATE TABLE vehicletype (carid INTEGER PRIMARY KEY, typeofvehicle TEXT, manufacturer TEXT,year INTEGER, inventoryonhand INTEGER); which of the following is a valid aggregate function:

Submit Quiz 10 of 10 questions saved

SELECT MAX(inventoryonhand) FROM vehicletype;

SELECT * MAX FROM vehicletype;

SELECT AVG(inventoryonhand) FROM vehicletype;

SELECT SUM(inventoryonhand) FROM vehicletype;

SELECT typeofvehicle FROM vehicletype ORDER BY year;

SELECT SUM (inventoryonhand) FROM manufacturer;

SELECT MIN(year) FROM vehicletype;

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Quality Homework Helper
Instant Homework Helper
Custom Coursework Service
Ideas & Innovations
Engineering Mentor
Assignment Solver
Writer Writer Name Offer Chat
Quality Homework Helper

ONLINE

Quality Homework Helper

I find your project quite stimulating and related to my profession. I can surely contribute you with your project.

$15 Chat With Writer
Instant Homework Helper

ONLINE

Instant Homework Helper

I will be delighted to work on your project. As an experienced writer, I can provide you top quality, well researched, concise and error-free work within your provided deadline at very reasonable prices.

$42 Chat With Writer
Custom Coursework Service

ONLINE

Custom Coursework Service

I have read your project details and I can provide you QUALITY WORK within your given timeline and budget.

$36 Chat With Writer
Ideas & Innovations

ONLINE

Ideas & Innovations

This project is my strength and I can fulfill your requirements properly within your given deadline. I always give plagiarism-free work to my clients at very competitive prices.

$33 Chat With Writer
Engineering Mentor

ONLINE

Engineering Mentor

I am an academic and research writer with having an MBA degree in business and finance. I have written many business reports on several topics and am well aware of all academic referencing styles.

$16 Chat With Writer
Assignment Solver

ONLINE

Assignment Solver

I will be delighted to work on your project. As an experienced writer, I can provide you top quality, well researched, concise and error-free work within your provided deadline at very reasonable prices.

$32 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Elements of an ethical sampling plan in nursing - Amazon vs walmart case study answers - Compare and contrast the hypothesis of gradualism and punctuated equilibrium - Target corporation case study pdf - Nutrition and wellness changes in adults - Describe the situation at lehman brothers from an ethics perspective - From which direction does autocad start measuring angles - Get The Iconic Fool Me Once Coat - Kmart state of origin merchandise - On course strategies for college success - The blind side discussion questions - Net time setup 314 - Cadbury india distribution network - Rapid re ignition system - Week 3 Discussion drug control - Male and female communication styles in the workplace - Agree to time frames for carrying out workplace instructions - Cribbage flush while pegging - What is a characteristic of a hot swappable esata drive - Assignment - Otis elevator dimensions pdf - Creative Solutions - Chcorg303c participate effectively in the work environment - Age of innocence narrator - Laminex honey elm riven - Yo les envié sent postales a mis amigos - When is criminal profiling used - Week 2 Assignment: Essay – Painting Analysis & Reflection - Carrefour case study international business - Week 1 Edg class - Alfie kohn beyond discipline - Assessment 1: Comprehensive Needs Assessment - Iv flow rate calculator - Post it short film analysis - How do you make the distinction between doing a safety plan and a harm reduction plan? - Bbc bitesize animal farm - Elizabeth macarthur high school reviews - Texsu blackboard - Holes vocabulary chapters 11 20 - Computer Ethics - DNP-Direct Practice Improvement (DPI) Project Proposal Chapter 1 - Introduction to the Project - What is 1 345 rounded to the nearest integer - 3 methyl 2 butanone msds - Cyber Security - 22a pinnacle row lennox head - Comprehensive Analysis of Consumer Behavior - What is emotive laguage - A defense of abortion judith jarvis thomson summary - University of virginia health system case study solution - Le chatelier principle explain color change - Chapter 18 voting and elections worksheet answers - 540 fe - Elements of performing arts ppt - All 6 simple machines - Harvard global supply chain management simulation v2 answers - Parts of a url - Corporate Finance - Analyzing managerial decisions bagby copy company - Can t help myself terrie and the carlas lyrics - F kq1q2 r 2 solve for k - Human Services Organizations as systems - I joist framing details - Reading assessment record sheet - "A" WORK IN 18 HOURS - Global Societal Problem, Argument and Solution - Research paper - The tensile strength of a certain metal component - Statistics - If i told him gertrude stein - Managerial Economics-Discussion - Poly pipe layer for dozer - Schonell reading test printable - Nursing Soap note - WORK - Fundamentals of sport and exercise psychology pdf - M18 tapping drill size - The lovesong of j alfred prufrock epigraph translation - Kiss fm melbourne careers - Difference between primary audience and secondary audience - What is 0.4 is 10 times as much as - Dewey decimal system 813 - Toward a monopoly horizontal and vertical integration answers - Lord's day observance society - Sciences po lse dual degree - Brentwood park primary school - Calculating opportunity cost worksheet - 125340 Stock Report Instructions - Woolworths credit card australia - Table tennis scoring rules - Sao fatal bullet ultra tough worm skin - Creswell 1998 phenomenology - BusinessManagementEssay - Compentency Journal - Holbrook unit whiston hospital - ________ holds that there are few really new ideas and that "true is better" than new. - Cisco 200 125 exam dumps - Ron redmond qld police - Who wrote let her go - 2. Develop a segmentation scheme for bulletproof backpacks and include the most important segment descriptors (demographics, psychographics, behaviors, values, attitudes, etc. for the segments - How to increase your bolt score