You need to create a table with these column specifications: 

1. One column with the heading’ emp_id’, to store the ID of each employee (number data type). 

2. One column with the heading ‘emp_name’, to store the name of each employee (characters data type). 

3. One column with the heading ‘start_date’, to store the date the employee joined the organization (date data type). 

4. One column with the heading ‘emp_status’ (characters data type), which contains the default value 'active’ if no data is entered. 

5. One column with the heading ‘resume’ (characters large objects data type [CLOB]), 

which contains the curriculum the employee has handed in. 

What syntax would you use to create such table?

Analyze the structure and the data of the following CUST_TRANS table: 

In the CUST_TRANStable, dates are stored by default in the format dd-mon-yy. 

Which of the following SQL statements would execute correctly? (Select three.)

Analyze the structure of the following products table: 

You want to display the name of those products that have the highest total value for UNIT_PRICE * QTY_IN_HAND. 

Which from the following SQL statements would produce the required output?

Analyze the data in the ORD_ITEMS table that follows: Analyze the following query: 

> SELECT ITEM_NO, AVG(QTY) FROM ORD_ITEMS HAVING AVG(QTY) > MIN(QTY) * 2 GROUP BY ITEM_NO; 

In regards of the result of the above query, which of the following statements is true?

Analyze the following query: 

> SELECT PROMO_NAME || Q’{‘S START DATE WAS \}’ || PROMO_BEGIN_DATE AS “PROMOTION LAUNCHES” FROM PROMOTIONS; 

Which of the following statements is true regarding the result of the above query?

Which from the following statements are true about subqueries? (Select two.)

The CUST_CITY column contains, for CUST_FIRST_NAME 'Abigail', the value 'Paris' in the CUSTOMERS table. Analyze the following query: 

> SELECT INITCAP(CUST_FIRST_NAME || ‘ ‘ || UPPER(SUBSTR(CUST_CITY,-LENGTH(CUST_CITY),2))) FROM CUSTOMERS WHERE CUST_FIRST_NAME = ‘Abigail’; Which from the following options would be the query’s result?

Examine the data in the EMPLOYEES table in the Exhibit below: You want to display all employees’ names and their corresponding manager’s IDs. 

Examine the following query: SELECT E.EMPLOYEE_NAME “EMP NAME”, M.EMPLOYEE_NAME “MGR NAME” FROM EMPLYEES E __________________ EMPLOYEES M ON E.MANAGER_ID = M.EMPLOYEE_ID; 

¿Which join option would you use in the above query to fill in the blank with in order to obtain the required outcome?