D426 WGU Notes || with 100% Error-free Answers.

Database application correct answers software that helps business users interact with database systems Database administrator correct answers responsible for securing the database system against unauthorized users, enforces procedures Authorization correct answers limits user access Rules correct answers database systems ensure data is consistent with structural and business rules Query processor correct answers interprets queries, creates plan to modify database/retrieve data, and returns query results Query optimization correct answers performed by query processor to ensure most efficient instructions are executed Indexes correct answers quickly locate data transaction manager correct answers ensures transactions are properly executed, prevents conflicts between concurrent transactions, restores database to consistent state INSERT correct answers insert rows into a table SELECT correct answers retrieves data from a table UPDATE correct answers modifies existing rows in a table - Uses SET clause for new column values - Uses WHERE clause for which rows to update, or updates all rows DELETE correct answers deletes rows from a table - FROM follows table name - Use WHERE for which rows to delete, or delete all rows CREATE TABLE correct answers creates new table by specifying the table and column names, and column data types INT (data type) correct answers stores integer values DECIMAL (data type)(M,D) correct answers stores fractional numeric values; numerical with M digits, D digits is decimal point VARCHAR (data type) correct answers stores textual values, values with 0 to N characters