🎴 Flashcard Mode
Database (DBMS) Quiz
Card1 / 10
Mastered0
Review0
QuestionClick to flip
You are managing the in-house database systems.You need to ensure that the user AMY can execute all operations against the SALES relation. What SQL statement sequence will you use?
AnswerClick to flip back
A
GRANT ALL PRIVILEGES ON TO
💡 Explanation:
The correct SQL syntax for granting privileges is GRANT [privileges] ON [object] TO [user]. Option D follows this structure correctly with placeholders for the relation name and username. Options A, B, C, and E have the keywords WHERE and FROM in wrong positions - WHERE and FROM are clauses used in SELECT/UPDATE queries, not in GRANT statements.