Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

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

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

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

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

Question 6

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 7

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

Accepted Answer

A) True 
 B)False

Question 8

A column alias must be contained within double quotation marks (" ")  if it contains which of the following?

Accepted Answer

A)   blank spaces
B)   special symbols
C)   characters that should be displayed in lower or mixed case
D)   all of the above

Question 9

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)   SELECT title, cost+.20 "New Retail Price" FROM books;
B)   SELECT title, cost*.20 "New Retail Price" FROM books;
C)   SELECT title, cost*1.20 "New Retail Price" FROM books;
D)   none of the above

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 name FROM publisher;
C)   SELECT pubid "PUBLISHER ID" name FROM publisher;
D)   all of the above

Question 11

Structure of the ORDERS table
 
-Which of the following statements can be used to view the structure of the ORDERS table?

Accepted Answer

A)   SELECT * FROM orders;
B)   DESCRIBE ORDERS
C)   LIST ORDERS;
D)   none of the above

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

A query is accomplished by issuing a SELECT statement.

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

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

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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?

Accepted Answer

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

Question 18

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

Accepted Answer

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

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A) True 
 B)False

Exam 2: Basic Sql Select Statements

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

A column alias must be contained within double quotation marks (" ") if it contains which of the following?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

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

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

Correct AnswerverifiedShow Answer

A query is accomplished by issuing a SELECT statement.

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

Structure of the ORDERS table -Which of the following statements can be used to view the structure of the ORDERS table?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

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

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

Correct AnswerverifiedShow Answer

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

Correct Answer
verified

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

Correct Answer
verified

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

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

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified