Which three statements are true about the Oracle join and ANSI join syntax? (Choose three.)

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

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about Enterprise Manager Database Express? (Choose two.)

• A.It is available only when the database is open
• B.It can be used to perform database recovery
• C.The same port number can be used for Database Express configurations for databases on different hosts
• D.It can be used to switch a database into ARCHIVELOGMODE
• E.The same port number can be used for multiple Database Express configurations for multiple databases on the same host

Comment: *

Name: *

Email: *

Verification: *

Which three Oracle database space management features will work with both Dictionary and Locally managed tablespaces? (Choose three.)

• A.Oracle Managed Files (OMF)
• B.Automatic data file extension (AUTOEXTEND)
• C.Online table segment shrink
• D.Capacity planning growth reports based on historical data in the Automatic Workload Repository (AWR)
• E.Online index segment shrink

Comment: *

Name: *

Email: *

Verification: *

Examine the description of the EMPLOYEES table:

Which query is valid?

• A.SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id;
• B.SELECT dept_id, MAX(AVG(salary)) FROM employees GROUP BY dept_id;
• C.SELECT dept_id, AVG(MAX(salary)) FROM employees GROUP BY dept_id;
• D.SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id, join_date;

Comment: *

Name: *

Email: *

Verification: *

Which statement is true about aggregate functions?

• A.Aggregate functions can be used in any clause of a SELECT statement
• B.The MAX and MIN functions can be used on columns with character data types
• C.The AVG function implicitly converts NULLS to zero
• D.Aggregate functions can be nested to any number of levels

Comment: *

Name: *

Email: *

Verification: *