Chapter 1

What does SQL stand for?

• Structured Query Language

• Simple Query Language

• Standard Query Language

• System Query Language

SQL is primarily used for:

• Storing images

• Managing emails

• Storing and manipulating data in relational databases

• Creating websites

Which organization defines the SQL standard?

• ISO (International Organization for Standardization)

• IEEE (Institute of Electrical and Electronics Engineers)

• ANSI (American National Standards Institute)

• W3C (World Wide Web Consortium)

Which of the following is NOT something that SQL allows users to do?

• Create and drop databases and tables

• Set permissions on tables, procedures, and views

• Manage hardware components

• Define and manipulate data in a database

The standard SQL commands to interact with relational databases are

• CREATE, SELECT, INSERT, UPDATE, DELETE and DROP

• Create Databases

• Show Databases

• None of the Above

Creates a new table, a view of a table, or other object in database

• INSERT

• CREATE

• REVOKE

• NONE OF THE ABOVE

What commands are used to Manipulate an SQL Database

• INSERT

  UPDATE

  DELETE

• ALTER

  CREATE

  DROP

• SELECT

• REVOKE

  GRANT

In a short Summary tell me Why SQL?