Exam 7: Introduction to Structured Query Language Sql

A common practice is to create a(n) on any field that is used as a search key, in comparison operations in a conditional expression, or when a user wants to list rows in a specific order.

The query used to list the P_CODE, P_DESCRIPT, P_INDATE, and P_PRICE fields from the PRODUCT table in ascending order by P_PRICE is .

Only numeric data types can be added and subtracted in SQL.

The command is used with the ALTER TABLE command to modify the table by deleting a column.

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

A(n) is an alternate name given to a column or table in any SQL statement.

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

The command would be used to delete the table row where the P_CODE is 'BRT-345'.

The CHECK constraint is used to define a condition for the values that the attribute domain cannot have.

A table can be deleted from the database by using the command.

Data type selection is usually dictated by the nature of the data and by the intended use.