Which two partitioned table maintenance operations support asynchronous Global Index Maintenance in Oracle database 12c? (Choose two.)

• A.ALTER TABLE MERGE PARTITION
• B.ALTER TABLE DROP PARTITION
• C.ALTER TABLE ADD PARTITION
• D.ALTER TABLE MOVE PARTITION
• E.ALTER TABLE SPLIT PARTITION
• F.ALTER TABLE TRUNCATE PARTITION

Comment: *

Name: *

Email: *

Verification: *

Examine these SQL statements that are executed in the given order:

What will be the status of the foreign key EMP_MGR_FK?

• A.It will be enabled and deferred.
• B.It will be enabled and immediate.
• C.It will remain disabled and can be re-enabled manually.
• D.It will remain disabled and can be enabled only by dropping the foreign key constraint and re-creating it.

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about views in an Oracle database?

• A.The WITH CHECK clause prevents certain rows from being updated or inserted.
• B.Date Manipulation Language (DML) can always be used on views.
• C.Views can be updated without the need to re-grant privileges on the view.
• D.Deleting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error.
• E.Tables in the defining query of a view must always exist in order to create the view.
• F.The WITH CHECK clause prevents certain rows from being displayed when querying the view.
• G.Inserting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error.

Comment: *

Name: *

Email: *

Verification: *

In the EMPLOYEES table there are 1000 rows and employees are working in the company for more than 10 years.
Evaluate the following SQL statement:

What would be the result?

• A.It executes successfully but no rows updated.
• B.It gives an error because multiple NVL functions are used in an expression.
• C.It gives an error because NVL function cannot be used with UPDATE.
• D.It executes successfully and updates the records of those employees who have been working in the company for more than 600 days.

Comment: *

Name: *

Email: *

Verification: *

Examine the description of the EMPLOYEES table:

Which query requires explicit data type conversion?

• A.SELECT SUBSTR(join_date, 1, 2) - 10 FROM employees;
• B.SELECT join_date + '20' FROM employees;
• C.SELECT join_date FROM employees WHERE join_date > '10-02-2018';
• D.SELECT join_date || ' ' || salary FROM employees;
• E.SELECT salary + '120.50' FROM employees;

Comment: *

Name: *

Email: *

Verification: *