Which of the following commands will return the location of database customer360?

Which of the following commands will return the location of database customer360?
A . DESCRIBE LOCATION customer360;
B . DROP DATABASE customer360;
C . DESCRIBE DATABASE customer360;
D . ALTER DATABASE customer360 SET DBPROPERTIES (‘location’ = ‘/user’};
E . USE DATABASE customer360;

View Answer

Answer: C

Explanation:

To retrieve the location of a database named "customer360" in a database management system like Hive or Databricks, you can use the DESCRIBE DATABASE command followed by the database name.

This command will provide information about the database, including its location.