FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

BASICS OF BIG DATA

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

Which of the following is not included in the Basic Concepts of SQL (Structure Query Language)?

A	Data Definition Language (DDL)
B	Interactive Data Manipulation Language (IDML)
C	Embedded Data Manipulation Language (EDML)
D	View Definition
E	Authentication

Explanation:

Detailed explanation-1: -The term NoSQL was used by Carlo Strozzi in 1998 to name his lightweight Strozzi NoSQL open-source relational database that did not expose the standard Structured Query Language (SQL) interface, but was still relational. His NoSQL RDBMS is distinct from the around-2009 general concept of NoSQL databases.

Detailed explanation-2: -The scope of SQL includes data query, data manipulation (insert, update, and delete), data definition (schema creation and modification), and data access control.

Detailed explanation-3: -2) Which of the following is not a valid SQL type? Explanation: DECIMAL is not a valid SQL type because it is nothing but numeric only in SQL. NUMERIC has fixed precision, and scale numbers range from-10^38+1 to 10^38-1.

Detailed explanation-4: -Which of the following is not a type of SQL statement? Explanation: Data Communication Language (DCL) is not a type of SQL statement.

There is 1 question to complete.