David Meador has Published 171 Articles

Hot Standby Mode

David Meador

David Meador

Updated on 22-Jun-2020 08:07:47

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

What is the difference between jQuery.animate() and jQuery.hide()?

David Meador

David Meador

Updated on 22-Jun-2020 08:05:11

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

Concurrency Control Using Locks in DBMS

David Meador

David Meador

Updated on 20-Jun-2020 09:43:06

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

DDBMS Advantages and Disadvantages

David Meador

David Meador

Updated on 20-Jun-2020 08:18:55

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

Conversion Functions in SQL

David Meador

David Meador

Updated on 20-Jun-2020 08:00:07

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

Data Independence in DBMS

David Meador

David Meador

Updated on 20-Jun-2020 07:21:17

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

Date and Time Functions in DBMS

David Meador

David Meador

Updated on 19-Jun-2020 14:23:27

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

SELECT Statement and its Clauses in DBMS

David Meador

David Meador

Updated on 19-Jun-2020 14:13:22

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

Spatial Databases

David Meador

David Meador

Updated on 19-Jun-2020 11:35:00

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

Data Manipulation Commands in DBMS

David Meador

David Meador

Updated on 19-Jun-2020 11:03:04

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

Advertisements