9)To identify which database the user is using in HIVE SHELL ?

To achive that, we need set the hive.cli.print.current.db property to true.

This can be done two ways:

1)Temporary solution:
    On the HIVE SELL prompt executing this command
       hive>set hive.cli.print.current.db=True

2)Permenant solution
    Adding this property in hive-site.xml file under $HIVE_HOME/conf folder
      <property>
           <name>hive.cli.print.current.db</name>
            <value>true</value>
            <description>Whether to include the current database in the Hive prompt</description>
       </property>