Why might an organization use a view instead of giving direc…

Why might an organization use a view instead of giving direct access to a full table? To permanently delete unnecessary data To automatically increase query performance To restrict access to only part of the table To replace the need for indexes Answer: To restrict access to only part of the table Explanation: Views can hide sensitive columns or rows, allowing controlled access. They don’t automatically boost performance, delete data, or replace indexes.

A bank has an accounts table with (account_id, holder_name,…

A bank has an accounts table with (account_id, holder_name, balance). They want to add a new account with ID 5001, holder name Emma, and starting balance 1000.00. Which SQL is correct? INSERT accounts VALUES (5001, ‘Emma’, 1000.00); INSERT INTO accounts VALUES (5001, ‘Emma’, 1000.00); ADD INTO accounts (5001, ‘Emma’, 1000.00); UPDATE accounts (5001, ‘Emma’, 1000.00); Answer: INSERT INTO accounts VALUES (5001, ‘Emma’, 1000.00); Explanation: The correct syntax is INSERT INTO … VALUES. The others misuse SQL commands (INSERT, ADD, UPDATE).