Interview Question

In my previous blog , I have written about the future of oracle dbs jobs. If you are going for sql or oracle interview then most of the interviewer expect that you should know the difference between delete and truncate in oracle database. let’s see the difference between delete and truncate statement in oracle database. […]

Var keyword is just similar to variable declaration in Java whereas Val is little different. Once a variable is declared using Val the reference cannot be changed to point to another reference. This functionality of Val keyword in Scala can be related to the functionality of java final keyword. Val refers to immutable declaration of […]

In this bog, I will explain you how the user management work in oracle 12c. Starting from Oracle 12C there are two types of user. Common User Local User Common User Common user have the access to all PDB except seed pdb Common user start with C## prefix SYS and SYSTEM are the common user […]

Hive Partitions Create Hive Partition Table Create non-partition table Load data to non-partition table Set the Hive property Load data from non-partition to partition table Show All Partitions on Hive Table Add New Partition to the Hive Table Rename or Update Hive Partition Manually Renaming Partitions on HDFS When you manually modify the partitions directly […]