Stored Function
A stored function is a special kind stored program that returns a single value. you use stored functions to encapsulate common formulas or ...
Showing posts with label DATABASE1. Show all posts
Showing posts with label DATABASE1. Show all posts
June 01, 2020
Aggregate function
Aggregate functions are use to compute against a "returned column of numeric data" from your select statement. They basically s...
Friday, May 15, 2020May 15, 2020
System analysis
System analysis is used when design a new computer system to replace manual system or an alter computer system. In order to design it is...
Tuesday, May 12, 2020May 12, 2020
What is Database INDEX?
Indexes are special lookup tables that the database search engine can use to speed up data retrieval. simply put, an index is a pointer to d...
May 12, 2020
What is view?
It is a virtual table.. A view in SQL terminology is a single table that is derived from other tables. These other tables can be base t...
Tuesday, May 5, 2020May 05, 2020
DBMS Locking
Locking - A process in which any data that retrieved by a user for updating must be locked (or denied to other user) until the update is co...
May 05, 2020
Backup Recovery facilities
Backup facilities - which provide periodic backup(some time called fallback) copies of portion of entire database. Journalizing facilities...
May 05, 2020
DBMS Concurrency Control
The process of managing simultaneous operation against a database so that data integrity is maintained and operation do not interfere with ...
Monday, May 4, 2020May 04, 2020
Data Models
Data Models There are different types of the data models and now let see each of them in detail... file based model Hierarchical mode...
Tuesday, April 28, 2020April 28, 2020
Advantages of DBMS
Advantages of DBMS Controlling data redundancy Data consistency Integration of data Data security Report writers Backup recovery pr...
Subscribe to:
Posts (Atom)
