Database - Introduction to SQL - Discussion

Discussion Forum : Introduction to SQL - General Questions (Q.No. 34)
34.
SQL is:
a programming language.
an operating system.
a data sublanguage.
a DBMS.
Answer: Option
Explanation:
No answer description is available. Let's discuss.
Discussion:
18 comments Page 1 of 2.

Brighton Chungu said:   1 decade ago
A database management system (DBMS) , sometimes just called a database manager, is a program that lets one or more computer users create and access data in a database.

Some DBMS examples include MySQL, PostgreSQL, Microsoft Access, SQL Server, FileMaker, Oracle, RDBMS, dBASE, Clipper, and FoxPro. Since there are so many database management systems available.

So that answer is D.

Vishal deewan said:   10 years ago
Sql is a structured query language. It was first developed by IBM. It provide functionality of retrieving updating and deleting the database and security, integrity constant as well.

Sql is using several parts of language is:

1. Data definition language.

2. Data manipulation language.

3. Data control language.

4. Transactional control language.

5. Integrity constant.

Hasmat Samim said:   9 years ago
SQL is a DSL (Data Sub Language), which is really a combination of two languages.
They are the Data Definition Language (DDL) and the Data Manipulation Language (DML).

Schema changes are part of the DDL and data changes are part of the DML. So, we will consider both parts of the DSL in this discussion of SQL.

Pankaj said:   1 decade ago
In relational database theory, the term sublanguage, first used for this purpose by E. F. Codd in 1970, refers to a computer language used to define or manipulate the structure and contents of a relational database management system (RDBMS).

A Mruthyunjay said:   1 decade ago
A data Sublanguage is a computer language used to define or manipulate the structure of a relational database management system (DBMS) e.g QBE, SQL.

Here, SQL commands can be divided into two main sublanguages DDL & DML.

Zahid Khan said:   8 years ago
SQLis a sub-language because it doesn't containing branching and looping structure.

So we have to go for Pl/Sql thats a programming language more correctly a programmable version of SQL.

Brighton Chungu said:   1 decade ago
A SQL is a DATABASE MANAGEMENT SYSTEM (DBMS) because,

Database management system (DBMS) - is a software which are used to create and maintain database.

So answer is (DBMS) D.

Madhavi said:   1 decade ago
Structured query language means the language which is used to define, manipulate and retrieve the data. All can be done by sql. Thats why we are calling it as query language.

Kunal nigam said:   1 decade ago
It's only a programming language like others C, C++ cause of it operations as the name suggest that simple I can't even imagine this particular answer ever thank you.

Shiv Kumar said:   1 decade ago
SQL is a special-purpose programming language designed for managing data held in a relational database management system. But, how is it a sub language?


Post your comments here:

Your comments will be displayed after verification.