Question 1

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) B) and C)
F) None of the above

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

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

Question 4

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 5

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

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

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

Question 7

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 8

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 B)
F) A) and C)

Question 9

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 10

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) B) and C)
F) None of the above

Question 11

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 12

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

Accepted Answer

A) True 
 B)False

Question 13

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 14

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 B)
F) C) and D)

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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 17

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

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 D)
F) All of the above

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A) True 
 B)False

Exam 2: Basic SQL Select Statements

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

Correct AnswerverifiedShow Answer

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

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

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

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

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

Correct AnswerverifiedShow Answer

Which of the following are case sensitive 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

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

Correct AnswerverifiedShow Answer

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

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

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

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

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct Answer
verified

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

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

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

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

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

Correct Answer
verified

Which of the following are case sensitive 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

Correct Answer
verified

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

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

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

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

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified