Analyze the PRODUCTS and SALES tables in the following Exhibits:

 In order to display product name the number of times the product has been sold, you executed this query: 

What will result from the execution of the above statement?

Analyze the structure of the BOOKS_TRANSACTIONS table: 

Analyze the following SQL statement: 

Which from the following statements is true in regards of the outcome?

Analyze the data in the EMPLOYEES table in the Exhibit. in order to produce a report which shows the total compensation paid to each employee to date, the following query is issued: 

What would be the result?

You want to generate a report in which each customer’s credit limit has been incremented by $1000. 

In the output, the heading Name should be used for customer’s last name and the heading New Credit Limit, for the incremented credit limit. 

Only the first letter of each word should be in uppercase in the column headings. 

Which from the following statements would satisfy the requirement?

Given that SCOTT is a database user, examine the following commands executed by the DBA: 

Which from the following statements is true about the execution of the above commands?

Analyze the structure of the PROMOTIONS table in the Exhibit below. 

Examine this SQL statement: 

Which from the following statements is true about the query’s outcome?

Analyze the following design of a TRANSACTIONS table: 

Which from the following statements are true in regards of data storage in the above table structure? (Select two.)

Analyze the structure of the following MARKS table: 

Which from the following statements would succeed at execution? (Select two.)