banco de dados

INSTITUTO

TÉCNICO

DE

BARUERI

“BRASÍLIO

FLORES

DE

AZEVEDO”

LISTA DE EXERCÍCIOS

1)

Monte um exemplo de comando transact SQL – CREATE DATABASE e como usa-lo:

__________________________________________________________________________________________
__________________________________________________________________________________________
2)

Monte um exemplo de comando transact SQL – CREATE TABLE:

__________________________________________________________________________________________
__________________________________________________________________________________________
3)

Monte um exemplo de comando transact SQL – SELECT:

__________________________________________________________________________________________
__________________________________________________________________________________________
4)

Monte um exemplo de comando transact SQL – INSERT:

__________________________________________________________________________________________
__________________________________________________________________________________________
5)

Monte um exemplo de comando transact SQL – UPDATE:

__________________________________________________________________________________________
__________________________________________________________________________________________
6)

Monte um exemplo de comando transact SQL – DELETE:

__________________________________________________________________________________________
__________________________________________________________________________________________
7)

Quantos e quais os tipos de Constraints existentes:

__________________________________________________________________________________________
__________________________________________________________________________________________
__________________________________________________________________________________________