Eku: Cis 335: Chapter 3's From Sql Textbook

Front 1

Structured Query Language

Back 1

Which is one of the most popular and widely used languages for retrieving and manipulating database data

Front 2

Breadcrumb

Back 2

SQL Commands references at the top of the SQL editor pane

Front 3

Create Table

Back 3

Command to describe the layout of a table

Front 4

Data Type

Back 4

indicates the type of data that the column can contain
as well as the maximum number of characters or digits that the column can store

Front 5

Drop Table

Back 5

You can delete the entire table using
Command and then re-create table using the correct CREATE Table command

Front 6

Data Type

Back 6

To use to store the type of data that the column will contain

Front 7

Null Data Value

Back 7

This special Value
Simply a null

Front 8

Not Null

Back 8

Clause in a CREATE Table command to indicate columns that cannot contain null values

Front 9

Insert

Back 9

Command adds rows to a table

Front 10

Select

Back 10

To view the data in table use the command

Front 11

Update

Back 11

make changes in table in a particular column

Front 12

Delete

Back 12

When you need to delete a row from a table you can use

Front 13

Script File

Back 13

in many DBMSs you save commands in a

Front 14

Script

Back 14

Which is a text file with the .sql filename extension

Front 15

Script Repsitory

Back 15

When you use Oracle to create a script, Oracle stores the script in a special location

Front 16

Describe

Back 16

In Oracle, you can use the
To list all the columns in a table and their properties