Question 1

Which of the following symbols can be used to combine data from different columns into one column of output?​

Accepted Answer

A)  ​* 
B)  ​% 
C)  ​|| 
D)  ^​ 
A)  ​* 
B)  ​% 
C)  ​|| 
D)  ^​

Question 2

A query is accomplished by issuing a SELECT statement.​

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

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 5

Structure of the ORDERS table
  
-Which of the following is a valid SQL statement to retrieve data from the ORDERS table?​

Accepted Answer

A)  ​all of the above 
B)  ​SELECT order#,orderdate,shipdate FROM orders; 
C)  ​SELECT customer#,street,city,state,zip FROM orders; 
D)  ​SELECT DISTINCT customer#,DISTINCT order# FROM orders; 
A)  ​all of the above 
B)  ​SELECT order#,orderdate,shipdate FROM orders; 
C)  ​SELECT customer#,street,city,state,zip FROM orders; 
D)  ​SELECT DISTINCT customer#,DISTINCT order# FROM orders;

Question 6

A(n)____________________ is included in the SELECT clause to indicate that all columns in the specified table should be listed in the results.​

Accepted Answer

The answer of A(n)____________________ is included in the SELECT clause...

Question 7

The entire column heading for a column will be displayed,regardless of the assigned width of the column,if the column is defined as a(n)____ column.​

Accepted Answer

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

Question 8

A string literal must be enclosed in double quotation marks._________________________​

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A)  ​selection 
B)  ​concatenation 
C)  ​suppression 
D)  ​projection 
A)  ​selection 
B)  ​concatenation 
C)  ​suppression 
D)  ​projection

Question 10

The use of a column alias in the SELECT clause can be designated by the keyword ALIAS._________________________

Accepted Answer

A) True 
 B)False

Question 11

By default,data within a numeric column is right-aligned when it is displayed._________________________​

Accepted Answer

A) True 
 B)False

Question 12

SQL*Plus can only be accessed via an internet interface.

Accepted Answer

A) True 
 B)False

Question 13

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

​If you assign a column alias to a column,it must be enclosed in double quotation marks (" ").

Accepted Answer

A) True 
 B)False

Question 15

By default,data within a character or data column is right-aligned when it is displayed._________________________​

Accepted Answer

A) True 
 B)False

Question 16

A SELECT statement is also referred to as a ____________________.​

Accepted Answer

The answer of A SELECT statement is also referred to...

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

Structure of the ORDERS table
  
-Based upon the structure of the ORDERS table,which of the following is a valid SQL statement?​

Accepted Answer

A)  ​none of the above 
B)  ​SELECT customer # FROM orders; 
C)  ​SELECT "order#","customer#" FROM orders; 
D)  ​SELECT order#,orderdate DateOrdered FROM orders; 
A)  ​none of the above 
B)  ​SELECT customer # FROM orders; 
C)  ​SELECT "order#","customer#" FROM orders; 
D)  ​SELECT order#,orderdate DateOrdered FROM orders;

Question 19

Which of the following statements is correct?​

Accepted Answer

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

Question 20

​A string literal 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 (% %)

Which of the following symbols can be used to combine data from different columns into one column of output?

A query is accomplished by issuing a SELECT statement.

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

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

Structure of the ORDERS table -Which of the following is a valid SQL statement to retrieve data from the ORDERS table?

A(n)____________________ is included in the SELECT clause to indicate that all columns in the specified table should be listed in the results.

The entire column heading for a column will be displayed,regardless of the assigned width of the column,if the column is defined as a(n)____ column.

A string literal must be enclosed in double quotation marks._________________________

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

The use of a column alias in the SELECT clause can be designated by the keyword ALIAS._________________________

By default,data within a numeric column is right-aligned when it is displayed._________________________

SQL*Plus can only be accessed via an internet interface.

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

If you assign a column alias to a column,it must be enclosed in double quotation marks (" ").

By default,data within a character or data column is right-aligned when it is displayed._________________________

A SELECT statement is also referred to as a ____________________.

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

Structure of the ORDERS table -Based upon the structure of the ORDERS table,which of the following is a valid SQL statement?

Which of the following statements is correct?

A string literal must be enclosed in ____.

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 symbols can be used to combine data from different columns into one column of output?​

A query is accomplished by issuing a SELECT statement.​

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

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

Structure of the ORDERS table -Which of the following is a valid SQL statement to retrieve data from the ORDERS table?​

A(n)____________________ is included in the SELECT clause to indicate that all columns in the specified table should be listed in the results.​

The entire column heading for a column will be displayed,regardless of the assigned width of the column,if the column is defined as a(n)____ column.​

A string literal must be enclosed in double quotation marks._________________________​

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

The use of a column alias in the SELECT clause can be designated by the keyword ALIAS._________________________

By default,data within a numeric column is right-aligned when it is displayed._________________________​

SQL*Plus can only be accessed via an internet interface.

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

​If you assign a column alias to a column,it must be enclosed in double quotation marks (" ").

By default,data within a character or data column is right-aligned when it is displayed._________________________​

A SELECT statement is also referred to as a ____________________.​

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

Structure of the ORDERS table -Based upon the structure of the ORDERS table,which of the following is a valid SQL statement?​

Which of the following statements is correct?​

​A string literal must be enclosed in ____.

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 symbols can be used to combine data from different columns into one column of output?

A query is accomplished by issuing a SELECT statement.

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

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

Structure of the ORDERS table -Which of the following is a valid SQL statement to retrieve data from the ORDERS table?

A(n)____________________ is included in the SELECT clause to indicate that all columns in the specified table should be listed in the results.

The entire column heading for a column will be displayed,regardless of the assigned width of the column,if the column is defined as a(n)____ column.

A string literal must be enclosed in double quotation marks._________________________

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

By default,data within a numeric column is right-aligned when it is displayed._________________________

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

If you assign a column alias to a column,it must be enclosed in double quotation marks (" ").

By default,data within a character or data column is right-aligned when it is displayed._________________________

A SELECT statement is also referred to as a ____________________.

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

Structure of the ORDERS table -Based upon the structure of the ORDERS table,which of the following is a valid SQL statement?

Which of the following statements is correct?

A string literal must be enclosed in ____.