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 51

Essay

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Any changes made to the table contents a...

View Answer

Show Answer

Question 52

Short Answer

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 53

True/False

Review LaterAdd Note

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

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?

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

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.

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

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

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

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

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