Deck 2: Basic Sql Select Statements

Question 1

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.

Answer 1

True

Question 2

By default, a column alias is displayed in lower case characters in the results.

Answer 2

False

Question 3

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

Answer 3

False

Question 4

A query is accomplished by issuing a SELECT statement.

Question 5

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

Question 6

If a column name is entered in lower case in the SELECT statement, the data for the column will be displayed in lower case in the results.

Question 7

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

Question 8

Column headings may be truncated in the results of a SELECT statement.

Question 9

The majority of operations performed on a typical database table utilize the SELECT statement.

Question 10

A script file containing SQL statements can be executed from SQL*Plus.

Question 11

Choosing specific columns to be displayed by a SELECT statement is known as selection.

Question 12

SQL*Plus can only be accessed via an internet interface.

Question 13

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

Question 14

Choosing specific columns to be displayed by a SELECT statement is known as projection.

Question 15

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

Question 16

A clause is a section within a SQL statement that begins with a keyword.

Question 17

Each section of a SQL command that begins with a keyword is known as a statement.

Question 18

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

Question 19

When a user asks the database a question, the user is issuing a query.

Question 20

The DESCRIBE command is used to view data in a table.

Question 21

Choosing specific columns from a database through a SELECT statement is known as $\underline {\text { projection }}$ _________________________

Question 22

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

Question 23

Each section of a statement that begins with a keyword is known as a(n) $\underline { \text { buffer } }$ . _________________________

Question 24

The $\underline {\text { SELECT } }$ command can be used to display the structure of a database table. _________________________

Question 25

The $\underline { \text { ALL } }$ option can be used in the SELECT clause to indicate that all columns should be retrieved. _________________________

Question 26

A column heading that is longer than the width of a column will not be truncated for a column that is defined to store $\underline { \text { character } }$ data. _________________________

Question 27

A(n) $\underline { \text { WHERE } }$ statement allows a user to retrieve data from a database table. _________________________

Question 28

Parentheses can be used to override the order of operations in an arithmetic expression.

Question 29

The only required clauses for a SELECT statement are the $\underline {\text { WHERE }}$ and FROM clauses. _________________________

Question 30

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. _________________________

Question 31

In a(n) $\underline {\text { SELECT } }$ statement, keywords, table names, and column names are not case sensitive. _________________________

Question 32

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

Question 33

Concatenation refers to combining the results of several SELECT statements into one result.

Question 34

The $\underline { \text { SELECT } }$ clause identifies the table containing the data to be queried. _________________________

Question 35

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

Question 36

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

Question 37

The DIST or UNIQ keywords can be used to suppress duplicate data in the results of a SELECT statement.

Question 38

When listing more than one column name in the SELECT clause of a SELECT statement, the column names must be separated by $\underline {\text { semicolons }}$ . _________________________

Question 39

The $\underline { \text { syntax } }$ for a SQL statement gives the basic structure required to execute the statement. _________________________

Question 40

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

Question 41

Combining the contents of two or more columns is known as $\underline {\text { projection } }$ . _________________________

Question 42

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

Question 43

The use of a column alias in the SELECT clause can be designated by the keyword $\underline { \text { ALIAS } }$ . _________________________

Question 44

Which of the following are case sensitive in Oracle11g?

A) keywords
B) column names
C) table names
D) none of the above

Question 45

The entire column heading for a column will be displayed, regardless of the assigned width of the column, if the column is defined as a(n) ____ column.

A) character
B) alphanumeric
C) date
D) numeric

Question 46

When solving arithmetic expressions, Oracle11g always resolves addition and subtraction operations $\underline {\text { first } }$ from left to right in the expression. _________________________

Question 47

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

Question 48

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

Question 49

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

Question 50

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

A) clauses
B) keywords
C) sequence
D) syntax

Question 51

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

A) /
B) ;
C) *
D) ^

Question 52

$\underline{\text { Parentheses }}$ can be used to override the order of operations in an arithmetic expression. _________________________

Question 53

Insignificant zeros $\underline { \text { are } }$ displayed for numeric columns by default to show two decimal places. _________________________

Question 54

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

Question 55

A(n) ____ has a predefined meaning in Oracle11g.

A) keyword
B) statement
C) syntax
D) clause

Question 56

What is used to indicate the end of an SQL statement?

A) /
B) :
C) ;
D) *

Question 57

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

Question 58

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

A) QUER
B) FROM
C) SELECT
D) QUESTION

Question 59

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

Question 60

If a column alias contains a blank space, it must be enclosed in $\underline {\text { double } }$ quotation marks. _________________________

Question 61

Contents of the PUBLISHER table

Based upon the contents of the PUBLISHER table, which of the following SELECT statements will display the publisher's name first in the results?

A) SELECT * FROM publisher;
B) SELECT pubid, contact FROM publisher;
C) SELECT name, publisherID FROM publishers;
D) none of the above

Question 62

Contents of the PUBLISHER table

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

A) SELECT * FROM pubid;
B) SELECT * FROM name;
C) SELECT * FROM contact;
D) SELECT * FROM publisher;

Question 63

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

Question 64

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

A) -11
B) -18
C) 9
D) 7

Question 65

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

A) character
B) date
C) alphanumeric
D) numeric

Question 66

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

A) projection
B) concatenation
C) selection
D) suppression

Question 67

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 (% %)

Question 68

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) *

Question 69

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

Question 70

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

Question 71

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) 0.1
B) 4.8
C) 15
D) 14

Question 72

A string literal must be enclosed in ____.

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

Question 73

Contents of the PUBLISHER table

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

A) SELECT contact Contact's Name
FROM publisher;
B) SELECT contact, name
FROM publisher;
C) SELECT publisherID
FROM publisher;
D) SELECT name
FROM publishers;

Question 74

Contents of the PUBLISHER table

Based upon the contents of the PUBLISHER table, which of the following SQL statements will display only two columns in the results?

A) SELECT * FROM publisher;
B) SELECT contact name FROM publisher;
C) SELECT contact person, name FROM publisher;
D) none of the above

Question 75

What is the correct answer for the arithmetic expression 9+2*3-2 using the order of operations employed by Oracle10g when solving equations?

A) 13
B) 31
C) 10
D) 12

Question 76

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

Question 77

Which of the following statements is correct?

A) The columns will be listed in the results in the same order they are stored in the database table.
B) Character columns are listed first in the output, followed by numeric columns.
C) The columns will be listed in the results in the same order they are listed in the SELECT clause of the SELECT statement.
D) Numeric columns are listed first in the output, followed by character columns.

Question 78

Which of the following symbols can be used to combine data from different columns into one column of output?

A) ||
B) ^
C) %
D) *

Question 79

Contents of the PUBLISHER table

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

A) SELECT * FROM publisher;
B) SELECT name, contact FROM publisher/
C) SELECT name, phone
FROM publisher
/
D) SELECT *
FROM publisher;

Question 80

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