
Ultimate access to all questions.
A data engineer created a database named employees with the command CREATE DATABASE employees LOCATION ‘/employees‘. Later, a junior data engineer created a test database named new_employees using the same location with CREATE DATABASE new_employees LOCATION ‘/employees‘. After testing, the junior engineer drops the new_employees database. What happens to the data in both databases?_
A
Creating new_employees with the same location as employees is not allowed._
B
Databases sharing the same location cannot be dropped.
C
Dropping new_employees deletes its data, while employees data remains unaffected._
D
All data in both databases will be deleted.
E
No data is deleted, but the DROP command succeeds.