Question 1

The name of the table containing the data to be retrieved is specified in the ____________________ clause.​

Accepted Answer

The answer of The name of the table containing the...

Question 2

Contents of the BOOKS table
 
-Which of the following is a valid SQL statement?​

Accepted Answer

A)   ​SELECT DISTINCT title,category FROM books/
B)   ​all of the above
C)   ​SELECT title,retail-cost FROM books;
D)   ​SELECT title,retail-cost "Profit"E) A) and D)
F) All of the above

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

A)   ​" "
B)   ​' '
C)   ​*
D)   ​,E) A) and C)
F) B) and D)

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

Choosing specific columns in a SELECT statement is known as ____________________.​

Accepted Answer

The answer of Choosing specific columns in a SELECT statement...

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

Contents of the PUBLISHER table
  ​
-Based upon the contents of the PUBLISHER table,which of the following SQL statements will execute without returning an error message?​

Accepted Answer

A)   ​SELECT pubid PUBLISHERID name FROM publisher;
B)   ​SELECT pubid "PUBLISHER ID" name FROM publisher;
C)   ​SELECT pubid name FROM publisher;
D)   ​all of the aboveE) A) and C)
F) C) and D)

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A)   ​none of the above
B)   ​table names
C)   ​column names
D)   ​keywordsE) A) and B)
F) A) and C)

Question 13

When should double-quotation marks (" ")be used in a SELECT statement?​

Accepted Answer

Double-quotation marks are used when a c...

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

By default,the data for character fields are displayed ____________________ aligned when they are displayed.​

Accepted Answer

The answer of By default,the data for character fields are...

Question 17

Contents of the BOOKS table
 
-Based upon the contents of the BOOKS table,which of the following SQL statements will display two columns in its output?​

Accepted Answer

A)   ​SELECT DISTINCT title FROM books;
B)   ​all of the above
C)   ​SELECT * FROM books;
D)   ​SELECT title,retail-cost "Profit" FROM books;E) A) and B)
F) A) and C)

Question 18

The optional keyword ____________________ can be used to distinguish between a column name and a column alias.​

Accepted Answer

The answer of The optional keyword ____________________ can be used...

Question 19

In an arithmetic expression,multiplication and ____________________ are always solved first in Oracle 12c.​

Accepted Answer

The answer of In an arithmetic expression,multiplication and ____________________ are...

Question 20

Contents of the BOOKS table
 
-Based upon the contents of the BOOKS table,which of the following columns will be displayed with a right-aligned column heading?​

Accepted Answer

A)   ​title
B)   ​pubdate
C)   ​category
D)   ​pubidE) A) and B)
F) A) and C)

Exam 2: Basic SQL Select Statements

Contents of the BOOKS table -Based upon the contents of the BOOKS table,which of the following columns will be displayed with a right-aligned column heading?​

Correct AnswerverifiedShow Answer

Choosing specific columns in a SELECT statement is known as ____________________.​

Correct AnswerverifiedShow Answer

By default,the data for character fields are displayed ____________________ aligned when they are displayed.​

Correct AnswerverifiedShow Answer

Contents of the PUBLISHER table ​ -Based upon the contents of the PUBLISHER table,which of the following SQL statements will execute without returning an error message?​

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The optional keyword ____________________ can be used to distinguish between a column name and a column alias.​

Correct AnswerverifiedShow Answer

In an arithmetic expression,multiplication and ____________________ are always solved first in Oracle 12c.​

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Contents of the BOOKS table -Which of the following is a valid SQL statement?​

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The name of the table containing the data to be retrieved is specified in the ____________________ clause.​

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Contents of the BOOKS table -Based upon the contents of the BOOKS table,which of the following SQL statements will display two columns in its output?​

Correct AnswerverifiedShow Answer

When should double-quotation marks (" ")be used in a SELECT statement?​

Correct AnswerverifiedDouble-quotation marks are used when a c...View AnswerShow Answer

Contents of the BOOKS table -Based upon the contents of the BOOKS table,which of the following columns will be displayed with a right-aligned column heading?

Correct Answer
verified

Choosing specific columns in a SELECT statement is known as ____________________.

Correct Answer
verified

By default,the data for character fields are displayed ____________________ aligned when they are displayed.

Correct Answer
verified

Contents of the PUBLISHER table -Based upon the contents of the PUBLISHER table,which of the following SQL statements will execute without returning an error message?

Correct Answer
verified

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?

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

The optional keyword ____________________ can be used to distinguish between a column name and a column alias.

Correct Answer
verified

In an arithmetic expression,multiplication and ____________________ are always solved first in Oracle 12c.

Correct Answer
verified

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

Correct Answer
verified

Contents of the BOOKS table -Which of the following is a valid SQL statement?

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

The name of the table containing the data to be retrieved is specified in the ____________________ clause.

Correct Answer
verified

Correct Answer
verified

Contents of the BOOKS table -Based upon the contents of the BOOKS table,which of the following SQL statements will display two columns in its output?

Correct Answer
verified

When should double-quotation marks (" ")be used in a SELECT statement?

Correct Answer
verified
Double-quotation marks are used when a c...
View Answer