Question 1

A user can indicate that all columns of a table should be displayed in the results of a SELECT statement by including an asterisk (*) in the SELECT clause.

Accepted Answer

A) True 
 B)False  True

Question 2

____________________ statements can be used to retrieve data from database tables.

Accepted Answer

SELECT

Question 3

The asterisk symbol (*) can be used in a SELECT statement to indicate that all rows in the table should be displayed in the results.

Accepted Answer

A) True 
 B)False  False

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 * FROM books; 
B)  SELECT title, retail-cost "Profit" FROM books; 
C)  SELECT DISTINCT title FROM books; 
D)  all of the above 
A)  SELECT * FROM books; 
B)  SELECT title, retail-cost "Profit" FROM books; 
C)  SELECT DISTINCT title FROM books; 
D)  all of the above

Question 5

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)  * 
A)  , 
B)  " " 
C)  ' ' 
D)  *

Question 6

What are the mandatory clauses of a SELECT statement and what do they represent?

Accepted Answer

The only mandatory clauses of a SELECT s

Question 7

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

Accepted Answer

The answer of Combining the contents of two or more...

Question 8

Structure of the ORDERS table
  
-Which of the following is a valid SQL statement to retrieve data from the ORDERS table?

Accepted Answer

A)  SELECT DISTINCT customer#, DISTINCT order# FROM orders; 
B)  SELECT customer#, street, city, state, zip FROM orders; 
C)  SELECT order#, orderdate, shipdate FROM orders; 
D)  all of the above 
A)  SELECT DISTINCT customer#, DISTINCT order# FROM orders; 
B)  SELECT customer#, street, city, state, zip FROM orders; 
C)  SELECT order#, orderdate, shipdate FROM orders; 
D)  all of the above

Question 9

A(n)$\underline {   \text { WHERE } }$ statement allows a user to retrieve data from a database table. _________________________

Accepted Answer

A) True 
 B)False

Question 10

Contents of the BOOKS table
  
-Based upon the contents of the BOOKS table, which of the following SQL statements will display five rows in its results?

Accepted Answer

A)  SELECT DISTINCT category FROM books; 
B)  SELECT DISTINCT pubid FROM books; 
C)  SELECT UNIQUE pubid, title FROM books; 
D)  both b and c 
A)  SELECT DISTINCT category FROM books; 
B)  SELECT DISTINCT pubid FROM books; 
C)  SELECT UNIQUE pubid, title FROM books; 
D)  both b and c

Question 11

A(n) ____________________ can consist of numbers, characters, or special symbols that should be included in the output exactly as entered by the user.

Accepted Answer

The answer of A(n) ____________________ can consist of numbers, characters,...

Question 12

Which of the following is a mandatory clause in a SELECT statement?

Accepted Answer

A)  FROM 
B)  WHERE 
C)  HAVING 
D)  both a and b are mandatory 
A)  FROM 
B)  WHERE 
C)  HAVING 
D)  both a and b are mandatory

Question 13

Contents of the BOOKS table
  
-Which of the following will display the ISBN column of the BOOKS table as the first column in its results?

Accepted Answer

A)  SELECT * FROM books; 
B)  SELECT DISTINCT category, ISBN FROM books; 
C)  SELECT ISBN, title FROM books; 
D)  both a and c above 
A)  SELECT * FROM books; 
B)  SELECT DISTINCT category, ISBN FROM books; 
C)  SELECT ISBN, title FROM books; 
D)  both a and c above

Question 14

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

Accepted Answer

A)  select pubid, isbn, from books; 
B)  select * FROM pubid; 
C)  select pubid, "Publisher ID" from books; 
D)  none of the above 
A)  select pubid, isbn, from books; 
B)  select * FROM pubid; 
C)  select pubid, "Publisher ID" from books; 
D)  none of the above

Question 15

A script file containing SQL statements can be executed from SQL*Plus.

Accepted Answer

A) True 
 B)False

Question 16

The ____________________ keyword can be included in a SELECT statement to suppress the display of duplicate data.

Accepted Answer

The answer of The ____________________ keyword can be included in...

Question 17

If you assign a column alias to a column, it must be enclosed in double quotation marks (" ").

