Examine the description of the CUSTOMERS table:

Which three statements will do an implicit conversion?

• A.SELECT FROM customers WHERE insert date = '01-JAN-19';
• B.SELECT. FROM customers WHERE insert_ date = DATE *2019-01-01';
• C.SELECT. FRON customers WE TO DATE (Insert _ date) = DATE '2019-01-01';
• D.SELECT * FROM customers WHERE TO_ CHAR (customer_ id) = '0001';
• E.SELECT * FROM customers WHERE customer_ id = 0001;
• F.SELECT * FROM customers WHERE customer id = '0001';

Comment: *

Name: *

Email: *

Verification: *

You issued this command:
SQL > DROP TABLE employees;
Which three statements are true? (Choose three.)

• A.The EMPLOYEES table can be recovered using the ROLLBACK command.
• B.All indexes and constraints defined on the table being dropped are also dropped.
• C.The space used by the EMPLOYEES table is always reclaimed immediately.
• D.Sequences used in the EMPLOYEES table become invalid.
• E.If there is an uncommitted transaction in the session, it is committed.
• F.The EMPLOYEES table may be moved to the recycle bin.

Comment: *

Name: *

Email: *

Verification: *

You have been asked to create a table for a banking application.
One of the columns must meet three requirements:
1: Be stored in a format supporting date arithmetic without using conversion functions
2: Store a loan period of up to 10 years
3: Be used for calculating interest for the number of days the loan remains unpaid Which data type should you use?

• A.INTERVAL DAY TO SECOND
• B.TIMESTAMP WITH LOCAL TIMEZONE
• C.TIMESTAMP
• D.TIMESTAMP WITH TIMEZONE
• E.INTERVAL YEAR TO MONTH

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

Comment: *

Name: *

Email: *

Verification: *

Examine this query which executes successfully;
Select job,deptno from emp
Union all
Select job,deptno from jobs_history;
What will be the result?

• A.It will return rows from both select statements after eliminating duplicate rows.
• B.It will return rows common to both select statements.
• C.It will return rows that are not common to both select statements.
• D.It will return rows both select statements including duplicate rows.

Comment: *

Name: *

Email: *

Verification: *