WGU D426 Final Exam Review

WGU D426 Final Exam Review

1. What Is a software that reads and writes data in a database?: Database management system or DBMS 2. What is a computer programming language for writing database queries?- : Query language 3. What is a command for a database that typically inserts new data, retrieves data, updates data, or deletes data from a database: Query 4. What is a group of queries that must be either completed or rejected as a whole?: A transaction 5. What Interprets queries, creates a plan to modify the database or retrieve data, and returns query results to the application?: A query processor 6. What translates the query processor instructions into lowlevel file-system commands that modify or retrieve data?: Store Manager 7. What ensures transactions are properly executed?: Transaction Manager 8. What is a file containing a complete record of all inserts, updates, and deletes processed by the database?: The log 9. What is a directory of tables, columns, indexes, and other database ob- jects?: Catalog 10. What is a column, used to identify individual rows of a table?: A key 11. Which phase implements database requirements in a specific database system?: Database Logical design phase 12. Which phase specifies database objects such as tables, columns, data types, and indexes?: Database design phase 13. Which phase specifies database requirements without regard to a specific database system?: Database analysis phase 14. Which phase adds indexes and specifies how tables are organized on storage media?: Database physical design phase 15. What is the name of a leading relational database system that sponsored by Oracle?: MySQL 16. What is a conceptual framework for database systems, with three parts?- : Database model 17. In a database model, what prescribes how data is organized?: Data struc- tures 18. In a database mode, what manipulates data structures?: Operations 19. In a database mode, what governs valid data?: Rules 20. What command selects a subset of rows of a table?: Select 21. What command eliminates one or more columns of a table?: Project 22. What command lists all combination of rows of two tables?: Product 23. What command combines two tables by comparing related columns?: Join 24. What command selects all rows of two tables?: Union