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 = '%D_';
• B.SELECT * FROM customers WHERE city = 'D_%';
• C.SELECT * FROM customers WHERE city LIKE 'D_';
• D.SELECT * FROM customers WHERE city LIKE 'D_%';

Comment: *

Name: *

Email: *

Verification: *

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 ON clause must be used
• E.It must be an equijoin
• F.The query must use two different aliases for the table

Comment: *

Name: *

Email: *

Verification: *

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

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

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about single-row functions? (Choose three.)

• A.They can be used only in the WHERE clause of a SELECT statement
• B.The argument can be a column name, variable, literal or an expression
• C.The data type returned can be different from the data type of the argument
• D.They can be nested to any level
• E.They can accept only one argument
• F.They return a single result row per table

Comment: *

Name: *

Email: *

Verification: *

Which four account management capabilities can be configured using Oracle profiles? (Choose four.)

• A.the number of days for which an account is locked after the configured number of login attempts has been reached
• B.the maximum number of sessions permitted for a user before the account is locked
• C.the number of password changes required within a period of time before a password can be reused
• D.the ability to prevent a password from ever being reused
• E.the number of days for which an account may be inactive before it is locked
• F.the number of hours for which an account is locked after the configured number of login attempts has been reached
• G.the maximum amount of CPU time allowed for a user's sessions before their account is locked

Comment: *

Name: *

Email: *

Verification: *