FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

BASICS OF BIG DATA

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.