Finals Quiz

SQL stands for:

• Standard Query language

• Structured Questioning Language

• Structured Query Language

• Standard Querying Language

Which of the following can add a column to an existing table?

• Delete

• Insert

• Update

• Alter

Which SQL statement is use to add a new data in a database?

• Insert Into

• Update

• Add

• Insert New

What SQL clause is use to restrict the rows returned by a query?

• AND

• WHERE

• HAVING

• FROM

A SELECT command without a WHERE clause returns?

• All the records from a table that match the previous WHERE clause

• All the records from a table, or information about all the records

• SELECT is invalid without a WHERE clause

• Nothing

What language is use to query data in a Relational Database?

• BASIC

• SQL

• C++

• JAVA

What command retrieves data from the database?

• Insert

• Select

• Alter

• Describe

If an SQL statement returns data from two or more tables, which SQL capability is being used?

• Projection

• Selection

• Joining

• Insertion

You query the database with this SQL statement: SELECT * FROM students; Why would you use this statement?

• To display the table structure

• To view data

• To delete data

• To insert data

SELECT * FROM departments; is a

• Statement

• Keyword

• Strategy

• Declaration