Question 1

If you do not want a column alias to appear in all upper case characters,the column alias must be enclosed in ____________________ marks.​

Accepted Answer

The answer of If you do not want a column...

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

The ____________________ command can be used to display the structure of a table.​

Accepted Answer

The answer of The ____________________ command can be used to...

Question 6

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

Accepted Answer

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

Question 7

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?

Accepted Answer

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

Question 8

Contents of the BOOKS table
 
-Which of the following will display the new retail price of each book as 20 percent more than it originally cost?​

Accepted Answer

A)   ​none of the above
B)   ​SELECT title,cost+.20 "New Retail Price" FROM books;
C)   ​SELECT title,cost*.20 "New Retail Price" FROM books;
D)   ​SELECT title,cost*1.20 "New Retail Price" FROM books;

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

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

Question 11

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

Accepted Answer

A)   ​SELECT contact Contact's NameFROM publisher;
B)   ​SELECT publisherIDFROM publisher;
C)   ​SELECT contact,nameFROM publisher;
D)   ​SELECT nameFROM publishers;

Question 12

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?​

Accepted Answer

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

Question 13

You can include ____________________ to override the order of operations when solving arithmetic expressions.​

Accepted Answer

The answer of You can include ____________________ to override the...

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

Structure of the ORDERS table
 
-Based upon the structure of the ORDERS table,the column heading for which column will be truncated in the results?​

Accepted Answer

A)   ​shipstreet
B)   ​orderdate
C)   ​customer#
D)   ​shipzip

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

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

Question 20

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

Accepted Answer

A) True 
 B)False

Exam 2: Basic SQL Select Statements

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

Correct AnswerverifiedShow Answer

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?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Contents of the BOOKS table -Which of the following will display the new retail price of each book as 20 percent more than it originally cost?​

Correct AnswerverifiedShow Answer

You can include ____________________ to override the order of operations when solving arithmetic expressions.​

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Structure of the ORDERS table -Based upon the structure of the ORDERS table,the column heading for which column will be truncated in the results?​

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The ____________________ command can be used to display the structure of a table.​

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

If you do not want a column alias to appear in all upper case characters,the column alias must be enclosed in ____________________ marks.​

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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?​

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct Answer
verified

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?

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

Contents of the BOOKS table -Which of the following will display the new retail price of each book as 20 percent more than it originally cost?

Correct Answer
verified

You can include ____________________ to override the order of operations when solving arithmetic expressions.

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

Structure of the ORDERS table -Based upon the structure of the ORDERS table,the column heading for which column will be truncated in the results?

Correct Answer
verified

Correct Answer
verified

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

Correct Answer
verified

The ____________________ command can be used to display the structure of a table.

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

If you do not want a column alias to appear in all upper case characters,the column alias must be enclosed in ____________________ marks.

Correct Answer
verified

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

Correct Answer
verified

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?

Correct Answer
verified

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.

Correct Answer
verified