CH 5 - SQL Language and Database Concepts

What does DDL stand for in SQL?

• Data Distribution Language

• Data Development Language

• Data Description Language

• Data Definition Language

Which SQL command is used to create a new table?

• NEW table

• INSERT table

• CREATE table

• ADD table

What is the purpose of the 'where' clause in an SQL query?

• To specify conditions for filtering results

• To define the structure of a table

• To join multiple tables

• To select all attributes

Which of the following is a valid data type in SQL?

• varchar

• text

• character

• string

What does the 'primary key' constraint ensure?

• Uniqueness of values in a column

• Allows null values

• Links to another table

• Defines the data type

Which SQL command is used to remove a table from the database?

• CLEAR table

• DELETE table

• DROP table

• REMOVE table

What does the 'select' clause do in an SQL query?

• Defines the tables to be used

• Creates a new table

• Filters the results

• Specifies the attributes to be returned

Which of the following SQL commands is used to insert data into a table?

• insert into

• add to

• append to

• put into

What is the purpose of the 'distinct' keyword in SQL?

• To update existing records

• To select all values

• To eliminate duplicate values

• To create a new table

Which SQL standard was introduced in 1999?

• SQL-2003

• SQL-89

• SQL-86

• SQL:1999