CSCI N207 Quiz Two Answers

docx

School

Ivy Tech Community College, Indianapolis *

*We aren’t endorsed by this school

Course

210

Subject

Computer Science

Date

Feb 20, 2024

Type

docx

Pages

Uploaded by MagistrateMolePerson2564

CSCI N207 Quiz 2 Answers Question Which of the following will sort rows by CourseNumber in ascending order? order by CourseNumber AESC SORT BY CourseNumber t Answer Order by CourseNumber ORDER BY CourseNumber DESC Question What does the word "from” do? find a row find a column t Answer find a table : Question What does the key word “where” do? find columns to show their values find tables to show their data t Answer find rows to show their records find all the values from a table

Question Answer Wil his statement run, assuming there are no errors in the select and from phrase? ‘Select productName, cost from INVENTORY where provider = Dell Yes No Question Answer Wil his statement run, assuming there are no errors in the select and from phrase? ‘Select * from ART_SHOW wihere ShowDate > '1-Sep-2015'; Yes No Question Answer Wil his statement run, assuming there are no errors in the select and from phrase? ‘Select * from AUTHOR where PUBLISHER = #Pearson#: Yes No

Wil his statement run, assuming there are no errors in the select and from phrase? ‘Select * from BIKE where model LIKE “11B20097277", tAnswer Yes No Question ‘Which of the following wil ind fows with a start date before September 1 of 20142 where stariDate before #09-01-2014% tAnswer where stariDate < #08-01-2014% where stariDate before 09-01-2014 where startDate < 09-01-2014 Question ‘Which of the following wil ind fows whose phone numbers start with 812 and end vith 09, f al the phone numbers are in the correct format of (XOXox000X? Choose allthat appy. where phone = 812:09" where phone = (81209 tAnswer where phone ke (812)222-08" tAnswer where phone lie (812)"-10"

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Question ‘Which of the following key word il remove duplicated values in a column? Like Answer Distinct Wnere select Question What s the best name of a saved query ifthe query result shows movies with customer rating above 47 Movie MOVIE_ABOVE_FOUR Movie Rating Above Four Answer MovieRaingAboved Question Aquery result s displayed in a table format, Answer True False

Answer Answer Answer Question r ‘Which view you need to go to in order to edit a query? SaLview Datasheet view Design View Question ‘Which of the following wil add up values i a columin? Question Which of the following means a cell has & valus? 1S NOT NULL. < NULL LIKE NULL ISNULL

Question Ifthe table SALES has 10 rows, and the column Model has 7 values and 3 null values. What i the resultof tis query Select count(Model) from SALES; 10 tAnswer 7 Question What must be specified when joining two tables? Choose al that apply. tAnswer The names o the columns where the values must match Allthe column names from the two tables. tAnswer The names of the two tables Table aliases of the two tables Question Table TOY has columns named 1D, ToyName, Type, Manufacturer and table MANUFACTURER has columns named i ‘Select D, ToyName, Type, ManufacturerName from TOY, MANUFACTURER where Manufacturer = D; Yes tAnswer No

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Question Which of the following can find the earliest date from a date column? Answer MIN Question ‘What s true about a column alias? Choose al that apply. Answer Its created using the *AS” key word T Answer It should follow the column name convention. T Answer It a column name used n the query result. ‘You must use a column alias i you use a builtin function

Related Documents

Q9.pdf

Q3.pdf

CSCI N207 Quiz Five Answers.docx

CSCI N207 Quiz Three Answers.docx

CSCI N207 Quiz One Answers.docx

CSCI N207 Quiz Four Answers.docx

README.md.docx

4347 Project Description(1).docx

Midterm Exam-103-code1-solution.pdf

Midterm Exam-103-code2-solution.pdf

5-1 Module Five Assignment_ Impact of Cybercrime-2.pdf

Lab04.pdf

Recommended textbooks for you

Oracle 12c: SQL

Computer Science

ISBN:9781305251038

Author:Joan Casteel

Publisher:Cengage Learning

A Guide to SQL

Computer Science

ISBN:9781111527273

Author:Philip J. Pratt

Publisher:Course Technology Ptr

Np Ms Office 365/Excel 2016 I Ntermed

Computer Science

ISBN:9781337508841

Author:Carey

Publisher:Cengage

Programming with Microsoft Visual Basic 2017

Computer Science

ISBN:9781337102124

Author:Diane Zak

Publisher:Cengage Learning

New Perspectives on HTML5, CSS3, and JavaScript

Computer Science

ISBN:9781305503922

Author:Patrick M. Carey

Publisher:Cengage Learning

COMPREHENSIVE MICROSOFT OFFICE 365 EXCE

Computer Science

ISBN:9780357392676

Author:FREUND, Steven

Publisher:CENGAGE L

SEE MORE TEXTBOOKS

Recommended textbooks for you

Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
Publisher:Cengage Learning
New Perspectives on HTML5, CSS3, and JavaScript
Computer Science
ISBN:9781305503922
Author:Patrick M. Carey
Publisher:Cengage Learning
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L