Which of the following is an ANSI approved language for communicating and managing data in a
relational database management system (RDBMS)?
A.
SQL
B.
QL
C.
DDL
D.
XML
Explanation:
Structured Query Language (SQL) is used to communicate and manage data in a relational database
management system (RDBMS).
Structured Query Language (SQL) is the most common language used to access relational databases.
SQL was developed by IBM in the
1970’s, and SQL version 3 was officially defined by the American National Standards Institute (ANSI).
Most DBMS’s conform to the ANSI SQL-92
standard. It is a nonprocedural language and supports many database systems that are in use today,
such as MySQL, PostgreSQL, Berkeley
DB, Oracle, DB2, Sybase, Informix, Microsoft SQL, etc.
Answer C is incorrect. Data Definition Language (DDL) is a part of SQL that allows a user to create
objects (such as tables, stored
procedures, indexes, and triggers) within a database. It also allows a user to delete already created
objects.
Answer B is incorrect. Query Language (QL) is a set of commands used to retrieve, modify, and
update data from the database; it is a
language for formulating queries for a given dataset.
Answer D is incorrect. Extensible Markup Language (XML) is a general-purpose specification for
creating custom markup languages. It is
classified as an extensible language because it allows the user to define the mark-up elements. It is
used to aid information systems in
sharing structured data, especially via the Internet, to encode documents, and to serialize data. XML
is recommended by the World Wide Web
Consortium (W3C). It is a fee-free open standard. The recommendation specifies lexical grammar
and parsing requirements.