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

Short Answer

Review LaterAdd Note

Review Later

A(n) _____ character is a symbol that can be used as a general substitute for other characters or commands.

Correct Answer

verified

Show Answer

Question 42

Multiple Choice

Review LaterAdd Note

Review Later

A(n) _____ query specifies which data should be retrieved and how it should be filtered, aggregated, and displayed.

A) INSERT
B) SELECT
C) COMMIT
D) UPDATE

Correct Answer

verified

Show Answer

Question 43

Short Answer

Review LaterAdd Note

The _____ operator could be used in place of EXCEPT (MINUS) if the DBMS does not support it.

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

The _____ command defines a default value for a column when no value is given.

An alias cannot be used when a table is required to be joined to itself in a recursive query.

A(n) _____, also known as a nested query or an inner query, is a query that is embedded (or nested) inside another query.

How many rows would be returned from a cross join of tables A and B, if A contains 8 rows and B contains 18?

Which query is used to list a unique value for V_CODE, where the list will produce only a list of those values that are different from one another?

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

Although SQL commands can be grouped together on a single line, complex command sequences are best shown on separate lines, with space between the SQL command and the command's components.

If a designer wishes to create an inner join, but the two tables do not have a commonly named attribute, he can use a(n) _____ clause.

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

In Oracle, the _____ function converts a date to a character string.

Most SQL implementations yield case-insensitive searches.