Question 1

Which of the following statements is correct?

Accepted Answer

A)  The columns will be listed in the results in the same order they are stored in the database table. 
B)  Character columns are listed first in the output, followed by numeric columns. 
C)  The columns will be listed in the results in the same order they are listed in the SELECT clause of the SELECT statement. 
D)  Numeric columns are listed first in the output, followed by character columns. 
A)  The columns will be listed in the results in the same order they are stored in the database table. 
B)  Character columns are listed first in the output, followed by numeric columns. 
C)  The columns will be listed in the results in the same order they are listed in the SELECT clause of the SELECT statement. 
D)  Numeric columns are listed first in the output, followed by character columns.

Question 2

Contents of the PUBLISHER table
  
-Based upon the contents of the PUBLISHER table, which of the following SQL statements will display only two columns in the results?

Accepted Answer

A)  SELECT * FROM publisher; 
B)  SELECT contact name FROM publisher; 
C)  SELECT contact person, name FROM publisher; 
D)  none of the above 
A)  SELECT * FROM publisher; 
B)  SELECT contact name FROM publisher; 
C)  SELECT contact person, name FROM publisher; 
D)  none of the above

Question 3

When a user asks the database a question, the user is issuing a query.

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

Double-quotation marks are used when a c

Question 5

Which of the following types of columns will automatically left-align the column heading when it is displayed?

Accepted Answer

A)  character 
B)  numeric 
C)  date 
D)  both a and c 
A)  character 
B)  numeric 
C)  date 
D)  both a and c

Question 6

Contents of the PUBLISHER table
  
-Based upon the contents of the PUBLISHER table, which of the following SELECT statements will display the publisher's name first in the results?

Accepted Answer

A)  SELECT * FROM publisher; 
B)  SELECT pubid, contact FROM publisher; 
C)  SELECT name, publisherID FROM publishers; 
D)  none of the above 
A)  SELECT * FROM publisher; 
B)  SELECT pubid, contact FROM publisher; 
C)  SELECT name, publisherID FROM publishers; 
D)  none of the above

Question 7

Oracle11g comes in ________________________________________ editions.

Accepted Answer

Three (per

Question 8

The DESCRIBE command is used to view data in a table.

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A)  SELECT * FROM publisher; 
B)  SELECT name, contact FROM publisher/ 
C)  SELECT name, phone
FROM publisher
/ 
D)  SELECT *
FROM publisher; 
A)  SELECT * FROM publisher; 
B)  SELECT name, contact FROM publisher/ 
C)  SELECT name, phone
FROM publisher
/ 
D)  SELECT *
FROM publisher;

Question 10

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 11

Structure of the ORDERS table
  
-Which of the following is a valid SELECT statement?

Accepted Answer

A)  SELECT order#, || ' was shipped on ' || shipdate; 
B)  SELECT order# || ' was shipped on ' || shipdate; 
C)  SELECT order# || " was shipped on " || shipdate; 
D)  none of the above 
A)  SELECT order#, || ' was shipped on ' || shipdate; 
B)  SELECT order# || ' was shipped on ' || shipdate; 
C)  SELECT order# || " was shipped on " || shipdate; 
D)  none of the above

Question 12

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

Accepted Answer

A)  SELECT title, retail-cost FROM books; 
B)  SELECT title, retail-cost "Profit" 
C)  SELECT DISTINCT title, category
FROM books/ 
D)  all of the above 
A)  SELECT title, retail-cost FROM books; 
B)  SELECT title, retail-cost "Profit" 
C)  SELECT DISTINCT title, category
FROM books/ 
D)  all of the above

Question 13

What is the correct answer for the arithmetic expression 9+2*3-2 using the order of operations employed by Oracle10g when solving equations?

Accepted Answer

A)  13 
B)  31 
C)  10 
D)  12 
A)  13 
B)  31 
C)  10 
D)  12

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

A double backslash (\) is used to indicate concatenation in a SELECT statement.

Accepted Answer

A) True 
 B)False

Question 16

In an arithmetic expression, multiplication and ____________________ are always solved first in Oracle11g.

Accepted Answer

The answer of In an arithmetic expression, multiplication and ____________________...

Question 17

The majority of operations performed on a typical database table utilize the SELECT statement.

Accepted Answer

A) True 
 B)False

Question 18

Parentheses can be used to override the order of operations in an arithmetic expression.

Accepted Answer

A) True 
 B)False

Question 19

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 * FROM pubid; 
B)  SELECT * FROM name; 
C)  SELECT * FROM contact; 
D)  SELECT * FROM publisher; 
A)  SELECT * FROM pubid; 
B)  SELECT * FROM name; 
C)  SELECT * FROM contact; 
D)  SELECT * FROM publisher;

Question 20

What is the correct answer for the arithmetic expression 9+2*(3-4) using the order of operations employed by Oracle10g when solving equations?

Accepted Answer

A)  -11 
B)  -18 
C)  9 
D)  7 
A)  -11 
B)  -18 
C)  9 
D)  7

Which of the following statements is correct?

Contents of the PUBLISHER table -Based upon the contents of the PUBLISHER table, which of the following SQL statements will display only two columns in the results?

When a user asks the database a question, the user is issuing a query.

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

Which of the following types of columns will automatically left-align the column heading when it is displayed?

Contents of the PUBLISHER table -Based upon the contents of the PUBLISHER table, which of the following SELECT statements will display the publisher's name first in the results?

Oracle11g comes in ________________________________________ editions.

The DESCRIBE command is used to view data in a table.

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

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

Structure of the ORDERS table -Which of the following is a valid SELECT statement?

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

What is the correct answer for the arithmetic expression 9+2*3-2 using the order of operations employed by Oracle10g when solving equations?

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

A double backslash (\\) is used to indicate concatenation in a SELECT statement.

In an arithmetic expression, multiplication and ____________________ are always solved first in Oracle11g.

The majority of operations performed on a typical database table utilize the SELECT statement.

Parentheses can be used to override the order of operations in an arithmetic expression.

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

What is the correct answer for the arithmetic expression 9+2*(3-4) using the order of operations employed by Oracle10g when solving equations?

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

Which of the following statements is correct?

Contents of the PUBLISHER table -Based upon the contents of the PUBLISHER table, which of the following SQL statements will display only two columns in the results?

When a user asks the database a question, the user is issuing a query.

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

Which of the following types of columns will automatically left-align the column heading when it is displayed?

Contents of the PUBLISHER table -Based upon the contents of the PUBLISHER table, which of the following SELECT statements will display the publisher's name first in the results?

Oracle11g comes in ________________________________________ editions.

The DESCRIBE command is used to view data in a table.

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

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

Structure of the ORDERS table -Which of the following is a valid SELECT statement?

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

What is the correct answer for the arithmetic expression 9+2*3-2 using the order of operations employed by Oracle10g when solving equations?

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

A double backslash (\\) is used to indicate concatenation in a SELECT statement.

In an arithmetic expression, multiplication and ____________________ are always solved first in Oracle11g.

The majority of operations performed on a typical database table utilize the SELECT statement.

Parentheses can be used to override the order of operations in an arithmetic expression.

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

What is the correct answer for the arithmetic expression 9+2*(3-4) using the order of operations employed by Oracle10g when solving equations?

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