What are the roles of SQL?
• SQL is an interactive query language for ad hoc database queries. • SQL is a database programming language. • SQL is a data definition and data administration language. • SQL is the language of networked database servers • SQL helps protect the data in a multi-user networked environment. • Because of these multifacted roles it plays, physicists might call SQL as “The grand unified theory of database”. 23. What is Structured Query Langauge (SQL)? SQL is a powerful set-oriented language which was developed by IBM research for the databases that adhere to the relational model. It consists of a short list of powerful, yet highly flexible, commands that can be used to manipulate information collected in tables. Through SQL, we can manipulate and control sets of records at a time. 24. What are the characteristics of Client/Server? • Service • Shared resources • Asymmentrical protocols • Transparency of location • Mix-and-match • Message based exchanges • Encapsulation of services • Scalabi