Basic Database Administration
Database administration refers to the whole set of activities performed by a database administrator to ensure that a database is always available as needed. Other …
Read MBA, BBA, B.COM Notes
Database administration refers to the whole set of activities performed by a database administrator to ensure that a database is always available as needed. Other …
Remote database access (RDA) is a protocol standard for database access. Despite early efforts to develop proof of concept implementations of RDA for major commercial …
There is a huge amount of data available in the Information Industry. This data is of no use until it is converted into useful information. …
Some people don’t differentiate data mining from knowledge discovery while others view data mining as an essential step in the process of knowledge discovery. Here …
PL/SQL package is a logical grouping of a related subprogram (procedure/function) into a single element. A Package is compiled and stored as a database object …
A function is a subprogram that is used to return a single value. You must declare and define a function before invoking it. It can …
A procedure is a group of PL/SQL statements that can be called by name. The call specification (sometimes called call spec) specifies a java method …
Triggers are stored programs that are fired automatically when some events occur. The code to be fired can be defined as per the requirement. Oracle …
A cursor is a pointer to a private SQL area that stores information about the processing of a SELECT or DML statements like INSERT, UPDATE, …
Unique and Nonunique IndexesUnique indexes guarantee that no two rows of a table have duplicate values in the key column (or columns).For performance reasons, Oracle …