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

True/False

Review LaterAdd Note

Review Later

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

A) True
B) False

Correct Answer

verified

Show Answer

Question 52

True/False

Review LaterAdd Note

Review Later

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

A) True
B) False

Correct Answer

verified

Show Answer

Question 53

Short Answer

Review LaterAdd Note

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

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.

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

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.

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

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

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

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

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