In regards of the work with dates, which of the following statements are true? (Select two.)

Evaluate the statement that follows: 

CREATE SYNONYM emp for hr.employees; 

What would be the outcome of issuing the above statement?

Which of the following statements are true regarding subqueries? (Select two.)

Examine the structures of PRODUCTS, SALES and CUSTOMERS table in the Exhibits below: 

The following query is issued: 

SQL>SELECT p.prod_id, prod_name, prod_list_price, quantity_sold, cust_last_name FROM products p NATURAL JOIN sales s NATURAL JOIN customers c WHERE prod_id = 148; 

Which of the following statements is true regarding the query’s outcome?

Analyze the following two queries: 

>SELECT cust_last_name, cust_city FROM customers WHERE cust_credit_limit IN (1000, 2000, 3000); 

>SELECT cust_last_name, cust_city FROM customers WHERE cust_credit_limit = 1000 OR cust_credit_limit = 2000 OR cust_credit_limit = 3000; 

Which of the following statements is true in regards of the above queries?

Which of the following statements are true regarding single row functions? (Select two.)

Analyze the SQL statement that follows: 

► SELECT e.emp_name, d.dept_name FROM employees e JOIN departments d USING (department_id) WHERE d.department_id NOT IN (10, 40) ORDER BY dept_name; It fails at execution. 

Which changes could fix the error? (Select two.)

Examine the structure of the SALES, CUSTOMERS, PRODUCTS and ITEMS tables in the following Exhibit: 

In the SALES table, the PROD_ID column is the foreign key referencing the PRODUCTS table, the CUST_ID column is the foreign key referencing the CUSTOMERS table, and the TIME_ID column is the foreign key which references the TIMES table. 

Examine the following CREATE TABLE command:

 ► CREATE TABLE new_sales (prod_id, cust_id, order_date DEFAULT SYSDATE) AS SELECT prod_id, cust_id, time_id FROM sales; 

Which of the following statements is true in regards of the above command?