Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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 4

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 5

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

Question 6

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 7

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 8

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 9

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)  ​pubid 
A)  ​title 
B)  ​pubdate 
C)  ​category 
D)  ​pubid

Question 10

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

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 12

Which of the following are case sensitive in Oracle 12c?​

Accepted Answer

A)  ​none of the above 
B)  ​table names 
C)  ​column names 
D)  ​keywords 
A)  ​none of the above 
B)  ​table names 
C)  ​column names 
D)  ​keywords

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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

Question 15

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

Accepted Answer

Double-quotation marks are used when a c

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

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

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

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

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

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

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

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

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?

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

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?

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

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?

The DIST or UNIQ keywords can be used to suppress duplicate data in the results of a SELECT statement.

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

Which of the following are case sensitive in Oracle 12c?

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

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?

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

​The DIST or UNIQ keywords can be used to suppress duplicate data in the results of a SELECT statement.

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

Which of the following are case sensitive in Oracle 12c?​

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

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

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

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

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

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

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

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

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

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

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

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

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?

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

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?

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

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?

The DIST or UNIQ keywords can be used to suppress duplicate data in the results of a SELECT statement.

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

Which of the following are case sensitive in Oracle 12c?

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

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?

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

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

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

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

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

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