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

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.

Correct Answer

verified

Show Answer

Question 42

True/False

Review LaterAdd Note

Review Later

Most SQL implementations yield case-insensitive searches.

Correct Answer

verified

Show Answer

Question 43

True/False

Review LaterAdd Note

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

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.

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

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

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

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

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

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?

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

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

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.

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