Download DAD 220 COMBINED STUDY SETS (DAD 220 - Quiz 2-2,DAD-220 Module 2,DAD 220 - 4-1 Quiz & DAD and more Exams Digital Systems Design in PDF only on Docsity!
DAD 220 COMBINED STUDY SETS (DAD 220 - Quiz 2-2,DAD-220 Module 2,DAD 220 - 4-1 Quiz & DAD 220 - Quiz 1-3) 100% VERIFIED
-DAD 220 - Quiz 2- -DAD-220 Module 2 -DAD 220 - 4-1 Quiz -DAD 220 - Quiz 1-
DAD 220 - Quiz 2- Which three of the following mathematical concepts does relational data derive from? Quiz Options A variable A domain A tuple A relation A table An equation - ANSWER A domain A tuple A relation Which of the following are relational operations? Quiz Options A join A boxed structure Projection Outer attachments Big data
Selection - ANSWER A join Projection Selection With relational databases, each discrete field space along a row and column holds just one value.
A table can have one or any number of columns and rows. A table that does not have any rows inside it is called an empty table.
Question options: True False - ANSWER True
What is database independence? Select one.
Question options: A database that can operate without a network Columns that align to form a vertical data order Rows and columns of a table that have no inherent order Data sets that are in perfect symmetry - ANSWER Rows and columns of a table that have no inherent order.
Which of the following are SQL operators? Select all that apply.
Question options: Arithmetic Variable False
Data type only Name and data type - ANSWER Name and data type
DAD-220 Module 2 Relational Model - ANSWER A model based on mathematical principle.
- A data structure that prescribes how data is organized
- Operations that manipulate data structures
- Rules that govern valid relational data
Domain - ANSWER A named set of possible database values, such as integers, dictionary words, or logical values
Tuple - ANSWER A finite sequence of values, each drawn from a fixed domain. Ex: (3, apple, True)
Relation - ANSWER A named set of tuples, all drawn from the same sequence of domains
Attribute - ANSWER Each tuple position is called an attribute and given a unique name
Mathematical Operations of Set Theory - ANSWER Union, Difference, Projection, Selection, Join, Product
Relational rules (integrity rules) - ANSWER Logical constraints that ensure data are valid and conform to business policy
Structural Rules - ANSWER Rules that all relational databases enforce: Unique primary key - each table must have a column with unique values Unique column names - any two columns in the same table have different names
No duplicate rows - no two rows of the same table have the same values in every column
Business Rules - ANSWER Relational rules for a given database and application: Unique column names - within a column, the values cannot repeat No missing values - within a column, all rows must have values known Delete cascade - when one row is deleted, all related rows will be automatically deleted
Relational Database Data Types - ANSWER Integer, decimal, character (varchar), time, binary, spatial, document
Data Independence - ANSWER Rows and columns of a table have no inherent order. Order is arbitrary and is not important in a database query
NULL - ANSWER Special value for missing data
DAD 220 - 4-1 Quiz
What does an attribute of a single instance of the entity have to have, to be a primary key?
Question options: There can be only one instance of the attribute.
There can be many instances of the attribute.
There can only be at most one instance of the entity that each instance of the attribute describes
There must be at least one instance of the attribute.
- Person-Assigned-SocialSecurityNumber - Maxima is One-One
- Birthdate-Recorded-for-a Person - Minima is One-Zero
- Women-Bearing-Children - Minima is Zero-Zero
A ride-sharing application's discount system for riders is designed such that a ride discount only triggers if at least two RiderIDs book a ride in the same CarID at the same time. Which one of the following is true about the relationship RideDiscount-is-Applicable? Choose one.
Question options: The relationship maximum is One-Two.
The relationship minimum is One-Two.
The relationship minimum is Many-One.
The relationship minimum is Two-One. - ANSWER The relationship minimum is One-Two.
Your nephew has an assignment to work on a database of NBA teams. He was given the following specifications:
- Each team belongs to one of two conferences: the Eastern Conference or the Western Conference.
- Teams in both conferences are named for cities or states.
- Some franchises have moved from one conference to the other.
He is seeking help in determining which entities and attributes to use. Which of the following would you suggest that he take from the options below?
Question options: NBA as supertype with Conference as subtype
Conference as subtype under Team as supertype
Team as subtype under Conference as supertype
City and State as subtypes under Team as supertype
TeamMoved as attribute of Conference subtype
cityName as attribute of Team supertype Conference as subtype under Team as supertype.
City and State as subtypes under Team as supertype. TeamMoved as attribute of Conference subtype. cityName as attribute of Team supertype. Your professor is working as a consultant with a new crowd funding app for women SHGs in Latin America. The following is the business requirement she has worked on: All the campaigns are of one SHG. A campaign must be for an existing SHG, and a deleted SHG must see all of its campaigns deleted along with it. SHGs belong to countries always, and before the app is populated with SHGs, countries should be added first. What among the following regarding the entities defined in this database? All that apply
Question options
False - ANSWER True
During a hackathon at your high school, the instructor had to remove students with scores under 60 points. 60 is just a number. The following is a sample of the scores.
Hackathon Table: ID-----Sturdent Name--Score 4367--Jane Smith-------- 4756--Samuel Heart----- 8789--Kim Parker--------
What is the correct SQL to delete those students with scores under 60 points?
Question options: DELETE FROM HACKATHON WHERE SCORE < '60';
DELETE FROM HACKATHON WHERE SCORE < 60;
DELETE WHERE SCORE = 60; - ANSWER DELETE FROM HACKATHON WHERE SCORE < 60;
DAD 220 - Quiz 1- Many websites are open-sourcing their data. Which of the following do it?
Data.gov Whitehouse.gov NYC Open Data National Cancer Institute
International Genetics Foundation Creditscore.com USPostalService.GOV - ANSWER Data.gov NYC Open Data National Cancer Institute
What are the four properties that are in a relational database that must be achieved for data to change based on a transaction?
ACID Properties to be met with RDBMS Transaction Atomicity Consistency Variability Isolation Cohesiveness Durability - ANSWER Atomicity Consistency Isolation Durability
Which of the following are parts of a database system? Check all that apply.
Question choices Query processor Storage manager Output mechanism Transaction manager - ANSWER Query processor
Question options: True False - ANSWER False
While installing MySQL, the user needs to specify a password for which account? Choose one.
Question options: Primary account Root account Database account Guest account - ANSWER Root account
Who defines the detailed design of the database?
Question options: Database administrator Database designer Database programmer Database users - ANSWER Database designer
A database designer and database user use SQL.
Question options: True False - ANSWER False
