Exam 7: Introduction to Structured Query Language SQL

The COMMIT command does not permanently save all changes.In order to do that,you must use SAVE.

A(n)is a logical group of database objects,such as tables and indexes,that are related to each other.

You cannot insert a row containing a null attribute value using SQL.

SQL is considered difficult to learn; its command set has a vocabulary of more than 300 words.

Oracle users can use the Access QBE (query by example)query generator.

If a user adds a new column to a table that already has rows,the existing rows will default to a value of for the new column.

To make SQL code more _______,most SQL programmers use one line per column (attribute)definition.

The clause of the GROUP BY statement operates very much like the WHERE clause in the SELECT statement.

How can a table be deleted from the database? Provide an example.

Which command is used to save changes to the database? What is the syntax for this command?

A specialty field in mathematics,known as algebra,is dedicated to the use of logical operators.

Which of the following queries will output the table contents when the value of V_CODE is equal to 21344?