Docsity
Docsity

Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity


Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan


Guidelines and tips
Guidelines and tips

DAD 220 COMBINED STUDY SETS (DAD 220 - Quiz 2-2,DAD-220 Module 2,DAD 220 - 4-1 Quiz & DAD, Exams of Digital Systems Design

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

Typology: Exams

2024/2025

Available from 01/23/2025

Smartsolutions
Smartsolutions šŸ‡ŗšŸ‡ø

2.3

(3)

11K documents

1 / 14

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
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-2
-DAD-220 Module 2
-DAD 220 - 4-1 Quiz
-DAD 220 - Quiz 1-3
DAD 220 - Quiz 2-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
pf3
pf4
pf5
pf8
pf9
pfa
pfd
pfe

Partial preview of the text

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.

  1. A data structure that prescribes how data is organized
  2. Operations that manipulate data structures
  3. 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.

  1. Person-Assigned-SocialSecurityNumber - Maxima is One-One
  2. Birthdate-Recorded-for-a Person - Minima is One-Zero
  3. 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