-
-
What is Oracle Net Services
Oracle Net Services provides enterprise-wide connectivity solutions in distributed, heterogeneous computing environments. Oracle Net Services eases the complexities of network configuration and management, maximizes performance, and improves network diagnostic capabilities. Oracle Net, a component of Oracle Net Services, enables a network session from client application to an Oracle database server....
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
What is codd’s rules?
E.codd designed 12 rules that stated rules for database to be relational. These rules were named as codd’s rules. The rules are given below: 1. The Information Rule: For a database to be relational all information is represented as data values in tables. 2. The Rule of Guaranteed Access: The data represented in table by using table name, column name and primary key value defined for that table....
-
What is DECODE function used for?
DECODE is used to decode a CHAR or VARCHAR2 or NUMBER into any of several different character strings or numbers based on value. That is DECODE does a value-by-value substitution. For every value that is given in the DECODE function it makes an if then check and matches the value. The general format of DECODE function is given below:
DECODE(value,if1,then1,if2,then2,……,else)... -
Why is performance tuning a vital aspect in Oracle?
Tuning is one of the main function or job of a database administrator or DBA in short. This is because oracle is a relational database management system which is tunable and thus the database can be monitored and therefore appropriate measures and steps can be taken at appropriate times to increase the performance of the system. There are many reasons for performing the performance tuning in oracle....
Oracle Basics Interview Questions
Ans