WGU - D426: Objective Assessment exam Already Passed!!

Software that helps business users interact with database systems. - Answer-Database Application Responsible for securing the database system against unauthorized users. A database administrator enforces procedures for user access and database system availability. - Answer-Database Administrator Many database users should have limited access to specific tables, columns, or rows of a database. Database systems authorize individual users to access specific data. - Answer-Authorization Database systems ensure data is consistent with structural and business rules. - Answer-Rules Interprets queries, creates a plan to modify the database or retrieve data, and returns query results to the application. Performs query optimization to ensure the most efficient instructions are executed on the data. - Answer-Query Processor Translates the query processor instructions into low-level file-system commands that modify or retrieve data. Database sizes range from megabytes to many terabytes, so the storage manager uses indexes to quickly locate data. - Answer-Storage Manager Ensures transactions are properly executed. The transaction manager prevents conflicts between concurrent transactions. The transaction manager also restores the database to a consistent state in the event of a transaction or system failure. - Answer-Transaction Manager Data about the database, such as column names and the number of rows in each table. - AnswerMetadata Stores data in tables, columns, and rows, similar to a spreadsheet. - Answer-Relational Database All _________ ________ systems support the SQL query language. - Answer-Relational Database Relational systems are ideal for databases that require an accurate record of every transaction, such as banking, airline reservation systems, and student records. - Answer-Relational DatabaseThe newer non-relational systems are called NoSQL, for 'not only SQL', and are optimized for big data. - Answer-MongoDB (NoSQL) INSERT inserts rows into a table. SELECT retrieves data from a table. UPDATE modifies data in a table. DELETE deletes rows from a table. - Answer-SQL Statements