DATABASE FUNDAMENTALS
BASICS OF BIG DATA
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
Data Definition Language (DDL)
|
|
Interactive Data Manipulation Language (IDML)
|
|
Embedded Data Manipulation Language (EDML)
|
|
View Definition
|
|
Authentication
|
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.