InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What are the advantages of SQL commands? |
| Answer» SQL has many advantages which makes it popular and highly demanded. It is a reliable and efficient language used for communicating with the database. Some advantages of SQL are as follows:\tFaster Query Processing – Large amount of data is retrieved quickly and efficiently. Operations like Insertion, deletion, manipulation of data is also done in almost no time.\tNo Coding Skills – For data retrieval, large number of lines of code is not required. All basic keywords such as SELECT, INSERT INTO, UPDATE, etc are used and also the syntactical rules are not complex in SQL, which makes it a user-friendly language.\tStandardised Language – Due to documentation and long establishment over years, it provides a uniform platform worldwide to all its users.\tPortable – It can be used in programs in PCs, server, laptops independent of any platform (Operating System, etc). Also, it can be embedded with other applications as per need/requirement/use.\tInteractive Language – Easy to learn and understand, answers to complex queries can be received in seconds.\tMultiple data views. | |