Which three statements are true about a self join? (Choose three.)

• A.It must be an inner join
• B.It can be an outer join
• C.The ON clause can be used
• D.The query must use two different aliases for the table
• E.It must be an equijoin
• F.The ON clause must be used

Comment: *

Name: *

Email: *

Verification: *

Which two tasks can you perform using DBCA for databases? (Choose two.)

• A.Configure a nonstandard block size for a new database
• B.Register a new database with an available Enterprise Manager Management server
• C.Change the standard block size of an existing database
• D.Configure incremental backups for a new database
• E.Enable flashback database for an existing database

Comment: *

Name: *

Email: *

Verification: *

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

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

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about the SET VERIFY ON command? (Choose two.)

• A.It can be used in SQL Developer and SQL*Plus
• B.It displays values for variables created by the DEFINE command
• C.It displays values for variables used only in the WHERE clause of a query
• D.It displays values for variables prefixed with &&
• E.It can be used only in SQL*Plus

Comment: *

Name: *

Email: *

Verification: *

Examine the description of the CUSTOMERS table:

You want to display details of all customers who reside in cities starting with the letter D followed by at least two characters.
Which query can be used?

• A.SELECT * FROM customers WHERE city LIKE 'D_';
• B.SELECT * FROM customers WHERE city LIKE 'D_%';
• C.SELECT * FROM customers WHERE city = '%D_';
• D.SELECT * FROM customers WHERE city = 'D_%';

Comment: *

Name: *

Email: *

Verification: *