Question 1

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

Accepted Answer

The answer of When resolving arithmetic expressions, Oracle10g always performs...

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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 4

The SELECT clause of the SELECT statement is used to identify which rows are to be retrieved from a specified table.

Accepted Answer

A) True 
 B)False

Question 5

If a column heading is longer than the assigned width of a(n) ____________________ field, the column heading will be truncated.

Accepted Answer

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

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

A string literal must be enclosed in $\underline { \text { double } }$quotation marks. _________________________

Accepted Answer

A) True 
 B)False

Question 8

A(n) $\underline {  \text { CRBMDS }  }$ is a software program that can be used to create a relational database and allows you to enter, manipulate, and retrieve data. _________________________

Accepted Answer

A) True 
 B)False

Question 9

Each clause of a SELECT statement $\underline {\text { must } }$ be entered on a new line in SQL*Plus. _________________________

Accepted Answer

A) True 
 B)False

Question 10

The $\underline {\text { DISTINCT } }$ keyword can be used to indicate that duplicate data should be suppressed in the results of a query. _________________________

Accepted Answer

A) True 
 B)False

Question 11

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 12

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 13

Explain how the DISTINCT keyword effects a SELECT statement that lists two columns in the SELECT clause.

Accepted Answer

The DISTINCT keyword will only suppress

Question 14

A query can be executed in the$\underline{\mathrm{SQL}^{*} \text { Plus }}$tool. _________________________

Accepted Answer

A) True 
 B)False

Question 15

Which of the following symbols represents all the columns contained in a table?

Accepted Answer

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

Question 16

To indicate which database table contains the data to be selected by a query, the table name should be listed in the ____ clause.

Accepted Answer

A)  SELECT 
B)  FROM 
C)  WHERE 
D)  HAVING 
A)  SELECT 
B)  FROM 
C)  WHERE 
D)  HAVING

Question 17

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 contact, name
FROM publisher; 
C)  SELECT publisherID
FROM publisher; 
D)  SELECT name
FROM publishers; 
A)  SELECT contact Contact's Name
FROM publisher; 
B)  SELECT contact, name
FROM publisher; 
C)  SELECT publisherID
FROM publisher; 
D)  SELECT name
FROM publishers;

Question 18

If a column alias contains a blank space, it 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 19

Which of the following commands is used to issue a query?

Accepted Answer

A)  QUER 
B)  FROM 
C)  SELECT 
D)  QUESTION 
A)  QUER 
B)  FROM 
C)  SELECT 
D)  QUESTION

Question 20

The following arithmetic operations can be performed in the SELECT clause of a SELECT statement: addition (+), subtraction (-), multiplication (*), division (/), and exponential (^).

Accepted Answer

A) True 
 B)False

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

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

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

The SELECT clause of the SELECT statement is used to identify which rows are to be retrieved from a specified table.

If a column heading is longer than the assigned width of a(n) ____________________ field, the column heading will be truncated.

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

A string literal must be enclosed in $\underline { \text { double } }$ quotation marks. _________________________

A(n) $\underline { \text { CRBMDS } }$ is a software program that can be used to create a relational database and allows you to enter, manipulate, and retrieve data. _________________________

Each clause of a SELECT statement $\underline {\text { must } }$ be entered on a new line in SQL*Plus. _________________________

The $\underline {\text { DISTINCT } }$ keyword can be used to indicate that duplicate data should be suppressed in the results of a query. _________________________

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

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

Explain how the DISTINCT keyword effects a SELECT statement that lists two columns in the SELECT clause.

A query can be executed in the $\underline{\mathrm{SQL}^{*} \text { Plus }}$ tool. _________________________

Which of the following symbols represents all the columns contained in a table?

To indicate which database table contains the data to be selected by a query, the table name should be listed in the ____ clause.

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

If a column alias contains a blank space, it must be enclosed in ____.

Which of the following commands is used to issue a query?

The following arithmetic operations can be performed in the SELECT clause of a SELECT statement: addition (+), subtraction (-), multiplication (*), division (/), and exponential (^).

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

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

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

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

The SELECT clause of the SELECT statement is used to identify which rows are to be retrieved from a specified table.

If a column heading is longer than the assigned width of a(n) ____________________ field, the column heading will be truncated.

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

A string literal must be enclosed in double ‾\underline { \text { double } } double ​ quotation marks. _________________________

A(n) CRBMDS ‾\underline { \text { CRBMDS } } CRBMDS ​ is a software program that can be used to create a relational database and allows you to enter, manipulate, and retrieve data. _________________________

Each clause of a SELECT statement must ‾\underline {\text { must } } must ​ be entered on a new line in SQL*Plus. _________________________

The DISTINCT ‾\underline {\text { DISTINCT } } DISTINCT ​ keyword can be used to indicate that duplicate data should be suppressed in the results of a query. _________________________

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

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

Explain how the DISTINCT keyword effects a SELECT statement that lists two columns in the SELECT clause.

A query can be executed in the SQL∗ Plus ‾\underline{\mathrm{SQL}^{*} \text { Plus }}SQL∗ Plus ​ tool. _________________________

Which of the following symbols represents all the columns contained in a table?

To indicate which database table contains the data to be selected by a query, the table name should be listed in the ____ clause.

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

If a column alias contains a blank space, it must be enclosed in ____.

Which of the following commands is used to issue a query?

The following arithmetic operations can be performed in the SELECT clause of a SELECT statement: addition (+), subtraction (-), multiplication (*), division (/), and exponential (^).

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, data within a character or data column is $\underline { \text { right } }$ -aligned when it is displayed. _________________________

A string literal must be enclosed in $\underline { \text { double } }$ quotation marks. _________________________

A(n) $\underline { \text { CRBMDS } }$ is a software program that can be used to create a relational database and allows you to enter, manipulate, and retrieve data. _________________________

Each clause of a SELECT statement $\underline {\text { must } }$ be entered on a new line in SQL*Plus. _________________________

The $\underline {\text { DISTINCT } }$ keyword can be used to indicate that duplicate data should be suppressed in the results of a query. _________________________

A query can be executed in the $\underline{\mathrm{SQL}^{*} \text { Plus }}$ tool. _________________________