![Trending Articles on Technical and Non Technical topics](/images/trending_categories.jpeg)
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
Sudhir sharma has Published 1206 Articles
![sudhir sharma](https://www.tutorialspoint.com/assets/profiles/125719/profile/60_65058-1565947418.jpg)
sudhir sharma
1K+ Views
Introduction Have you been grappled with slow database performance and clueless how to optimize it? Fact is, efficient physical database design and tuning can significantly enhance your database operations. In this enlightening article, we will unravel practical methods that revamp your system's speed by addressing bottlenecks, utilizing proper indexing strategies, ... Read More
![sudhir sharma](https://www.tutorialspoint.com/assets/profiles/125719/profile/60_65058-1565947418.jpg)
sudhir sharma
146 Views
Introduction To ensure both concurrency control and data integrity within database management systems (DBMS). Several locking mechanisms are employed — among them, one is being predicate locking. By utilizing this particular type of lock for protecting specified sections of the stored information from conflicting operations seeking simultaneous access. DBMS ... Read More
![sudhir sharma](https://www.tutorialspoint.com/assets/profiles/125719/profile/60_65058-1565947418.jpg)
sudhir sharma
127 Views
Introduction Primary indexing is a crucial component of database management systems as it greatly enhances the efficiency of retrieving data. Its main objective is to establish a primary key and index. Which in turn enables quick and precise searches. By assigning a unique identifier to each record and creating an ... Read More
![sudhir sharma](https://www.tutorialspoint.com/assets/profiles/125719/profile/60_65058-1565947418.jpg)
sudhir sharma
310 Views
Introduction This article discusses the printing of prime numbers between two given values using PL/SQL. It emphasizes the importance of efficiency, precision, readability, maintainability, and error handling in software development. Optimized algorithms and data structures are employed to efficiently identify prime numbers. The use of meaningful variable names, proper indentation, ... Read More
![sudhir sharma](https://www.tutorialspoint.com/assets/profiles/125719/profile/60_65058-1565947418.jpg)
sudhir sharma
64 Views
Introduction In the age of technology we live in today. Preserving our personal information and maintaining our privacy has become an urgent concern. Our digital footprints encapsulate valuable information which can be leveraged by opportunistic entities solely for their own gain; inevitably triggering concerns regarding the safeguarding of our privacy ... Read More
![sudhir sharma](https://www.tutorialspoint.com/assets/profiles/125719/profile/60_65058-1565947418.jpg)
sudhir sharma
25 Views
Overview For organizations grappling with database unavailability issues there are considerable challenges that can impact their operational efficiency as well as financial outcomes not to mention the importance of having access to real time information. Given that databases function as repositories for important data any delay or inability in accessing ... Read More
![sudhir sharma](https://www.tutorialspoint.com/assets/profiles/125719/profile/60_65058-1565947418.jpg)
sudhir sharma
49 Views
Overview Production databases are crucial for storing and retrieving data in organizations. SQL queries are essential for efficiently retrieving specific information from these databases. The article aims to equip readers with practical knowledge for working with production databases using SQL queries. Understanding SQL Queries and Relational Databases Relational databases ... Read More
![sudhir sharma](https://www.tutorialspoint.com/assets/profiles/125719/profile/60_65058-1565947418.jpg)
sudhir sharma
69K+ Views
Binary Search is a search algorithm that is used to find the position of an element (target value ) in a sorted array. The array should be sorted prior to applying a binary search. Binary search is also known by these names, logarithmic search, binary chop, half interval search. Working ... Read More
![sudhir sharma](https://www.tutorialspoint.com/assets/profiles/125719/profile/60_65058-1565947418.jpg)
sudhir sharma
1K+ Views
The C++ STL (Standard Template Library) is a powerful set of C++ template classes to provide general-purpose classes and functions with templates that implement many popular and commonly used algorithms and data structures like vectors, lists, queues, and stacks.It is a library of container classes, algorithms, and iterators. It is ... Read More
![sudhir sharma](https://www.tutorialspoint.com/assets/profiles/125719/profile/60_65058-1565947418.jpg)
sudhir sharma
341 Views
In the world of computers and the internet, host names are a critical component of how devices connect to each other. A host name is a unique identifier that is assigned to a device or a server on a network. It is used to identify and locate devices on the ... Read More