Examine the structure of the EMPLOYEES table.

You must display the maximum and minimum salaries of employees hired 1 year ago.
Which two statements would provide the correct output? (Choose two.)

• A.SELECT MIN(Salary), MAX(salary)FROM (SELECT salary FROMemployeesWHERE hire_date < SYSDATE-365);
• B.SELECT minsal, maxsalFROM (SELECT MIN(salary) minsal, MAX(salary) maxsalFROM employeesWHERE hire_date < SYSDATE-365GROUP BY MIN(salary), MAX(salary));
• C.SELECT minsal, maxsalFROM (SELECT MIN(salary) minsal, MAX(salary) maxsalFROM employeesWHERE hire_date < SYSDATE-365)GROUP BY maxsal, minsal;
• D.SELECT MIN(Salary) minsal, MAX(salary) maxsalFROM employeesWHERE hire_date < SYSDATE-365GROUP BY MIN(salary), MAX(salary);

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about the Oracle join and ANSI Join syntax?

• A.The Oracle join syntax only supports right outer joins,
• B.The Oracle join syntax performs less well than the SQL:1999 compliant ANSI Join Answer.
• C.The SQL:1999 compliant ANSI join syntax supports natural joins.
• D.The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax.
• E.The Oracle join syntax supports natural joins.
• F.The SQL:1999 compliant ANSI join syntax supports creation of a Cartesian product of two tables.
• G.The Oracle join syntax supports creation of a Cartesian product of two tables.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about global temporary tables?

• A.If the ON COMMIT clause Is transaction-specific, all rows in the table are deleted alter each COMMIT or ROLLBACK.
• B.They can be created only by a user with the DBA role,but can be accessed by all users who can create a session.
• C.Their data is always stored in the default temporary tablespace of the user who created them.
• D.If the ON COMMIT clause is session-specific,the table is dropped when the session is terminated.
• E.Backup and recovery operations are available for these tables.
• F.Indexes can be created on them.

Comment: *

Name: *

Email: *

Verification: *

You execute this query:

What is the result?

• A.It returns the date for the first Monday of the next month.
• B.It generates an error.
• C.It returns the date for the last Monday of the current month.
• D.It executes successfully but does not return any result.

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true?

• A.The MANAGER column is a foreign key referencing the EMPNO column.
• B.The DEPTNO column in the EMP table can contain the value 1.
• C.The COMMISSION column can contain negative values .
• D.The DNAME column has a unique constraint.
• E.An index is created automatically in the MANAGER column.
• F.The DEPTNO column in the EMP table can contain NULLS .
• G.The SALARY column must have a value .

Comment: *

Name: *

Email: *

Verification: *