CS 514 Final Exam Study Questions

CS 514 Final Exam Study Questions
The analysis phase of database design includes which process?
Specifying requirements that are not dependent on a specific database system.
When data is produced and stored as numeric, textual, or visual information, it varies in
_____.
Format
A database designer installs MySQL Community Edition to create a database. Which
account does the designer use to gain full control of MySQL?
Root
What does a user that interacts with a database use to read and write data?
Query language
Which option is found on the Schemas tab in MySQL Workbench?
A list of available databases.
The _____ SQL statement does not alter any database data.
SELECT
What design consideration would apply to a database that has special performance
requirements?
Structuring data properly on storage media.
What links a host programming language to a database system?
API
A database _____ is the implementation of database requirements in SQL with
CREATE TABLE statements.
Schema
If a database system is processing three queries as part of a transaction and the third
query fails, what happens to the transaction?
The successful query results are reversed, and the transaction is canceled.
A database management system reads and writes data in a database, and _____.
ensures consistency and availability
When using the MySQL Command-Line Client, which character ends a command?

CS 514 Exam,CS 514 Test,CS 514 Flashcard,CS 514 quiz,CS 514 Practice,CS 514 Practice test,CS 514 Practice flashcard,CS 514 Practice exam,CS 514 Study guide,CS 514 Practice questions,CS 514 Questions,CS 514 Practice questions and answers,CS 514 Questions and answers,CS 514 pdf,CS 514 quizlet,CS 514 reddit,CS 514 Answer sheet,CS 514 Answer key,CS 514 Pdf free,CS 514 Exam help,CS 514 Cheat sheet,CS 514 quiz bank,CS 514 Questions bank,CS 514 Practice Guide,CS 514 Guide,CS 514 Testbank,CS 514 Practice Answers,CS 514 Answers,CS 514 Exam prep,CS 514 Prep,CS 514 Pdf download,CS 514 Flashcards,CS 514 Real questions,CS 514 Actual questions,CS 514 Real Questions and answers,CS 514 Actual Questions and answers,CS 514 Exam review,CS 514 Review,CS 514 Exam questions,CS 514 Exam questions and answers,CS 514 Practice test pdf,CS 514 Practice test quizlet,CS 514 Practice test Reddit,CS 514 Practice test quizlet multiple choice,CS 514 Exam study guide,CS 514 Practice test free,CS 514 Test questions,CS 514 Exam study guide,CS 514 Practice exam free,CS 514 Practice tests free,CS 514 Exam practice test,CS 514 Exam test questions,CS 514 Exam questions and answers,CS 514 Exam practice test