Question 1

You can include ____________________ to override the order of operations when solving arithmetic expressions.​

Accepted Answer

The answer of You can include ____________________ to override the...

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A)  ​SELECT contact Contact's Name
FROM publisher; 
B)  ​SELECT publisherID
FROM publisher; 
C)  ​SELECT contact,name
FROM publisher; 
D)  ​SELECT name
FROM publishers; 
A)  ​SELECT contact Contact's Name
FROM publisher; 
B)  ​SELECT publisherID
FROM publisher; 
C)  ​SELECT contact,name
FROM publisher; 
D)  ​SELECT name
FROM publishers;

Question 4

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

Question 5

​If multiple column names are listed in the SELECT clause of a SELECT statement,the columns must be separated by a comma (,).

Accepted Answer

A) True 
 B)False

Question 6

The syntax for a SQL statement gives the basic structure required to execute the statement.
​_________________________

Accepted Answer

A) True 
 B)False

Question 7

​Parentheses can be used to override the order of operations in an arithmetic expression.

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

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

Question 9

When a user asks the database a question,the user is issuing a query.​

Accepted Answer

A) True 
 B)False

Question 10

The ____________________ command can be used to display the structure of a table.​

Accepted Answer

The answer of The ____________________ command can be used to...

Question 11

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 12

A(n)____ has a predefined meaning in Oracle 12c.​

Accepted Answer

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

Question 13

Structure of the ORDERS table
  
-Based upon the structure of the ORDERS table,the column heading for which column will be truncated in the results?​

Accepted Answer

A)  ​shipstreet 
B)  ​orderdate 
C)  ​customer# 
D)  ​shipzip 
A)  ​shipstreet 
B)  ​orderdate 
C)  ​customer# 
D)  ​shipzip

Question 14

​The only required clauses for a SELECT statement are the WHERE and FROM clauses._________________________

Accepted Answer

A) True 
 B)False

Question 15

What is the correct answer for the arithmetic expression 9+2*3-2 using the order of operations employed by Oracle 12c when solving equations?​

Accepted Answer

A)  ​13 
B)  ​10 
C)  ​12 
D)  ​31 
A)  ​13 
B)  ​10 
C)  ​12 
D)  ​31

Question 16

What is used to indicate the end of an SQL statement?​

Accepted Answer

A)  ​: 
B)  ​; 
C)  ​/ 
D)  ​* 
A)  ​: 
B)  ​; 
C)  ​/ 
D)  ​*

Question 17

Contents of the PUBLISHER table
   ​
-Based upon the contents of the PUBLISHER table,which of the following SELECT statements will display the publisher's name first in the results?

Accepted Answer

A)  SELECT * FROM publisher;​ 
B)  ​SELECT name,publisherID FROM publishers; 
C)  ​SELECT pubid,contact FROM publisher; 
D)  ​none of the above 
A)  SELECT * FROM publisher;​ 
B)  ​SELECT name,publisherID FROM publishers; 
C)  ​SELECT pubid,contact FROM publisher; 
D)  ​none of the above

Question 18

The majority of operations performed on a typical database table utilize the SELECT statement.

Accepted Answer

A) True 
 B)False

Question 19

If a column name is entered in lower case in the SELECT statement,the data for the column will be displayed in lower case in the results.​

Accepted Answer

A) True 
 B)False

Question 20

​If a column alias contains a blank space,it must be enclosed in double quotation marks._________________________

Accepted Answer

A) True 
 B)False

You can include ____________________ to override the order of operations when solving arithmetic expressions.

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

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

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?

If multiple column names are listed in the SELECT clause of a SELECT statement,the columns must be separated by a comma (,).

The syntax for a SQL statement gives the basic structure required to execute the statement. _________________________

Parentheses can be used to override the order of operations in an arithmetic expression.

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

When a user asks the database a question,the user is issuing a query.

The ____________________ command can be used to display the structure of a table.

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

A(n)____ has a predefined meaning in Oracle 12c.

Structure of the ORDERS table -Based upon the structure of the ORDERS table,the column heading for which column will be truncated in the results?

The only required clauses for a SELECT statement are the WHERE and FROM clauses._________________________

What is the correct answer for the arithmetic expression 9+2*3-2 using the order of operations employed by Oracle 12c when solving equations?

What is used to indicate the end of an SQL statement?

Contents of the PUBLISHER table -Based upon the contents of the PUBLISHER table,which of the following SELECT statements will display the publisher's name first in the results?

The majority of operations performed on a typical database table utilize the SELECT statement.

If a column name is entered in lower case in the SELECT statement,the data for the column will be displayed in lower case in the results.

If a column alias contains a blank space,it must be enclosed in double quotation marks._________________________

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

You can include ____________________ to override the order of operations when solving arithmetic expressions.​

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

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

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

​If multiple column names are listed in the SELECT clause of a SELECT statement,the columns must be separated by a comma (,).

The syntax for a SQL statement gives the basic structure required to execute the statement. ​_________________________

​Parentheses can be used to override the order of operations in an arithmetic expression.

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

When a user asks the database a question,the user is issuing a query.​

The ____________________ command can be used to display the structure of a table.​

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

A(n)____ has a predefined meaning in Oracle 12c.​

Structure of the ORDERS table -Based upon the structure of the ORDERS table,the column heading for which column will be truncated in the results?​

​The only required clauses for a SELECT statement are the WHERE and FROM clauses._________________________

What is the correct answer for the arithmetic expression 9+2*3-2 using the order of operations employed by Oracle 12c when solving equations?​

What is used to indicate the end of an SQL statement?​

Contents of the PUBLISHER table ​ -Based upon the contents of the PUBLISHER table,which of the following SELECT statements will display the publisher's name first in the results?

The majority of operations performed on a typical database table utilize the SELECT statement.

If a column name is entered in lower case in the SELECT statement,the data for the column will be displayed in lower case in the results.​

​If a column alias contains a blank space,it must be enclosed in double quotation marks._________________________

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

You can include ____________________ to override the order of operations when solving arithmetic expressions.

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

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

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?

If multiple column names are listed in the SELECT clause of a SELECT statement,the columns must be separated by a comma (,).

The syntax for a SQL statement gives the basic structure required to execute the statement. _________________________

Parentheses can be used to override the order of operations in an arithmetic expression.

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

When a user asks the database a question,the user is issuing a query.

The ____________________ command can be used to display the structure of a table.

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

A(n)____ has a predefined meaning in Oracle 12c.

Structure of the ORDERS table -Based upon the structure of the ORDERS table,the column heading for which column will be truncated in the results?

The only required clauses for a SELECT statement are the WHERE and FROM clauses._________________________

What is the correct answer for the arithmetic expression 9+2*3-2 using the order of operations employed by Oracle 12c when solving equations?

What is used to indicate the end of an SQL statement?

Contents of the PUBLISHER table -Based upon the contents of the PUBLISHER table,which of the following SELECT statements will display the publisher's name first in the results?

If a column name is entered in lower case in the SELECT statement,the data for the column will be displayed in lower case in the results.

If a column alias contains a blank space,it must be enclosed in double quotation marks._________________________