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

True/False

Review LaterAdd Note

Review Later

SQL requires the use of the ADD command to enter data into a table.

A) True
B) False

Correct Answer

verified

Show Answer

Question 42

Multiple Choice

Review LaterAdd Note

Review Later

Which of the following queries uses the correct SQL syntax to list the table contents for either V_CODE = 21344 or V_CODE = 24288?

A) SELECT P_DESCRIPT,P_INDATE,P_PRICE,V_CODE FROM PRODUCT WHERE V_CODE = 21344 OR V_CODE <= 24288;
B) SELECT P_DESCRIPT,P_INDATE,P_PRICE,V_CODE FROM PRODUCT WHERE V_CODE = 21344 OR V_CODE => 24288;
C) SELECT P_DESCRIPT,P_INDATE,P_PRICE,V_CODE FROM PRODUCT WHERE V_CODE = 21344 OR V_CODE > 24288;
D) SELECT P_DESCRIPT,P_INDATE,P_PRICE,V_CODE FROM PRODUCT WHERE V_CODE = 21344 OR V_CODE = 24288;

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

Correct Answer

verified

Show Answer

Question 43

Multiple Choice

Review LaterAdd Note

The SQL command that allows a user to permanently save data changes is .

The basic SQL vocabulary has fewer than words.

__ words are words used by SQL to perform specific functions.

If you have not yet used the COMMIT command to store the changes permanently in the database,you can restore the database to its previous condition with the ROLLBACK command.

The SQL data manipulation command HAVING:

Some RDBMSs,such as Oracle,automatically data changes when issuing data definition commands.

A(n)order sequence is a multilevel ordered sequence that can be created easily by listing several attributes,separated by commas,after the ORDER BY clause.

In the SQL environment,the word covers both questions and actions.

Rows can be grouped into smaller collections quickly and easily using the clause within the SELECT statement.

Most SQL implementations yield case-insensitive searches.

In Oracle,the command is used to change the display for a column,for example,to place a $ in front of a numeric value.

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

All changes in a table structure are made using the command,followed by a keyword that produces the specific changes a user wants to make.

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

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

To delete an index,one must use the command.

What is a schema? How many schemas can be used in one database?

With the exception of the database process,most RDBMS vendors use SQL that deviates little from the ANSI standard SQL.