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 41

True/False

Review LaterAdd Note

Review Later

The asterisk symbol (*)can be used in a SELECT statement to indicate that all rows in the table should be displayed in the results.​

Correct Answer

verified

Show Answer

Question 42

Multiple Choice

Review LaterAdd Note

Review Later

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

A) ​single quotation marks (' ')
B) ​asterisks (* *)
C) ​double quotation marks (" ")
D) ​percent signs (% %)

Correct Answer

verified

Show Answer

Question 43

Multiple Choice

Review LaterAdd Note

A column alias must be contained within double quotation marks (" ") if it contains which of the following?​

Which of the following keywords can be used to indicate that a column alias should be included in the results?​

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

The ____________________ keyword can be included in a SELECT statement to suppress the display of duplicate data.​

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

The ____ for a SQL statement gives the basic structure,or rules,required to execute the statement.​

Structure of the ORDERS table -Which of the following is a valid SELECT statement?​

A(n)WHERE statement allows a user to retrieve data from a database table.​_________________________

Contents of the BOOKS table -Which of the following will display the ISBN column of the BOOKS table as the first column in its results?​

____________________ statements can be used to retrieve data from database tables.​

The names of the columns to be retrieved are listed in the ____________________ clause.​

What is the correct answer for the arithmetic expression 9+2*(3-4) using the order of operations employed by Oracle 12c when solving equations?​

A ____________________ is used to end a SQL statement.

Structure of the ORDERS table -Which of the following statements can be used to view the structure of the ORDERS table?​

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

Which of the following types of columns will automatically right-align the data when it is displayed?​

What are the mandatory clauses of a SELECT statement and what do they represent?​

Combining the contents of two or more columns is known as ____________________.​