SQL basic

SQL = _____

• Standard Query Label

• Standard Query Language

• Structured Query Language

• Structured Query Label

"Delete FROM STUDENT"

=

–Remove all tuples from the student relation

• TRUE

• FALSE

________ - extracts data from a database

• UPDATE

• ALTER

• SELECT

• DELETE

_______ STUDENT = create new STUDENT database

DROP TABLE is command for

• add a row

• deletes a table

• add a table

• deletes a structure

Variable length character strings, with user- specified maximum length n.

• varchar(n). 

• char(n)

• int

• length

Floating point number, with user-specified

precision of at least n digits.

• int(n)

• digit(n)

• float(n). 

• number(n)

•SQL allows duplicates in relations as well as in query results.

• TRUE

• FALSE

To select all attributes from Student

• select ALL

  from Student

• select A

  from Student

• select *

  from Student

• select attribute

  from Student

ALTER TABLE command is for ______

• modifies a table.

• delete a table.

• insert row in table

• insert column