Casteel DB CH2

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

B) False

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

B) False

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

B) False

The use of a column alias in the SELECT clause can be designated by the keyword ALIAS. A) True B) False

B) False

When solving arithmetic expressions, Oracle11g always resolves addition and subtraction operations first from left to right in the expression. A) True B) False

B) False

If a column alias contains a blank space, it must be enclosed in ____. A) single quotation marks (' ') B) double quotation marks (" ") C) asterisks (* *) D) percent signs (% %)

B) double quotation marks (" ")

Which of the following symbols represents all the columns contained in a table? A) / B) ; C) * D) ^

C) *

What is the correct solution for the arithmetic expression (2+8)/2*9/3 using the order of operations employed by Oracle10g when solving equations? A) 1.336 B) 4.8 C) 15 D) 14

C) 15

What is the correct solution for the arithmetic expression (2+8)/2*9/3 using the order of operations employed by Oracle11g when solving equations? A) 1.336 B) 4.8 C) 15 D) 14

C) 15

What is used to indicate the end of an SQL statement? A) / B) : C) ; D) *

C) ;

Which of the following commands is used to issue a query? A) QUERY B) FROM C) SELECT D) QUESTION

C) SELECT

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

B) False

The SELECT command can be used to display the structure of a database table. A) True B) False

B) False

The ALL option can be used in the SELECT clause to indicate that all columns should be retrieved. A) True B) False

B) False

If the results of a SELECT statement include more than one column of data, the column names must be separated in the SELECT clause by which of the following symbols? A) , B) " " C) ' ' D) *

A) ,

Which of the following keywords can be used to indicate that a column alias should be included in the results? A) AS B) FROM C) SELECT D) ALIAS

A) AS

Which of the following is a mandatory clause in a SELECT statement? A) FROM B) WHERE C) HAVING D) Both A and B are mandatory

A) FROM

A query can be executed in the SQL*Plus tool. A) True B) False

A) True

A query is accomplished by issuing a SELECT statement. A) True B) False

A) True

A user can indicate that all columns of a table should be displayed in the results of a SELECT statement by including an asterisk (*) in the SELECT clause. A) True B) False

A) True

By default, data within a numeric column is right-aligned when it is displayed. A) True B) False

A) True

Choosing specific columns from a database through a SELECT statement is known as projection. A) True B) False

A) True

Choosing specific columns to be displayed by a SELECT statement is known as projection. A) True B) False

A) True

If a column alias contains a blank space, it must be enclosed in double quotation marks. A) True B) False

A) True

If multiple column names are listed in the SELECT clause of a SELECT statement, the columns must be separated by a comma (,). A) True B) False

A) True

In a(n) SELECT statement, keywords, table names, and column names are not case sensitive. A) True B) False

A) True

Parentheses can be used to override the order of operations in an arithmetic expression. A) True B) False

A) True

The majority of operations performed on a typical database table utilize the SELECT statement. A) True B) False

A) True

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

A) True

The syntax for a SQL statement gives the basic structure required to execute the statement. A) True B) False

A) True

When a user asks the database a question, the user is issuing a query. A) True B) False

A) True

A(n) ____ has a predefined meaning in Oracle11g. A) keyword B) statement C) syntax D) clause

A) keyword

A string literal must be enclosed in ____. A) single quotation marks (' ') B) double quotation marks (" ") C) asterisks (* *) D) percent signs (% %)

A) single quotation marks (' ')

Which of the following symbols can be used to combine data from different columns into one column of output? A) || B) ^ C) % D) *

A) ||

The SELECT clause identifies the table containing the data to be queried. A) True B) False

B) False

Which of the following commands can be used to view the structure of a table? A) CONCATENATION B) DESCRIBE C) SELECT D) none of the above

B) DESCRIBE

Which of the following keywords can be included in a SELECT statement to suppress duplicate data? A) UNIQ B) DISTINCT C) SUPPRESS D) All of the above

B) DISTINCT

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

B) FROM

A double backslash (\\) is used to indicate concatenation in a SELECT statement. A) True B) False

B) False

A string literal must be enclosed in double quotation marks. A) True B) False

B) False

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. A) True B) False

B) False

Choosing specific columns to be displayed by a SELECT statement is known as selection. A) True B) False

B) False

Combining the contents of two or more columns is known as projection. A) True B) False

B) False

Concatenation refers to combining the results of several SELECT statements into one result. A) True B) False

B) False

Each clause of a SELECT statement must be entered on a new line in SQL*Plus. A) True B) False

B) False

Each section of a SQL command that begins with a keyword is known as a statement. A) True B) False

B) False

Each section of a statement that begins with a keyword is known as a(n) buffer. A) True B) False

B) False

If you assign a column alias to a column, it must be enclosed in double quotation marks (" "). A) True B) False

B) False

Insignificant zeros are displayed for numeric columns by default to show two decimal places. A) True B) False

B) False

What is the correct solution for the arithmetic expression 2+8/2*9/3 using the order of operations employed by Oracle11g when solving equations? A) 0.1 B) 4.8 C) 15 D) 14

D) 14

Which of the following are case sensitive in Oracle11g? A) keywords B) column names C) table names D) None of the above

D) None of the above

A column alias must be contained within double quotation marks (" ") if it contains which of the following? A) blank spaces B) special symbols C) characters that should be displayed in lower or mixed case D) all of the above

D) all of the above

Which of the following types of columns will automatically left-align the column heading when it is displayed? A) character B) numeric C) date D) both a and c

D) both a and c