Question 1

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 * FROM orders; 
B)  SELECT order# customer# FROM orders; 
C)  SELECT order#, "order number" FROM orders; 
D)  both b and c 
A)  SELECT * FROM orders; 
B)  SELECT order# customer# FROM orders; 
C)  SELECT order#, "order number" FROM orders; 
D)  both b and c

Question 2

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)  *

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?

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

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

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?

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

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