- Trending Categories
- Data Structure
- Networking
- RDBMS
- Operating System
- Java
- MS Excel
- iOS
- HTML
- CSS
- Android
- Python
- C Programming
- C++
- C#
- MongoDB
- MySQL
- Javascript
- PHP
- Physics
- Chemistry
- Biology
- Mathematics
- English
- Economics
- Psychology
- Social Studies
- Fashion Studies
- Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
David Meador has Published 171 Articles
David Meador
558 Views
The hot standby mode is a fail-safe in which a hot standby component is part of an active system. If any component of the system fails, the hot standby component takes its place. In general, a hot standby can refer to any device, system etc. that overtakes operation from a ... Read More
David Meador
195 Views
jQuery animate()The animate( ) method performs a custom animation of a set of CSS properties.Here is the description of all the parameters used by this method −params − A map of CSS properties that the animation will move toward.duration − This is optional parameter representing how long the animation will ... Read More
David Meador
10K+ Views
Locks are an integral part to maintain concurrency control in DBMS. A transaction in any system implementing lock based concurrency control cannot read or write a statement until it has obtained the required locks.There are two types of locks in Lock based protocols. These are:Binary Locks - These can only be ... Read More
David Meador
14K+ Views
The distributed database management system contains the data in multiple locations. That can be in different systems in the same place or across different geographical locations.As shown in the below example −The database is divided into multiple locations and stores the data in Site1, Site2, Site3 and Site4.The advantages and ... Read More
David Meador
1K+ Views
There may be times when the SQL query was expecting some data type but it got another. In that case type conversion is done by SQL. This is implicit type conversion. However, sometimes the programmer explicitly converts one data type into another in a query. This is known as explicit ... Read More
David Meador
2K+ Views
A database contains a large amount of data. Not all of that data is user data, some of it can be metadata etc. So, it is very important that a database has data independence.Data independence basically means that if data is changed at a level, it does not impact the ... Read More
David Meador
4K+ Views
The date and time functions in DBMS are quite useful to manipulate and store values related to date and time.The different date and time functions are as follows −ADDDATE(DATE, DAYS)The numbers of days in integer form (DAYS) is added to the specified date. This is the value returned by the ... Read More
David Meador
3K+ Views
The select statement is used to get the required data from the database according to the conditions, if any. This data is returned in the form of a table.The basic syntax of the select statement is −Select column 1, column 2 ... column N From table_nameAn example of the select ... Read More
David Meador
15K+ Views
Spatial data is associated with geographic locations such as cities, towns etc. A spatial database is optimized to store and query data representing objects. These are the objects which are defined in a geometric space.Characteristics of Spatial DatabaseA spatial database system has the following characteristicsIt is a database systemIt offers ... Read More
David Meador
8K+ Views
Data manipulation commands are used to manipulate data in the database.Some of the Data Manipulation Commands are-SelectSelect statement retrieves the data from database according to the constraints specifies alongside.SELECT FROM WHERE GROUP BY HAVING ORDER BY General syntax −Example: select * from employee where e_id>100;InsertInsert ... Read More