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;

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.

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments