FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 2: Basic Sql Select Statements

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 31

Multiple Choice

Review LaterAdd Note

Review Later

To indicate which database table contains the data to be selected by a query, the table name should be listed in the ____ clause.

A) SELECT
B) FROM
C) WHERE
D) HAVING

Correct Answer

verified

Show Answer

Question 32

True/False

Review LaterAdd Note

Review Later

A string literal must be enclosed in $\underline { \text { double } }$ quotation marks. _________________________

Correct Answer

verified

Show Answer

Question 33

True/False

Review LaterAdd Note

SQL*Plus is an Oracle tool used to enter and edit SQL statements.

The $\underline {\text { DISTINCT } }$ keyword can be used to indicate that duplicate data should be suppressed in the results of a query. _________________________

A query can be executed in the $\underline{\mathrm{SQL}^{*} \text { Plus }}$ tool. _________________________

The optional keyword AS can be used to indicate that the subsequent string of characters is a column alias.

Explain how the DISTINCT keyword effects a SELECT statement that lists two columns in the SELECT clause.

The optional keyword ____________________ can be used to distinguish between a column name and a column alias.

The following arithmetic operations can be performed in the SELECT clause of a SELECT statement: addition (+), subtraction (-), multiplication (*), division (/), and exponential (^).

If a column alias contains a blank space, it must be enclosed in ____.

The columns displayed in the results of a SELECT statement will be in the same order as they are stored in the database table.

Which of the following commands is used to issue a query?

When resolving arithmetic expressions, Oracle10g always performs the operations by starting on the ____________________ side of the expression.

Which of the following symbols represents all the columns contained in a table?

The SELECT clause of the SELECT statement is used to identify which rows are to be retrieved from a specified table.

If a column heading is longer than the assigned width of a(n) ____________________ field, the column heading will be truncated.

Contents of the PUBLISHER table -Based upon the contents of the PUBLISHER table, which of the following is a valid SQL statement?

A(n) $\underline { \text { CRBMDS } }$ is a software program that can be used to create a relational database and allows you to enter, manipulate, and retrieve data. _________________________

Each clause of a SELECT statement $\underline {\text { must } }$ be entered on a new line in SQL*Plus. _________________________

By default, data within a character or data column is $\underline { \text { right } }$ -aligned when it is displayed. _________________________