Question 1

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 2

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 NameFROM publisher;
B)   SELECT contact, nameFROM publisher;
C)   SELECT publisherIDFROM publisher;
D)   SELECT nameFROM publishers;E) A) and C)
F) A) and D)

Question 3

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 4

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)   HAVINGE) B) and D)
F) A) and C)

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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 7

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

Accepted Answer

A)   /
B)   ;
C)   *
D)   ^E) A) and B)
F) A) and C)

Question 8

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

Question 9

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 10

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

Accepted Answer

A) True 
 B)False

Question 11

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 12

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 13

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 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 commands is used to issue a query?

Accepted Answer

A)   QUER
B)   FROM
C)   SELECT
D)   QUESTIONE) B) and D)
F) B) and C)

Question 16

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 (% %) E) A) and B)
F) All of the above

Question 17

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 18

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 19

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 20

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

Exam 2: Basic Sql Select Statements

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedThe DISTINCT keyword will only suppress ...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Correct Answer
verified

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

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

Correct Answer
verified
The DISTINCT keyword will only suppress ...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

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

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified