Module 02a - Introduction to SQL

Question 1

What is Business Intelligence

Answer 1

BI enables the business do make intelligent, fact-based decisions.
Originally a term coined by the Gartner Group in 1993, Business Intelligence (BI) is a broad range of software and solutions aimed at collection, consolidation, analysis and providing access to information that allows users across the business to make better decisions.

Question 2

What’s a Ad-hoc query

Answer 2

It’s a non-standard inquiry, created to obtain information as the need arises

Question 3

How the SQL statements are divided?

Answer 3

DDL - Data definition language
DML - Data manipulation language
PSM - Persistent Stored Modules
TCL - Transaction control language
DCL - Data control language

Question 4

What is DDL

Answer 4

Data Definition Languages are statements that allow users to create tables, relationships, and other structures

Question 5

What is DML

Answer 5

Data Manipulation Language are statements used for queries and data modification.

Question 6

What is PSM

Answer 6

Persistent Stored Modules are statements that allow you to define procedures and functions and store them in the database server

Question 7

What are TCL

Answer 7

Transaction control language statements are used to mark transactions boundaries and control transaction behavior

Question 8

What are DCL

Answer 8

Data control language are statements used to grant or revoke database permissions to (from) users and groups