COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
To specify the syntax and semantics of SQL data definition language
|
|
|
To specify the syntax and semantics of SQL manipulation language
|
|
|
To define the data structures
|
|
|
All of the above.
|
Detailed explanation-1: -Answer: D) All of the above. Explanation: SQL is a domain-specific language used in programming and designed for managing data held in a relational database management system, or for stream processing in a relational data stream management system.
Detailed explanation-2: -In Oracle Quick Guides (Cornelio Books, 2013), author Malcolm Coxall writes that the original version of SQL was designed to manipulate and retrieve data stored in IBM’s original relational database management system, System R.
Detailed explanation-3: -SQL is used to communicate with a database. According to ANSI (American National Standards Institute), it is the standard language for relational database management systems. SQL statements are used to perform tasks such as update data on a database, or retrieve data from a database.
Detailed explanation-4: -Structured Query Language (SQL) is a database language designed for managing data held in a relational database management system. SQL was initially developed by IBM in the early 1970s (Date 1986).
Detailed explanation-5: -One of the original purposes of the SQL standard was to provide a vehicle for portability of database definition and application modules between conforming DBMSs. A major benefit of SQL as a standard is reduced training costs.