CACHE is multidimensional and postconsonantal database and its supporting scripting
SQL*PLUS is a interface between user and Oracle database. It Provide an environment to use the SQL which is a query language to communicate with oracle database
sql exception which provides information on database access errors where as sql warning provides inforamation on database access warnings.
Database Buffer cache is one of the most important components of System Global Area (SGA). Database Buffer Cache is the place where data blocks are copied from datafiles to perform SQL operations.
in sql commit is used for saving the changes made in database and roll back is to roll back them , changes will not get saved in the database
SQL is a query based language that is used to manipulate data stored in a database while other languages process data.
SQL is not Database, it is a Language used to communicate with Database...
grant will give permission to the user on database by using revoke we can remove the permission
In Oracle Database, the shared pool typically consists of two main memory areas: the library cache and the data dictionary cache. The library cache contains shared SQL and PL/SQL areas, including executable code and parsed representations of SQL statements. The data dictionary cache stores data definitions and query results for quick access.
SQL is a universal query language used to access relational data. MySQL is a database storage engine which utilizes the SQL query language as the means to interface with the data stored.
SQL Server is Microsoft's relational database product. SQL*Plus is the command line tool to access Oracle's database product.
Stored procedures prevent unauthorized access to data
facebook uses "NO SQL" database "NO SQL" name is derived from first letters of NOT ONLY SQL