DBMS_7th_ch03

What was the original name of the SQL language?

• IBM Sequel

• Structured Query Language

• ANSI

• ISO

Which SQL standard was introduced in the year 1999?

• SQL-92

• SQL-89

• SQL:1999

• SQL-86

What does DML stand for in SQL?

• Data Manipulation Language

• Data Modeling Language

• Database Management Language

• Data Migration Language

Which SQL data type is used for fixed length character strings?

• varchar

• int

• char

• numeric

What does the SQL DDL allow the specification of for relations?

• Data types

• Integrity constraints

• Indices

• All of the above

Which SQL operation is used to delete all tuples from a relation?

• Insert

• Update

• Drop

• Delete

What does the SQL select clause correspond to in relational algebra?

• Union

• Projection

• Join

• Selection

Which SQL operator is used to eliminate duplicates in query results?

• Distinct

• All

• Unique

• Not

What does the SQL where clause specify?

• Attributes to display

• Conditions for the result

• Relations involved

• Aggregate functions

Which SQL clause is used to order the display of tuples?

• Select

• From

• Order by

• Where