WK 4 quiz

docx

School

American Military University *

*We aren’t endorsed by this school

Course

222

Subject

Computer Science

Date

Dec 6, 2023

Type

docx

Pages

4

Uploaded by eunjinee1088

Report
Attempt Score 100 / 100 - 100 % Overall Grade (Highest Attempt) 100 / 100 - 100 % Question 1 10 / 10 points Another term for an attribute is Question options: input. row. field. object. Question 2 10 / 10 points The purpose of an Entity-Relationship diagram is to Question options: document the characteristics of an individual field. visually represent the database. select the appropriate secondary keys in the database system. all of the above. Question 3 10 / 10 points A relation in a DBMS can also be called a(n) Question options: attribute. column. field. table. Question 4 10 / 10 points The approach to writing queries in a visual method is called Question options:
SQL. QAC. QBE. ACCESS. Question 5 10 / 10 points In order to select data from more than one table, it will be necessary to ____ the tables. Question options: merge group join break apart Question 6 10 / 10 points The basic form of an SQL retrieval command is Question options: SELECT-WHERE-FROM CREATE-SELECT-FROM SELECT-WHERE SELECT-FROM-WHERE Question 7 10 / 10 points What type of condition is formed by connecting two or more simple conditions? Question options: compound complex
conditional aggregate Question 8 10 / 10 points SQL has built-in functions which are also called _______ functions. Question options: accumulative. calculated. compound. aggregate. Question 9 10 / 10 points The proper shorthand representation for the Entity called Package with a primary key of PackageNum and fields PackageWeight, PackageDimensions is: Question options: Pack (PackNum , PackWght, PackDim) Package (PackageNum , PackageWeight, PackageDimensions) (PackageNum , PackageWeight, PackageDimensions) Table (Package, PackageNum , PackageWeight, PackageDimensions) Question 10 10 / 10 points A __________ is a field (or collection of fields) in a table whose value is required to match the value of the primary key for a second table? Question options: secondary key field key backup primary key
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
none of the above

Related Documents

MGAC10 Case Assignment Instructions 23F.pdf
Saumil_HW05_CS514-1.pdf
SC_EX365_2021_CS1-3a_KenyaCruz_Report_1.xlsx
7710_-_ICS_3.docx
202201-midterm-1.pdf
wa4.pdf
Copy of Lab 10 Instructions.docx
CS-255 1-2 Discuss Systems Development Lifecycle and Collecting Requirements Strategies.docx
Case Study 4(1) (1).docx
CS 255 Module Two Assignment Template.docx
Cs-255 4-2 Evaluate a Process Model.docx
CS-255 3-1 Discussion Process Models.docx
Recommended textbooks for you
Text book image
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Text book image
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
Text book image
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Text book image
Fundamentals of Information Systems
Computer Science
ISBN:9781305082168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
SEE MORE TEXTBOOKS
Recommended textbooks for you
Text book image
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Text book image
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
Text book image
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Text book image
Fundamentals of Information Systems
Computer Science
ISBN:9781305082168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
SEE MORE TEXTBOOKS