Deck 2: Basic SQL Select Statements

Question 1

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

Answer 1

False

Question 2

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

Answer 2

True

Question 3

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

Answer 3

True

Question 4

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

Question 5

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

Question 6

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 7

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

Question 8

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

Question 9

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

Question 10

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

Question 11

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

Question 12

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

Question 13

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

Question 14

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

Question 15

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

Question 16

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 17

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.

Question 18

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

Question 19

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

Question 20

A query is accomplished by issuing a SELECT statement.​

Question 21

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

Question 22

A query can be executed in the SQL*Plus tool._________________________​

Question 23

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

Question 24

The ALL option can be used in the SELECT clause to indicate that all columns should be retrieved._________________________

Question 25

​Choosing specific columns from a database through a SELECT statement is known as projection._________________________

Question 26

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

Question 27

The syntax for a SQL statement gives the basic structure required to execute the statement.
​_________________________

Question 28

​The only required clauses for a SELECT statement are the WHERE and FROM clauses._________________________

Question 29

The SELECT clause identifies the table containing the data to be queried._________________________

Question 30

​In a(n)SELECT statement,keywords,table names,and column names are not case sensitive._________________________

Question 31

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

Question 32

Each clause of a SELECT statement must be entered on a new line in SQL*Plus._________________________​

Question 33

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

Question 34

A column heading that is longer than the width of a column will not be truncated for a column that is defined to store character data._________________________

Question 35

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

Question 36

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

Question 37

​Each section of a statement that begins with a keyword is known as a(n)buffer._________________________

Question 38

The SELECT command can be used to display the structure of a database table._________________________​

Question 39

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

Question 40

​When listing more than one column name in the SELECT clause of a SELECT statement,the column names must be separated by semicolons._________________________

Question 41

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

Question 42

​The DISTINCT keyword can be used to indicate that duplicate data should be suppressed in the results of a query._________________________

Question 43

A string literal must be enclosed in double quotation marks._________________________​

Question 44

By default,data within a character or data column is right-aligned when it is displayed._________________________​

Question 45

Insignificant zeros are displayed for numeric columns by default to show two decimal places._________________________​

Question 46

When solving arithmetic expressions,Oracle 12c always resolves addition and subtraction operations first from left to right in the expression._________________________

Question 47

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

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

Question 48

​If a column alias contains a blank space,it must be enclosed in double quotation marks._________________________

Question 49

The use of a column alias in the SELECT clause can be designated by the keyword ALIAS._________________________

Question 50

Which of the following are case sensitive in Oracle 12c?​

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

Question 51

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

Question 52

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

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

Question 53

Which of the following is a mandatory clause in a SELECT statement?​

A) ​both a and b are mandatory
B) ​HAVING
C) ​WHERE
D) ​FROM

Question 54

Which of the following commands can be used to view the structure of a table?​

A) ​SELECT
B) ​DESCRIBE
C) ​none of the above
D) ​CONCATENATION

Question 55

A(n)____ has a predefined meaning in Oracle 12c.​

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

Question 56

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

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

Question 57

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

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

Question 58

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) ​numeric
B) ​alphanumeric
C) ​character
D) ​date

Question 59

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

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

Question 60

By default,data within a numeric column is right-aligned when it is displayed._________________________​

Question 61

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

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

Question 62

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

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

Question 63

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

A) ​ALIAS
B) ​AS
C) ​SELECT
D) ​FROM

Question 64

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

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

Question 65

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 name,publisherID FROM publishers;
C) ​SELECT pubid,contact FROM publisher;
D) ​none of the above

Question 66

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) ​none of the above
C) ​SELECT contact name FROM publisher;
D) ​SELECT contact person,name FROM publisher;

Question 67

Which of the following types of columns will automatically left-align the column heading when it is displayed?​

A) ​date
B) ​character
C) ​both a and c
D) ​numeric

Question 68

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 contact;
B) ​SELECT * FROM publisher;
C) ​SELECT * FROM pubid;
D) ​SELECT * FROM name;

Question 69

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

A) ​4.8
B) ​15
C) ​14
D) ​1.336

Question 70

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

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

Question 71

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 publisherID
FROM publisher;
C) ​SELECT contact,name
FROM publisher;
D) ​SELECT name
FROM publishers;

Question 72

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 73

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 name,phone ​FROM publisher
B) SELECT *
FROM publisher;​
C) ​SELECT name,contact FROM publisher/
D) ​SELECT * FROM publisher;

Question 74

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) ​7
B) ​-18
C) ​9
D) ​-11

Question 75

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 76

Which of the following statements is correct?​

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

Question 77

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

Question 78

Which of the following keywords can be included in a SELECT statement to suppress duplicate data?​

A) ​UNIQ
B) ​SUPPRESS
C) ​all of the above
D) ​DISTINCT

Question 79

​What is the correct solution for the arithmetic expression 2+8/2*9/3 using the order of operations employed by Oracle 12c when solving equations?

A) ​14
B) ​15
C) ​4.8
D) ​0.1

Question 80

​A string literal must be enclosed in ____.

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