DAD_220_-_1-3_QUIZ
docx
keyboard_arrow_up
School
Southern New Hampshire University *
*We aren’t endorsed by this school
Course
220
Subject
Information Systems
Date
Apr 3, 2024
Type
docx
Pages
5
Uploaded by AdmiralAlbatrossPerson792
Question 1 2 / 2 points Many websites provide open-source data about science, technology, engineering, and math. Which of these sites provide open-source data to the public? Select all that apply. ~ Data.gov Whitehouse.gov ~ NYC Open Data ~ | National Cancer Institute International Genetics Foundation Creditscore.com USPostalService.GOV w Hide question 1 feedback Data.gov, NYC Open Data, and National Cancer Institute all provide open-source data.
Question 2 2 / 2 points In a relational database, what must be true when processing transactions? Allow partial processing of transactions | Ensure transactions are processed completely or not at all +~ Ensure transaction results are never lost ~ Prevent conflicts between concurrent transactions Prioritize transaction speed over data consistency w Hide question 2 feedback In a relational database, the following is true of processing transactions: ensure transactions are processed completely or not at all, prevent conflicts between concurrent transactions, and ensure transaction results are never lost. Question 3 2 / 2 points Which of the following are components of a database system? Select all that apply. | Query processor ~ Storage manager Output mechanism ~ | Transaction manager w Hide question 3 feedback A database system has the following components: query processor, storage manager, and transaction manager.
Question 4 2 / 2 points Structured Query Language (SQL) is a popular query language used to communicate with a database system. e True False w Hide question 4 feedback SQL is a popular query language used to communicate with a database system. Question 5 2 / 2 points The MySQL command-line client is a command-line application that allows developers to connect to a MySQL server, perform administrative functions, and execute SQL statements. o True False w Hide question 5 feedback 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.
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
Question 6 2 / 2 points What is a database management system (DBMS)? Select one. A system that provides additional functionality to gather data and identify trends in data A software application that interacts between two databases A collection of data structures that comprise related data values e A software application that supports data organization in a database w Hide question 6 feedback A database management system is a software application that supports data organization in a database. Question 7 2/ 2 points SQL contains four statements for a database command. True e False w Hide question 7 feedback SQL contains four primary statements—insert, retrieve, update, and delete—but it also has many other statements.
Question 8 2 / 2 points When installing MySQL, which account must the user enter a password for? Select one. # Root account Primary account Guest account Database account w Hide question 8 feedback When installing MySQL, the user must enter a password for the root account. Question 9 2 / 2 points Which role is responsible for defining the detailed database design? Database administrator e Database designer Database programmer Database users Question 10 2 / 2 points A database designer and database user both use SQL. e True False