Computer Science > EXAM > Intro to SQL Final Exam Study Guide WITH COMPLETE SOLUTION (All)
Intro to SQL Final Exam Study Guide WITH COMPLETE SOLUTION
Document Content and Description Below
What type of relationship exists between this pair of related entities? BOOK and BOOK COPY (books have copies) Correct Answer: one-to-many Storing the same data in more than one place is calle ... d ____. Correct Answer: redundancy Customers, cars, and parts are examples of: Correct Answer: entities An association between entities is known as a ____. Correct Answer: relationship A visual way to represent a database is with a ____. Correct Answer: entry-relationship diagram Popular ____ include Access, Oracle, DB2, MySQL, and SQL Server. Correct Answer: DBMSs (Data Base Management Systems) A person's name, birthday, and social security number are all examples of: Correct Answer: attributes ________ are established between entities in a well-structured database so that the desired information can be retrieved. Correct Answer: Relationships ____ are screen objects used to maintain, view, and print data from a database. Correct Answer: Forms An integrity constraint is a rule that ____. Correct Answer: data must follow in the database ____ is the prevention of unauthorized access to the database. Correct Answer: Security A person, place, an object , an event or concept about which the organization wishes to maintain data is called a: Correct Answer: Entity A ____ is a characteristic or property of an entity. Correct Answer: Attribute The ____ of an entity become the columns in the database table. Correct Answer: attributes A database has ____ if the data in it satisfies all established integrity constraints. Correct Answer: Integrity ________ is a property that lets you change the structure of the database without requiring you to change the programs that access the database Correct Answer: Data independence When duplicate column names exist in a database and you need to indicate the column to which you are referring, ____. Correct Answer: write both the table name and the column name, separated by a period [Show More]
Last updated: 3 years ago
Preview 1 out of 10 pages
Buy this document to get the full access instantly
Instant Download Access after purchase
Buy NowInstant download
We Accept:
Reviews( 0 )
$6.00
Can't find what you want? Try our AI powered Search
Document information
Connected school, study & course
About the document
Uploaded On
Oct 21, 2022
Number of pages
10
Written in
All
Additional information
This document has been written for:
Uploaded
Oct 21, 2022
Downloads
0
Views
67
