PrepAway - Latest Free Exam Questions & Answers

which of the following?

The description of the database is called a schema. The schema is defined by which of the following?

PrepAway - Latest Free Exam Questions & Answers

A.
Data Control Language (DCL).

B.
Data Manipulation Language (DML).

C.
Data Definition Language (DDL).

D.
Search Query Language (SQL).

Explanation:
The description of the database is called a schema, and the schema is defined by a Data Definition Language
(DDL). DDL is similar to a computer programming language and is used for defining data structures, such as
database schemas.
Incorrect Answers:
A: The Data Control Language (DCL) is a subset of the Structured Query Language (SQL) that allows database
administrators to configure security access to relational databases.
B: The Data Manipulation Language (DML) is used to retrieve, insert and modify database information. These
commands will be used by all database users during the routine operation of the database.
D: SQL is the abbreviation for structured query language and not search query language. SQL is a standardized
query language for requesting information from a database.
Harris, Shon, All In One CISSP Exam Guide, 6th Edition, McGraw-Hill, New York, 2013, pp. 1177, 1178
https://secure.wikimedia.org/wikipedia/en/wiki/Data_Definition_Language
http://databases.about.com/od/Advanced-SQL-Topics/a/Data-Control-Language-Dcl.htm
http://www.webopedia.com/TERM/S/SQL.html
http://www.w3schools.in/mysql/ddl-dml-dcl/
http://www.orafaq.com/faq/what_are_the_difference_between_ddl_dml_and_dcl_commands


Leave a Reply