Examine the structure of the MEMBERS table: NameNull?Type ------------------ --------------- ------------------------------ MEMBER_IDNOT NULLVARCHAR2 (6) FIRST_NAMEVARCHAR2 (50) LAST_NAMENOT NULLVARCHAR2 (50) ADDRESSVARCHAR2 (50) You execute the SQL statement: SQL > SELECT member_id, ' ' , first_name, ' ' , last_name "ID FIRSTNAME LASTNAME " FROM members; What is the outcome?

Examine the structure of the PROGRAMS table: Which two SQL statements would execute successfully?

Which two statements are true regarding the COUNT function?

View the Exhibit and examine the structure of the EMPLOYEES and JOB_HISTORY tables. (Choose all that apply.) Examine this query which must select the employee IDs of all the employees who have held the job SA_MAN at any time during their employment. SELECT EMPLOYEE_ID FROM EMPLOYEES WHERE JOB_ID = 'SA_MAN' ------------------------------------- SELECT EMPLOYEE_ID FROM JOB_HISTORY WHERE JOB_ID = 'SA_MAN'; Choose two correct SET operators which would cause the query to return the desired result.

Evaluate this ALTER TABLE statement: (Choose the best answer.) ALTER TABLE orders SET UNUSED (order_date); Which statement is true?

Which three statements are true regarding subqueries?

View the Exhibit and examine the structure of the CUSTOMERS and CUST_HISTORY tables. The CUSTOMERS table contains the current location of all currently active customers. The CUST_HISTORY table stores historical details relating to any changes in the location of all current as well as previous customers who are no longer active with the company. You need to find those customers who have never changed their address. Which SET operator would you use to get the required output?

View the Exhibit and examine the structure of the ORDERS table. Which UPDATE statement is valid?

Which two statements are true about sequences created in a single instance database? (Choose two.)

You want to display the date for the first Monday of the next month and issue the following command: SQL>SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE), 'MON'), 'dd "is the first Monday for" fmmonth rrrr') FROM DUAL; What is the outcome?

View the exhibit and examine the description of the DEPARTMENTS and EMPLOYEES tables. The retrieve data for all the employees for their EMPLOYEE_ID, FIRST_NAME, and DEPARTMENT NAME, the following SQL statement was written: SELECT employee_id, first_name, department_name FROM employees NATURAL JOIN departments; The desired output is not obtained after executing the above SQL statement. What could be the reason for this?