Question 1

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

Question 2

A(n) ____________________ is an alternative column heading displayed in the output of a query.

Accepted Answer

The answer of A(n) ____________________ is an alternative column heading...

Question 3

A string literal must be enclosed in ____.

Accepted Answer

A)  single quotation marks (' ') 
B)  double quotation marks (" ") 
C)  asterisks (* *) 
D)  percent signs (% %) 
A)  single quotation marks (' ') 
B)  double quotation marks (" ") 
C)  asterisks (* *) 
D)  percent signs (% %)

Question 4

The$\underline { \text { ALL }   }$option can be used in the SELECT clause to indicate that all columns should be retrieved. _________________________

Accepted Answer

A) True 
 B)False

Question 5

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 6

The entire column heading for a column will be displayed, regardless of the assigned width of the column, if the column is defined as a(n) ____ column.

Accepted Answer

A)  character 
B)  alphanumeric 
C)  date 
D)  numeric 
A)  character 
B)  alphanumeric 
C)  date 
D)  numeric

Question 7

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

Accepted Answer

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

Question 8

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

Accepted Answer

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

Question 9

The only required clauses for a SELECT statement are the $\underline {\text { WHERE }}$ and FROM clauses. _________________________

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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

Question 12

A column heading that is longer than the width of a column will not be truncated for a column that is defined to store $\underline { \text { character } }$ data. _________________________

Accepted Answer

A) True 
 B)False

Question 13

A ____________________ is used to end a SQL statement.

Accepted Answer

The answer of A ____________________ is used to end a...

Question 14

A string literal must be enclosed in ____________________ marks.

Accepted Answer

single quo

Question 15

If a column alias contains a blank space, it must be enclosed in $\underline {\text { double } }$ quotation marks. _________________________

Accepted Answer

A) True 
 B)False

Question 16

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 17

Each section of a statement that begins with a keyword is known as a(n) $\underline {  \text { buffer }  }$. _________________________

Accepted Answer

A) True 
 B)False

Question 18

In a(n) $\underline {\text { SELECT } }$statement, keywords, table names, and column names are not case sensitive. _________________________

Accepted Answer

A) True 
 B)False

Question 19

When solving arithmetic expressions, Oracle11g always resolves addition and subtraction operations $\underline {\text { first } }$ from left to right in the expression. _________________________

Accepted Answer

A) True 
 B)False

Question 20

Choosing specific columns from a database through a SELECT statement is known as $\underline {\text { projection }}$_________________________

Accepted Answer

A) True 
 B)False

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

A(n) ____________________ is an alternative column heading displayed in the output of a query.

A string literal must be enclosed in ____.

The $\underline { \text { ALL } }$ option can be used in the SELECT clause to indicate that all columns should be retrieved. _________________________

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

The entire column heading for a column will be displayed, regardless of the assigned width of the column, if the column is defined as a(n) ____ column.

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

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

The only required clauses for a SELECT statement are the $\underline {\text { WHERE }}$ and FROM clauses. _________________________

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

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

A column heading that is longer than the width of a column will not be truncated for a column that is defined to store $\underline { \text { character } }$ data. _________________________

A ____________________ is used to end a SQL statement.

A string literal must be enclosed in ____________________ marks.

If a column alias contains a blank space, it must be enclosed in $\underline {\text { double } }$ quotation marks. _________________________

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?

Each section of a statement that begins with a keyword is known as a(n) $\underline { \text { buffer } }$ . _________________________

In a(n) $\underline {\text { SELECT } }$ statement, keywords, table names, and column names are not case sensitive. _________________________

When solving arithmetic expressions, Oracle11g always resolves addition and subtraction operations $\underline {\text { first } }$ from left to right in the expression. _________________________

Choosing specific columns from a database through a SELECT statement is known as $\underline {\text { projection }}$ _________________________

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, the data for character fields are displayed ____________________ aligned when they are displayed.

A(n) ____________________ is an alternative column heading displayed in the output of a query.

A string literal must be enclosed in ____.

The ALL ‾\underline { \text { ALL } } ALL ​ option can be used in the SELECT clause to indicate that all columns should be retrieved. _________________________

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

The entire column heading for a column will be displayed, regardless of the assigned width of the column, if the column is defined as a(n) ____ column.

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

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

The only required clauses for a SELECT statement are the WHERE ‾\underline {\text { WHERE }} WHERE ​ and FROM clauses. _________________________

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

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

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 ‾\underline { \text { character } } character ​ data. _________________________

A ____________________ is used to end a SQL statement.

A string literal must be enclosed in ____________________ marks.

If a column alias contains a blank space, it must be enclosed in double ‾\underline {\text { double } } double ​ quotation marks. _________________________

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?

Each section of a statement that begins with a keyword is known as a(n) buffer ‾\underline { \text { buffer } } buffer ​ . _________________________

In a(n) SELECT ‾\underline {\text { SELECT } } SELECT ​ statement, keywords, table names, and column names are not case sensitive. _________________________

When solving arithmetic expressions, Oracle11g always resolves addition and subtraction operations first ‾\underline {\text { first } } first ​ from left to right in the expression. _________________________

Choosing specific columns from a database through a SELECT statement is known as projection ‾\underline {\text { projection }} projection ​ _________________________

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 $\underline { \text { ALL } }$ option can be used in the SELECT clause to indicate that all columns should be retrieved. _________________________

The only required clauses for a SELECT statement are the $\underline {\text { WHERE }}$ and FROM clauses. _________________________

A column heading that is longer than the width of a column will not be truncated for a column that is defined to store $\underline { \text { character } }$ data. _________________________

If a column alias contains a blank space, it must be enclosed in $\underline {\text { double } }$ quotation marks. _________________________

Each section of a statement that begins with a keyword is known as a(n) $\underline { \text { buffer } }$ . _________________________

In a(n) $\underline {\text { SELECT } }$ statement, keywords, table names, and column names are not case sensitive. _________________________

When solving arithmetic expressions, Oracle11g always resolves addition and subtraction operations $\underline {\text { first } }$ from left to right in the expression. _________________________

Choosing specific columns from a database through a SELECT statement is known as $\underline {\text { projection }}$ _________________________