Beginning T-SQL

Question 1

What is T-SQL

Answer 1

It is Microsoft implementation of ANSI SQL.

Question 2

How is T-SQL used?

Answer 2

It is used to extract or modify the data stored in a SQL Server database.

Question 3

What are the 5 main components of T-SQL

Answer 3

Data Definition Language (DDL)
Data Manipulation Language (DML)
Data Control Language (DCL)
Transaction Control Language (TCL)
Control-of-flow statements

Question 4

What is SQL Server?

Answer 4

It is Microsoft’s Relational Database Management System (RDBMS)

Question 5

What is the purpose of and RDBMS?

Answer 5

It stores data in tables according to the relational model

Question 6

What is a SQL Server Database?

Answer 6

It is a container that holds several types of objects in organized fashion

Question 7

What does ERP means?

Answer 7

Enterprise Resource Planning System

Question 8

Application vs ERP

Answer 8

Usually, and application uses one database; while an ERP uses one database for all enterprise applications in a coorporation.

Question 9

What are the most common 10 objects in a database?

Answer 9

Table, Views, Stored Procedures, User-defined functions, Indexes, Constantes, Triggers, Types, Plan Builds, Sequences, Synonyms, Assemblies.

Question 10

What is the purpose of a table?

Answer 10

It holds the data that we store and extract.

Question 11

What is a View?

Answer 11

It is a stored query definition.

Question 12

What is the purpose of a View?

Answer 12

To simplify writing T-SQL statements or to secure data access.

Question 13

What is a Stored Procedure?

Answer 13

It is a Script that can include queries, DDL, statements to create/modify objects, and programming logic.

Question 14

What type of data can a Store Procedure return?

Answer 14

Tabular data

Question 15

What is a user-defined function?

Answer 15

It is similar to a store procedure, but they cannot affect anything outside of the function.

Question 16

What type of data can a User-Defined Function return?

Answer 16

Tabular Data or a Single Value

Question 17

What is an Index?

Answer 17

It is a structure that assists the database engine when locating rows.

Question 18

What are Constraints?

Answer 18

Rules controlling the behavior of tables and columns, and the data that can be stored in a column.

Question 19

What are Triggers?

Answer 19

It is a special type of stored procedure that fires when something happens in the database.

Question 20

What are two examples that can activate a trigger?

Answer 20

When a record is inserted

When an object is created

Question 21

What is a Type?

Answer 21

Each columns in a db has rules of what type of data it can contain

Question 22

What are Plan Guides?

Answer 22

It is an advanced feature that overrites the SQL Server behavior for a particular query.

Question 23

What are Sequences?

Answer 23

They are containers holding incrementing numbers

Question 24

What are Synonyms?

Answer 24

They are Nicknames or Aliases for database objects

Question 25

What are Assemblies?

Answer 25

They are referenced to database objects created in a .Net language using CLR Integrations.

Question 26

What is CLR Integration?

Answer 26

Common Language Runtime (CLR) Integration

Question 27

Normalization

Answer 27

It is a set of Rules and Principles that can be applied to a relational table to have Efficient use of Disk Space and Efficient Manipulation of Data.