Question 1

​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 2

Which of the following types of columns will automatically right-align the data when it is displayed?​

Accepted Answer

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

Question 3

Which of the following keywords can be used to indicate that a column alias should be included in the results?​

Accepted Answer

A)  ​ALIAS 
B)  ​AS 
C)  ​SELECT 
D)  ​FROM 
A)  ​ALIAS 
B)  ​AS 
C)  ​SELECT 
D)  ​FROM

Question 4

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

Accepted Answer

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

Question 5

The asterisk symbol (*)can be used in a SELECT statement to indicate that all rows in the table should be displayed in the results.​

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

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

Question 7

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)  ​none of the above 
D)  ​SELECT order#,|| ' was shipped on ' || shipdate; 
A)  ​SELECT order# || ' was shipped on ' || shipdate; 
B)  ​SELECT order# || " was shipped on " || shipdate; 
C)  ​none of the above 
D)  ​SELECT order#,|| ' was shipped on ' || shipdate;

Question 8

The ____ for a SQL statement gives the basic structure,or rules,required to execute the statement.​

Accepted Answer

A)  ​keywords 
B)  ​sequence 
C)  ​syntax 
D)  ​clauses 
A)  ​keywords 
B)  ​sequence 
C)  ​syntax 
D)  ​clauses

Question 9

Combining the contents of two or more columns is known as ____________________.​

Accepted Answer

The answer of Combining the contents of two or more...

Question 10

____________________ statements can be used to retrieve data from database tables.​

Accepted Answer

The answer of ____________________ statements can be used to retrieve...

Question 11

A(n)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 12

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 13

A column alias must be contained within double quotation marks (" ")if it contains which of the following?​

Accepted Answer

A)  ​blank spaces 
B)  ​special symbols 
C)  ​characters that should be displayed in lower or mixed case 
D)  ​all of the above 
A)  ​blank spaces 
B)  ​special symbols 
C)  ​characters that should be displayed in lower or mixed case 
D)  ​all of the above

Question 14

Contents of the BOOKS table
  
-Which of the following will display the ISBN column of the BOOKS table as the first column in its results?​

Accepted Answer

A)  ​both a and c above 
B)  ​SELECT ISBN,title FROM books; 
C)  ​SELECT * FROM books; 
D)  ​SELECT DISTINCT category,ISBN FROM books; 
A)  ​both a and c above 
B)  ​SELECT ISBN,title FROM books; 
C)  ​SELECT * FROM books; 
D)  ​SELECT DISTINCT category,ISBN FROM books;

Question 15

A ____________________ is used to end a SQL statement.

Accepted Answer

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

Question 16

A(n)WHERE statement allows a user to retrieve data from a database table.​_________________________

Accepted Answer

A) True 
 B)False

Question 17

Structure of the ORDERS table
  
-Which of the following statements can be used to view the structure of the ORDERS table?​

Accepted Answer

A)  ​SELECT * FROM orders; 
B)  ​LIST ORDERS; 
C)  ​DESCRIBE ORDERS 
D)  ​none of the above 
A)  ​SELECT * FROM orders; 
B)  ​LIST ORDERS; 
C)  ​DESCRIBE ORDERS 
D)  ​none of the above

Question 18

The names of the columns to be retrieved are listed in the ____________________ clause.​

Accepted Answer

The answer of The names of the columns to be...

Question 19

What are the mandatory clauses of a SELECT statement and what do they represent?​

Accepted Answer

The only mandatory clauses of a SELECT s

Question 20

The ____________________ keyword can be included in a SELECT statement to suppress the display of duplicate data.​

Accepted Answer

The answer of The ____________________ keyword can be included in...

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

Which of the following types of columns will automatically right-align the data when it is displayed?

Which of the following keywords can be used to indicate that a column alias should be included in the results?

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

The asterisk symbol (*)can be used in a SELECT statement to indicate that all rows in the table should be displayed in the results.

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

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

The ____ for a SQL statement gives the basic structure,or rules,required to execute the statement.

Combining the contents of two or more columns is known as ____________________.

____________________ statements can be used to retrieve data from database tables.

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

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

A column alias must be contained within double quotation marks (" ")if it contains which of the following?

Contents of the BOOKS table -Which of the following will display the ISBN column of the BOOKS table as the first column in its results?

A ____________________ is used to end a SQL statement.

A(n)WHERE statement allows a user to retrieve data from a database table._________________________

Structure of the ORDERS table -Which of the following statements can be used to view the structure of the ORDERS table?

The names of the columns to be retrieved are listed in the ____________________ clause.

What are the mandatory clauses of a SELECT statement and what do they represent?

The ____________________ keyword can be included in a SELECT statement to suppress the display of duplicate data.

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

Which of the following types of columns will automatically right-align the data when it is displayed?​

Which of the following keywords can be used to indicate that a column alias should be included in the results?​

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

The asterisk symbol (*)can be used in a SELECT statement to indicate that all rows in the table should be displayed in the results.​

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

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

The ____ for a SQL statement gives the basic structure,or rules,required to execute the statement.​

Combining the contents of two or more columns is known as ____________________.​

____________________ statements can be used to retrieve data from database tables.​

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

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

A column alias must be contained within double quotation marks (" ")if it contains which of the following?​

Contents of the BOOKS table -Which of the following will display the ISBN column of the BOOKS table as the first column in its results?​

A ____________________ is used to end a SQL statement.

A(n)WHERE statement allows a user to retrieve data from a database table.​_________________________

Structure of the ORDERS table -Which of the following statements can be used to view the structure of the ORDERS table?​

The names of the columns to be retrieved are listed in the ____________________ clause.​

What are the mandatory clauses of a SELECT statement and what do they represent?​

The ____________________ keyword can be included in a SELECT statement to suppress the display of duplicate data.​

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

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

Which of the following types of columns will automatically right-align the data when it is displayed?

Which of the following keywords can be used to indicate that a column alias should be included in the results?

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

The asterisk symbol (*)can be used in a SELECT statement to indicate that all rows in the table should be displayed in the results.

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

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

The ____ for a SQL statement gives the basic structure,or rules,required to execute the statement.

Combining the contents of two or more columns is known as ____________________.

____________________ statements can be used to retrieve data from database tables.

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

A column alias must be contained within double quotation marks (" ")if it contains which of the following?

Contents of the BOOKS table -Which of the following will display the ISBN column of the BOOKS table as the first column in its results?

A(n)WHERE statement allows a user to retrieve data from a database table._________________________

Structure of the ORDERS table -Which of the following statements can be used to view the structure of the ORDERS table?

The names of the columns to be retrieved are listed in the ____________________ clause.

What are the mandatory clauses of a SELECT statement and what do they represent?

The ____________________ keyword can be included in a SELECT statement to suppress the display of duplicate data.