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 DATABASE2. Show all posts
Showing posts with label DATABASE2. 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
Severs
Central computer used to facilitate communication and resource sharing between other computers or the network. To function as a server a ...
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...
April 28, 2020
Type of SQL commands
Type of SQL commands SQL languages its commands on the basis of functionalities performed by them. there are five types of SQL language w...
Saturday, April 25, 2020April 25, 2020
What is a table?
The data in an RDBMS is stored in database objects which are called as tables. This table is basically a collection of related data en...
April 25, 2020
What is RDBMS??
A relational database management system(rdbms) is a database management system. that is based on the relational model. Example of RDBMS ...
April 25, 2020
What is SQL??
SQL stand for structured query language.. SQL is used to communicate with database its main aim to store, access and manipulate data...
Subscribe to:
Posts (Atom)
