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
