Analyze the structure of the following orders table: In order to obtain the total value of all the orders for each year, you issued the following statement: 

>SELECT TO_CHAR (order_date, ‘rr’), SUM (order_total) FROM orders GROUP BY TO_CHAR (order_date, ‘yyyy’); 

Which of the following statements is true about the outcome?

Examine the structure and data of the CUST_TRANS table that follows: Dates in the CUST_TRANS table are stored by default in the date format dd-mm-rr. 

Which of the following SQL statements will execute successfully? (Select three.)

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

The following Exhibit shows the data in the CUST_NAME column of the customers table. 

Customers' second names need to be displayed if the second name starts with "Mc" or "MC." 

Which of the following queries will produce the required output?

Examine the following SQL statement: 

SQL >TRUNCATE TABLE DEPT; 

Which of the following options are true regarding the above SQL statement? (Select three.)

In the following Exhibit, examine the structure of the employees table: Between EMPLOYEE_ID and MANAGER_ID, there is a parent/child relationship. 

For all employees, you have to display the name, joining date, and manager. 

There is no department or manager yet assigned to newly hired employees; for them, the manager column should display the value 'No Manager1. 

Which of the following SQL queries produces the required output?

In the Exhibit below, examine the structure of the employees table. 

In order to display the minimum and maximum salaries of employees hired 1 year ago, 

which of the following statements would produce the correct output? (Select two.)

In order to alter the country column in the departments table, you issued the following command: 

> ALTER TABLE departments MODIFY (country DEFAULT ‘USA’); 

Which of the following statements is true regarding the above command?