Question 1

​The optional keyword AS can be used to indicate that the subsequent string of characters is a column alias.

Accepted Answer

A) True 
 B)False

Question 2

Each clause of a SELECT statement must be entered on a new line in SQL*Plus._________________________​

Accepted Answer

A) True 
 B)False

Question 3

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

Question 4

Column headings may be truncated in the results of a SELECT statement.

Accepted Answer

A) True 
 B)False

Question 5

A column heading that is longer than the width of a column will not be truncated for a column that is defined to store character data._________________________

Accepted Answer

A) True 
 B)False

Question 6

When resolving arithmetic expressions,Oracle 12c always performs the operations by starting on the ____________________ side of the expression.​

Accepted Answer

The answer of When resolving arithmetic expressions,Oracle 12c always performs...

Question 7

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

Accepted Answer

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

Question 8

​Choosing specific columns from a database through a SELECT statement is known as projection._________________________

Accepted Answer

A) True 
 B)False

Question 9

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 * FROM pubid; 
B)  ​select pubid,"Publisher ID" from books; 
C)  ​select pubid,isbn,from books; 
D)  ​none of the above 
A)  ​select * FROM pubid; 
B)  ​select pubid,"Publisher ID" from books; 
C)  ​select pubid,isbn,from books; 
D)  ​none of the above

Question 10

A query can be executed in the SQL*Plus tool._________________________​

Accepted Answer

A) True 
 B)False

Question 11

SQL*Plus is an Oracle tool used to enter and edit SQL statements.​

Accepted Answer

A) True 
 B)False

Question 12

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 13

A clause is a section within a SQL statement that begins with a keyword.​

Accepted Answer

A) True 
 B)False

Question 14

Which of the following commands can be used to view the structure of a table?​

Accepted Answer

A)  ​SELECT 
B)  ​DESCRIBE 
C)  ​none of the above 
D)  ​CONCATENATION 
A)  ​SELECT 
B)  ​DESCRIBE 
C)  ​none of the above 
D)  ​CONCATENATION

Question 15

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

Accepted Answer

A)  ​14 
B)  ​15 
C)  ​4.8 
D)  ​0.1 
A)  ​14 
B)  ​15 
C)  ​4.8 
D)  ​0.1

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

By default,the data for a numeric column is ____________________ aligned when it is displayed.​

Accepted Answer

The answer of By default,the data for a numeric column...

Question 18

What is the correct solution for the arithmetic expression (2+8)/2*9/3 using the order of operations employed by Oracle 12c when solving equations?​

Accepted Answer

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

Question 19

​The columns displayed in the results of a SELECT statement will be in the same order as they are stored in the database table.

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A) True 
 B)False

The optional keyword AS can be used to indicate that the subsequent string of characters is a column alias.

Each clause of a SELECT statement must be entered on a new line in SQL*Plus._________________________

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.

Column headings may be truncated in the results of a SELECT statement.

A column heading that is longer than the width of a column will not be truncated for a column that is defined to store character data._________________________

When resolving arithmetic expressions,Oracle 12c always performs the operations by starting on the ____________________ side of the expression.

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

Choosing specific columns from a database through a SELECT statement is known as projection._________________________

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

A query can be executed in the SQL*Plus tool._________________________

SQL*Plus is an Oracle tool used to enter and edit SQL statements.

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

A clause is a section within a SQL statement that begins with a keyword.

Which of the following commands can be used to view the structure of a table?

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

When listing more than one column name in the SELECT clause of a SELECT statement,the column names must be separated by semicolons._________________________

By default,the data for a numeric column is ____________________ aligned when it is displayed.

What is the correct solution for the arithmetic expression (2+8)/2*9/3 using the order of operations employed by Oracle 12c when solving equations?

The columns displayed in the results of a SELECT statement will be in the same order as they are stored in the database table.

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

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

​The optional keyword AS can be used to indicate that the subsequent string of characters is a column alias.

Each clause of a SELECT statement must be entered on a new line in SQL*Plus._________________________​

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.

Column headings may be truncated in the results of a SELECT statement.

A column heading that is longer than the width of a column will not be truncated for a column that is defined to store character data._________________________

When resolving arithmetic expressions,Oracle 12c always performs the operations by starting on the ____________________ side of the expression.​

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

​Choosing specific columns from a database through a SELECT statement is known as projection._________________________

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

A query can be executed in the SQL*Plus tool._________________________​

SQL*Plus is an Oracle tool used to enter and edit SQL statements.​

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

A clause is a section within a SQL statement that begins with a keyword.​

Which of the following commands can be used to view the structure of a table?​

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

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

By default,the data for a numeric column is ____________________ aligned when it is displayed.​

What is the correct solution for the arithmetic expression (2+8)/2*9/3 using the order of operations employed by Oracle 12c when solving equations?​

​The columns displayed in the results of a SELECT statement will be in the same order as they are stored in the database table.

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

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

The optional keyword AS can be used to indicate that the subsequent string of characters is a column alias.

Each clause of a SELECT statement must be entered on a new line in SQL*Plus._________________________

When resolving arithmetic expressions,Oracle 12c always performs the operations by starting on the ____________________ side of the expression.

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

Choosing specific columns from a database through a SELECT statement is known as projection._________________________

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

A query can be executed in the SQL*Plus tool._________________________

SQL*Plus is an Oracle tool used to enter and edit SQL statements.

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

A clause is a section within a SQL statement that begins with a keyword.

Which of the following commands can be used to view the structure of a table?

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

When listing more than one column name in the SELECT clause of a SELECT statement,the column names must be separated by semicolons._________________________

By default,the data for a numeric column is ____________________ aligned when it is displayed.

What is the correct solution for the arithmetic expression (2+8)/2*9/3 using the order of operations employed by Oracle 12c when solving equations?

The columns displayed in the results of a SELECT statement will be in the same order as they are stored in the database table.