Question 1

​The 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  True

Question 2

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

Question 3

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

Question 4

Contents of the BOOKS table
  
-Which of the following SQL statements will display the profit generated by each book currently stored in the BOOKS table?​

Accepted Answer

A)  ​SELECT title,retail,cost profit FROM books; 
B)  ​SELECT title,retail-cost FROM books; 
C)  ​all of the above 
D)  ​SELECT * FROM books; 
A)  ​SELECT title,retail,cost profit FROM books; 
B)  ​SELECT title,retail-cost FROM books; 
C)  ​all of the above 
D)  ​SELECT * FROM books;

Question 5

When solving arithmetic expressions,Oracle 12c always resolves addition and subtraction operations first from left to right in the expression._________________________

Accepted Answer

A) True 
 B)False

Question 6

A string literal must be enclosed in ____________________ marks.​

Accepted Answer

single quo

Question 7

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

Accepted Answer

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

Question 8

The SELECT clause identifies the table containing the data to be queried._________________________

Accepted Answer

A) True 
 B)False

Question 9

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)  ​WHERE 
B)  ​SELECT 
C)  ​HAVING 
D)  ​FROM 
A)  ​WHERE 
B)  ​SELECT 
C)  ​HAVING 
D)  ​FROM

Question 10

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

Accepted Answer

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

Question 11

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

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

​Choosing specific columns to be displayed by a SELECT statement is known as selection.

Accepted Answer

A) True 
 B)False

Question 14

Contents of the BOOKS table
  
-Based upon the contents of the BOOKS table,which of the following SQL statements will display five rows in its results?​

Accepted Answer

A)  ​SELECT UNIQUE pubid,title FROM books; 
B)  ​both b and c 
C)  ​SELECT DISTINCT pubid FROM books; 
D)  ​SELECT DISTINCT category FROM books; 
A)  ​SELECT UNIQUE pubid,title FROM books; 
B)  ​both b and c 
C)  ​SELECT DISTINCT pubid FROM books; 
D)  ​SELECT DISTINCT category FROM books;

Question 15

Contents of the BOOKS table
  
-​Based upon the contents of the BOOKS table,which of the following SQL statements will display the retail price for two copies of each book currently in inventory?

Accepted Answer

A)  ​SELECT * FROM books; 
B)  ​SELECT title,retail+retail FROM books; 
C)  ​none of the above 
D)  ​SELECT title,retail^2 FROM books; 
A)  ​SELECT * FROM books; 
B)  ​SELECT title,retail+retail FROM books; 
C)  ​none of the above 
D)  ​SELECT title,retail^2 FROM books;

Question 16

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)  ​none of the above 
C)  ​SELECT contact name FROM publisher; 
D)  ​SELECT contact person,name FROM publisher; 
A)  ​SELECT * FROM publisher; 
B)  ​none of the above 
C)  ​SELECT contact name FROM publisher; 
D)  ​SELECT contact person,name FROM publisher;

Question 17

A(n)____________________ can consist of numbers,characters,or special symbols that should be included in the output exactly as entered by the user.​

Accepted Answer

The answer of A(n)____________________ can consist of numbers,characters,or special symbols...

Question 18

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 19

Each section of a SQL command that begins with a keyword is known as a statement.​

Accepted Answer

A) True 
 B)False

Question 20

Structure of the ORDERS table
  
-Based upon the structure of the ORDERS table,which of the following SQL statements will return an error message upon execution?​

Accepted Answer

A)  ​SELECT order#,"order number" FROM orders; 
B)  ​SELECT order# customer# FROM orders; 
C)  ​SELECT * FROM orders; 
D)  ​both b and c 
A)  ​SELECT order#,"order number" FROM orders; 
B)  ​SELECT order# customer# FROM orders; 
C)  ​SELECT * FROM orders; 
D)  ​both b and c

The DISTINCT keyword can be used to indicate that duplicate data should be suppressed in the results of a query._________________________

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

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

Contents of the BOOKS table -Which of the following SQL statements will display the profit generated by each book currently stored in the BOOKS table?

When solving arithmetic expressions,Oracle 12c always resolves addition and subtraction operations first from left to right in the expression._________________________

A string literal must be enclosed in ____________________ marks.

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

The SELECT clause identifies the table containing the data to be queried._________________________

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

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

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

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

Choosing specific columns to be displayed by a SELECT statement is known as selection.

Contents of the BOOKS table -Based upon the contents of the BOOKS table,which of the following SQL statements will display five rows in its results?

Contents of the BOOKS table -Based upon the contents of the BOOKS table,which of the following SQL statements will display the retail price for two copies of each book currently in inventory?

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?

A(n)____________________ can consist of numbers,characters,or special symbols that should be included in the output exactly as entered by the user.

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

Each section of a SQL command that begins with a keyword is known as a statement.

Structure of the ORDERS table -Based upon the structure of the ORDERS table,which of the following SQL statements will return an error message upon execution?

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 DISTINCT keyword can be used to indicate that duplicate data should be suppressed in the results of a query._________________________

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

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

Contents of the BOOKS table -Which of the following SQL statements will display the profit generated by each book currently stored in the BOOKS table?​

When solving arithmetic expressions,Oracle 12c always resolves addition and subtraction operations first from left to right in the expression._________________________

A string literal must be enclosed in ____________________ marks.​

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

The SELECT clause identifies the table containing the data to be queried._________________________

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

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

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

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

​Choosing specific columns to be displayed by a SELECT statement is known as selection.

Contents of the BOOKS table -Based upon the contents of the BOOKS table,which of the following SQL statements will display five rows in its results?​

Contents of the BOOKS table -​Based upon the contents of the BOOKS table,which of the following SQL statements will display the retail price for two copies of each book currently in inventory?

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?

A(n)____________________ can consist of numbers,characters,or special symbols that should be included in the output exactly as entered by the user.​

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

Each section of a SQL command that begins with a keyword is known as a statement.​

Structure of the ORDERS table -Based upon the structure of the ORDERS table,which of the following SQL statements will return an error message upon execution?​

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 DISTINCT keyword can be used to indicate that duplicate data should be suppressed in the results of a query._________________________

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

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

Contents of the BOOKS table -Which of the following SQL statements will display the profit generated by each book currently stored in the BOOKS table?

A string literal must be enclosed in ____________________ marks.

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

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

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

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

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

Choosing specific columns to be displayed by a SELECT statement is known as selection.

Contents of the BOOKS table -Based upon the contents of the BOOKS table,which of the following SQL statements will display five rows in its results?

Contents of the BOOKS table -Based upon the contents of the BOOKS table,which of the following SQL statements will display the retail price for two copies of each book currently in inventory?

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?

A(n)____________________ can consist of numbers,characters,or special symbols that should be included in the output exactly as entered by the user.

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

Each section of a SQL command that begins with a keyword is known as a statement.

Structure of the ORDERS table -Based upon the structure of the ORDERS table,which of the following SQL statements will return an error message upon execution?