MCQs Test!! VB Basic Test !! Essentials of VB !! Creating User Services !! function !! Anatomy !! GK March-2019 !! DATA TYPES IN JAVA !! Classes ,Constructor ,Methods,Inheritance !! Ecology-I !! Biology 2019 !! Gk april 2019 !! Biology (living world) !! Plant anatomy !! CELL STRUCTURES AND FUNCTION !! General biology !! Human physiology !! Data structure !! Ecology-II !! GK TEST !! Reproduction in plants !! Human reproduction !! The ABC of C !! Operating system set1 !! Operating system set2 !! Gk and current affairs !! Animal kingdom !! Number system !! Animal kingdom-II !! Gk TEST-III !! Number series !! Microorganisms !! Interview question in c !! Time and Work !! Percentage !! General history !! Average !! Cells !! Locomotion and Movement !! paging !! Bacteriology !! Page replacement policy !! Secondary memory and Disk scheduling !! Introduction of Nervous System and neurons !! Plant harmones !! Transport and Mineral Nutrition in Plants !! Neurotransmitters !! Modern Indian History !! Photosynthesis in Plants !! Modern Indian History-II !! Plant respiration !! Environment & Biodiversity !! Environment & Biodiversity - II !! Algae, Bryophytes, Pteridophytes !! Area !! Cricket !! Days of the Year (India and the World) !! Plant Pathology - I !! Indian Transport System !! Plant Pathology - II !! Aptitude !! Biology !! Botany !! C language !! Computer Science !! Core Java !! Gate !! GK !! Mysql !! Operating system !! Physics !! VB-Visual Basic !! Zoology

DATABASE & SQL/PLSQL

Introduction (SQL)
Previous Home Next

MS SQL Server

  1. Fully Web Enabled.
  2. You can use HTTP to send queries to the server. It provides various feature and facility to accesses data on web.
  3. Highly Scalable and Reliable.
  4. SQL sever use scale up and scale out feature to fulfill requirement . In Scale up SQl server use 32 bit Processors and 64GB of RAM to increase the load. In scale out SQL distribute database and data load across the server. When suddenly system crash ,RDBMS recover data quickly with minimum loss. This feature called reliability.

 

Client Server Architecture (Two Tier Architecture)

SQL
  1. Language to access data object from the SQL server.
  2. Stands for Structured Query Language.
  3. SQL addresses data in sets of rows and column rather than addressing individual component or a single data.
  4. SQL support automatic navigation to target the data means user find data without knowing how to get this data and how to store the data.
  5. Using this user never waste the time on representation of data, user only concentrate on logic.
Previous Home Next