Evaluate the description for the SALES table in the Exhibit below. 

Analyze the following views and choose all those that could perform on it all DML operations.

The following three functions can be performed by a SELECT statement: 

1. Choosing rows from a table. 

2. Choosing columns from a table. 

3. Bringing together data which is stored in different tables by creating a link between them. 

Which of the following keywords sets is accurate to describe these capabilities?

Evaluate the structure of the ORD table in the Exhibit below: 

Analyze the following SQL statements that are executed in the specified order in a user session: 

CREATE SEQUENCE ord_seq; 

SELECT ord_seq.nextval - FROM dual; 

INSERT INTO ord_seq VALUES (ord_seq.CURRVAL, 25-jan-2007, 101); UPDATE ord_seq SET ord_no= ord_seq.NEXTVAL - WHERE cust_id =101; 

What would be the result of executing the above statements?

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

Analyze the following SQL statement: > SELECT promo_category, AVG (promo_cost) Avg_Cost, AVG (promo_cost) * 25 Avg_Overhead FROM promotions WHERE UPPER (promo_category) IN (‘TV’, ‘INTERNET’, ‘POST’) GROUP BY Avg_Cost ORDER BY Avg_Overhead; 

At executing the above query, it generates an error. Which of the clauses used in the above SQL statement has caused the error?

In the SPARES table, the PART_CODE column contains the following list of values: 

PART_CODE ------------------ A%_WQ123 A%BWQ123 AB_WQ123 Examine the following query:

 > SELECT part_code FROM spares WHERE part_code LIKE ‘%\%_WQ12%’ ESCAPE ‘\’; 

Which of the following statements is true about the outcome of the above query?

Examine the structure of the PROMOTIONS table in the following Exhibit. 

Which of the following SQL statements would be valid? (Select all that apply.)

Based on the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables, a user has created a view called EMP_DEPT_LOC_VU. 

The user has the privilege to create a public synonym, which will be used to create a synonym for this view that is accessible to all users of the database. 

Which of the following SQL statements could accomplish the task?

Examine the structure of ORDERS and CUSTOMERS tables in the Exhibit below. 

Only one customer in the table has the value Roberts in the cus_last_name column. In order to add a row into the ORDERS table for the customer whose last name is Roberts and has a credit limit of 600, which of the following INSERT statements should be used?