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

A query is accomplished by issuing a SELECT statement.

Accepted Answer

A) True 
 B)False

Question 3

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 4

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 
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 5

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 
A)  SELECT * FROM orders; 
B)  DESCRIBE ORDERS 
C)  LIST ORDERS; 
D)  none of the above

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

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

Accepted Answer

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

Question 8

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

Accepted Answer

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

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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 
A)  clauses 
B)  keywords 
C)  sequence 
D)  syntax

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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 
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 13

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

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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 
A)  1.336 
B)  4.8 
C)  15 
D)  14

Question 17

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 
A)  UNIQ 
B)  DISTINCT 
C)  SUPPRESS 
D)  all of the above

Question 18

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 
A)  blank spaces 
B)  special symbols 
C)  characters that should be displayed in lower or mixed case 
D)  all of the above

Question 19

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 20

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

Accepted Answer

A) True 
 B)False

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

A query is accomplished by issuing a SELECT statement.

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

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?

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

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

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

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

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

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

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

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?

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

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

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

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?

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

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

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

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

Overview of Database Concepts

Table Creation and Management

Constraints

Data Manipulation and Transaction Control

Additional Database Objects

User Creation and Management

Restricting Rows and Sorting Data

Joining Data From Multiple Tables

Selected Single Row Functions

Group Functions

Subqueries and Merge Statements

Views

Filters

Exam 2: Basic Sql Select Statements

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

A query is accomplished by issuing a SELECT statement.

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

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?

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

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

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

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

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

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

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

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?

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

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

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

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?

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

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

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

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

Overview of Database Concepts

Table Creation and Management

Constraints

Data Manipulation and Transaction Control

Additional Database Objects

User Creation and Management

Restricting Rows and Sorting Data

Joining Data From Multiple Tables

Selected Single Row Functions

Group Functions

Subqueries and Merge Statements

Views

Filters

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

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

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

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

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