NETCA vs DBCA In ORACLE, there are configuration assistants for separate tasks. NETCA and DBCA are two of the very important assistants. These assistants are Graphical User Interfaces (GUIs), which can be easily used. What is NETCA? NETCA stands for NET Configuration Assistant. This is a JAVA based GUI tool in ORACLE. NETCA is […]
Difference Between Oracle Standard Edition (SE) and Enterprise Edition (EE)
Oracle Standard Edition (SE) vs Enterprise Edition (EE) ORACLE database products are in five different editions. Each of these editions has a set of features related to performance, availability, scalability, and security areas. ORACLE EE contains all of those features and other editions have lesser features set. Here, are the available editions, 1. ORACLE […]
Difference Between BCNF and 4NF (4th Normalization)
BCNF vs 4NF (4th Normalization) Database normalization is a technique, which is dealing with relational database management systems. Data errors can be avoided in a well normalized database. Normalization is used to reduce the data redundancy of the database. That means implementing database tables and their relationships, eliminating redundancy and inconsistent dependency. There are […]
Difference Between ORACLE Export (exp) and Datapump (expdp)
ORACLE Export (exp) vs Datapump (expdp) ORACLE provides two external utilities to transfer database objects from one database to another database. Traditional exports (exp /imp) are introduced before 10g. Then from 10g, ORACLE introduced datapump (expdp / impdp) as an enhancement to traditional export utility. Traditional Export (exp/ imp) This is an ORACLE database […]
Difference Between Active and Passive FTP
Active vs Passive FTP FTP stands for File Transfer Protocol. It is a standard protocol, which is used in file transferring from one host to another host over a TCP based network. FTP has client-server architecture, and it operates on OSI model of the application layer. There are four data representation modes when transferring […]