Download Database Management and SQL Quizzes: Test Your Knowledge and more Exams Computer Science in PDF only on Docsity!
SNHU DAD 220 Intro to Structure Database
Environment Module 1 - 4 Actual Quizzes |
100% Correct Answers | Verified Version
DAD 220 - 1 - 3 Quiz Many interesting science-, technology-, engineering-, and math-oriented websites provide open-source data to the public. Which of the following sites provide that information? Select all that apply. - ✔✔DATA.GOV NYC Open Data National Cancer Institute What four properties must be achieved for transactions to change data in a relational database? Select all that apply. - ✔✔ Atomicity Consistency Isolation Durability Which of the following are components of a database system? Select all that apply - ✔✔ Query Processor Storage manager Transaction manager True or false: Structured Query Language (SQL) is a popular query language used to communicate with a database system. - ✔✔True True or false: The MySQL command-line client is a command-line application included in the MySQL installation that allows developers to connect to a MySQL server, perform administrative functions, and execute SQL statements. - ✔✔True
What is a database management system (DBMS)? Select one. - ✔✔A software application used to support data organization in a database Which of the following options listed in the readings are identified as factors that may impact database performance? Select all that apply. - ✔✔Workload Throughput Resources In two-tier architecture, what database components are present? Select all that apply. - ✔✔Client Server True or false: SQL contains four statements for a database command. - ✔✔False When installing MySQL, which account must the user enter a password for? Select one. - ✔✔Root account DAD 220 - Quiz 2- 2 Relational data is based on which three mathematical concepts? Select all that apply. Question options: A variable A domain A tuple A relation A table An equation - ✔✔A domain A tuple A relation
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 - ✔✔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 Upwards Comparison Logical - ✔✔Arithmetic Comparison Logical NULL represents either "unknown" or "inapplicable." Question options: True False - ✔✔True What is big data? Select one. Question options: The future of systemic thinking Massive volumes of online data Algorithmic code that sifts through large amounts of information
The product of an unregulated internet - ✔✔Massive volumes of online data In the relational data structure, which components are named? Question options: Data type, row, table Data type, table Data type, table, column - ✔✔Data type, table, column What are the components of a column? Question options: Name only Data type only Name and data type - ✔✔Name and data type DAD 220 - 3 - 1 Quiz Your cousin, a senior in high school, asks you to play a Jeopardy-style game with her to help prepare for her computer science exam next week. She gives you these two clues about a type of relational database key: No column values may be NULL, and columns may be combined to create a unique primary key. Which type of key is she referring to? Select one. - ✔✔Composite primary key During a water cooler chat, your colleague claims that both data types and names of foreign and primary keys must be the same. Is this true or false? - ✔✔False Four actions that can be implemented on a database to autocorrect violations of referential integrity, and the outcomes of the actions are listed below. Match the violation with the corrective action. Instructions: Choose your responses from the drop-down menus below. Response options cannot be used more than once. - ✔✔Sets invalid foreign keys to NULL - Set Null
Only matching left and right table rows - Inner join Only matching right table rows but all left table rows - Left join All left and right table rows, regardless of match - Full join Your coworker has decided to take an online course about the basics of databases so that he can improve his job performance. As you study with him at lunch, he says that he thinks attributes are essential in an ER diagram. Is this true or false? - ✔✔False If you needed the database to select values in a specific order but order them in ascending order, which of the following clauses should you use along with the SELECT command? Select one. - ✔✔Order by DAD 220 - 4 - 1 Quiz To be used as a primary key, which of these characteristics must an attribute have in a single instance of the entity? Select all that apply. Question options: There must be a maximum of one attribute instance. There must be many instances of the attribute. There must be at most one entity instance that each attribute instance describes. There must be at least one instance of the attribute. There must be zero or more instances of the attribute. - ✔✔There must be a maximum of one attribute instance. There must be at most one entity instance that each attribute instance describes. There must be at least one instance of the attribute.
A singular attribute is also known as a unique attribute. Question options: True False - ✔✔False In the list below are relationship names and types of relationship maxima or minima that each could have. Match each relationship in the list below to the type of relationship maxima or minima. Instructions: Choose your responses from the drop-down menus below. Responses can only be used once. _____ Maxima is One-Many _____ Maxima is One-One _____ Minima is One-Zero _____ Minima is Zero-Zero
- Person-Assigned-SocialSecurityNumber
- CubicleNumber-Assigned-to-Employee
- Birthdate-Recorded-for-a Person
- Women-Bearing-Children - ✔✔2. CubicleNumber-Assigned-to-Employee - Maxima is One-Many
- 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 app's discount system for riders is made so a ride discount only initiates if at least two RiderIDs book a ride in the same CarID at the same time. Which of the following answers is true of the relationship RideDiscount-is-Applicable? Select one.
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 advising a new crowd-funding app for women's self-help groups (SHGs) in Latin America on their database architecture. This is the business requirement she has worked on: All campaigns belong to a SHG. An SHG must exist before a campaign is created, and when an SHG is deleted from the database, all its campaigns are deleted. SHGs always belong to a country, and a country must be added to the app before SHGs are added to it. Which of the following is true of the entities defined in the database? Select all that apply. Question options: An SHG entity depends on a Campaign entity A Campaign entity is a depend on the SHG entity A Country is not dependent on the Campaign entity An SHG entity is dependent on a Country entity A Campaign is an Independent entity - ✔✔ If you wanted to delete the UNIQUE constraint called ChildAge from the table Children, which statement should you use? Select one.
Question options: ALTER TABLE Children DELETE ChildAge; ALTER TABLE ChildAge DROP CONSTRAINT Customer; ALTER TABLE Customer DROP CONTRAINT ChildAge; DELETE TABLE Children DELETE ChildAge; - ✔✔ Dropping a table fails when a foreign key constraint refers to the table's primary key. Before dropping the table, either the foreign key constraint or the foreign key table must be dropped. Question options: True False - ✔✔True While in a hackathon at your high school, the instructor had to remove students with scores under 60 points. 60 is a number. The following is a sample of the scores. Hackathon Table: ID-----Sturdent Name--Score 4367 --Jane Smith-------- 70 4756 --Samuel Heart----- 56 8789 --Kim Parker-------- 97 What is the correct SQL to delete those students with scores under 60 points? Question options: DELETE FROM HACKATHON WHERE SCORE < '60';
4. SELECT CONCAT (FRANCHISENAME, CITY) FROM SUPERBOWLSTATS WHERE GAMEPLAYER > 45000 -
✔✔1. CHICAGOMARAUDERS
2. SAINT LOUIS
3. ST
4. PACERSCLEVELAND
True or False: A logical operator always evaluates to null when one or bother operands are null - ✔✔false Which of these are true about null values? Select all that apply. - ✔✔A null value is different from a zero value or an empty string. One NULL is never equal to another.
- The wildcard character %
- The wildcard character _
- LIKE by default
- LIKE followed by BINARY - ✔✔1. To match any number of characters
- To match exactly one character
- To conduct a case-insensitive pattern match
- To conduct a case-sensitive pattern match