Accepted Answer

A) True 
 B)False

Question 18

By default, data within a numeric column is $\underline {\text { right } }$-aligned when it is displayed. _________________________

Accepted Answer

A) True 
 B)False

Question 19

If a column heading is longer than the assigned width of a character column, the column heading will be ____________________.

Accepted Answer

The answer of If a column heading is longer than...

Question 20

Contents of the BOOKS table
  
-Based upon the contents of the BOOKS table, which of the following SQL statements will display the retail price for two copies of each book currently in inventory?

Accepted Answer

A)  SELECT * FROM books; 
B)  SELECT title, retail+retail FROM books; 
C)  SELECT title, retail^2 FROM books; 
D)  none of the above 
A)  SELECT * FROM books; 
B)  SELECT title, retail+retail FROM books; 
C)  SELECT title, retail^2 FROM books; 
D)  none of the above

A user can indicate that all columns of a table should be displayed in the results of a SELECT statement by including an asterisk (*) in the SELECT clause.

____________________ statements can be used to retrieve data from database tables.

The asterisk symbol (*) can be used in a SELECT statement to indicate that all rows in the table should be displayed in the results.

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?

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?

What are the mandatory clauses of a SELECT statement and what do they represent?

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

Structure of the ORDERS table -Which of the following is a valid SQL statement to retrieve data from the ORDERS table?

A(n) $\underline { \text { WHERE } }$ statement allows a user to retrieve data from a database table. _________________________

Contents of the BOOKS table -Based upon the contents of the BOOKS table, which of the following SQL statements will display five rows in its results?

A(n) ____________________ can consist of numbers, characters, or special symbols that should be included in the output exactly as entered by the user.

Which of the following is a mandatory clause in a SELECT statement?

Contents of the BOOKS table -Which of the following will display the ISBN column of the BOOKS table as the first column in its results?

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

A script file containing SQL statements can be executed from SQL*Plus.

The ____________________ keyword can be included in a SELECT statement to suppress the display of duplicate data.

If you assign a column alias to a column, it must be enclosed in double quotation marks (" ").

By default, data within a numeric column is $\underline {\text { right } }$ -aligned when it is displayed. _________________________

If a column heading is longer than the assigned width of a character column, the column heading will be ____________________.

Contents of the BOOKS table -Based upon the contents of the BOOKS table, which of the following SQL statements will display the retail price for two copies of each book currently in inventory?

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

A user can indicate that all columns of a table should be displayed in the results of a SELECT statement by including an asterisk (*) in the SELECT clause.

____________________ statements can be used to retrieve data from database tables.

The asterisk symbol (*) can be used in a SELECT statement to indicate that all rows in the table should be displayed in the results.

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?

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?

What are the mandatory clauses of a SELECT statement and what do they represent?

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

Structure of the ORDERS table -Which of the following is a valid SQL statement to retrieve data from the ORDERS table?

A(n) WHERE ‾\underline { \text { WHERE } } WHERE ​ statement allows a user to retrieve data from a database table. _________________________

Contents of the BOOKS table -Based upon the contents of the BOOKS table, which of the following SQL statements will display five rows in its results?

A(n) ____________________ can consist of numbers, characters, or special symbols that should be included in the output exactly as entered by the user.

Which of the following is a mandatory clause in a SELECT statement?

Contents of the BOOKS table -Which of the following will display the ISBN column of the BOOKS table as the first column in its results?

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

A script file containing SQL statements can be executed from SQL*Plus.

The ____________________ keyword can be included in a SELECT statement to suppress the display of duplicate data.

If you assign a column alias to a column, it must be enclosed in double quotation marks (" ").

By default, data within a numeric column is right ‾\underline {\text { right } } right ​ -aligned when it is displayed. _________________________

If a column heading is longer than the assigned width of a character column, the column heading will be ____________________.

Contents of the BOOKS table -Based upon the contents of the BOOKS table, which of the following SQL statements will display the retail price for two copies of each book currently in inventory?

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

A(n) $\underline { \text { WHERE } }$ statement allows a user to retrieve data from a database table. _________________________

By default, data within a numeric column is $\underline {\text { right } }$ -aligned when it is displayed. _________________________