FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 7: Introduction to Structured Query Language (SQL)

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 41

Multiple Choice

Review LaterAdd Note

Review Later

Which query will use the given columns and column aliases from the PRODUCT table to determine the total value of inventory held on hand?

A) SELECT P_DESCRIPT,P_QOH,P_PRICE,P_QOH/P_PRICE
FROM PRODUCT;
B) SELECT P_DESCRIPT,P_QOH,P_PRICE,P_QOH=P_PRICE
FROM PRODUCT;
C) SELECT P_DESCRIPT,P_QOH,P_PRICE,P_QOH*P_PRICE
FROM PRODUCT;
D) SELECT P_DESCRIPT,P_QOH,P_PRICE,P_QOH-P_PRICE
FROM PRODUCT;

E) All of the above
F) A) and D)

Correct Answer

verified

Show Answer

Question 42

Multiple Choice

Review LaterAdd Note

Review Later

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

A) DELETE FROM PRODUCT
WHERE P_CODE = 'BRT-345';
B) REMOVE FROM PRODUCT
WHERE P_CODE = 'BRT-345';
C) ERASE FROM PRODUCT
WHERE P_CODE = 'BRT-345';
D) ROLLBACK FROM PRODUCT
WHERE P_CODE = 'BRT-345';

E) All of the above
F) B) and D)

Correct Answer

verified

Show Answer

Question 43

True/False

Review LaterAdd Note

Most SQL implementations yield case-insensitive searches.

The basic SQL vocabulary has fewer than ____________________ words.

If your integer values are relatively small,use ____________________ instead of INT.

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

To delete an index,use the ____________________ command.

Which of the following is used to select partial table contents?

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

The ____ command is used to restore the table's contents to their previous values.

The SQL command that lets you select attributes from rows in one or more tables is ____.

You can select partial table contents by naming the desired fields and by placing restrictions on the rows to be included in the output.

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

COUNT is designed to tally the number of non-null "values" of an attribute,and is often used in conjunction with the DISTINCT clause.

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

Which query will output the table contents when the value of P_PRICE is less than or equal to 10?

The ANSI prescribes a standard SQL-the current fully approved version is known as SQL-07.

Any changes made to the contents of a table are not physically saved on disk until you use the SAVE <table name> command.

To join tables,simply enumerate the tables in the FROM clause of the SELECT statement.The DBMS will create a Cartesian product of every table in the FROM clause.To get the correct results,you need to select the rows in which the common attributes do not match.

The conditional LIKE must be used in conjunction with wildcard characters.