Examine this command and some partial output:

Why does the DB01.abc.comservice show unknown status?

• A.The LOCAL_LISTENER database parameter is not set to a service name that refers to LISTENER_1
• B.The service DB01.abc.com is dynamically registered
• C.The SID_LIST_LISTENER section is not contained in the LISTENER.ORA file
• D.The service DB01.abc.com is statically registered
• E.The listener is not listening on the default port 1521

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about the rules of precedence for operators? (Choose two.)

• A.The concatenation operator | | is always evaluated before addition and subtraction in an expression
• B.NULLS influence the precedence of operators in an expression
• C.The + binary operator has the highest precedence in an expression in a SQL statement
• D.Arithmetic operators with equal precedence are evaluated from left to right within an expression
• E.Multiple parentheses can be used to override the default precedence of operators in an expression

Comment: *

Name: *

Email: *

Verification: *

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

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

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about the results of using the INTERSECT operator in compound queries? (Choose two.)

• A.INTERSECT returns rows common to both sides of the compound query
• B.The number of columns in each SELECT in the compound query can be different
• C.Column names in each SELECT in the compound query can be different
• D.Reversing the order of the intersected tables can sometimes affect the output
• E.INTERSECT ignores NULLs

Comment: *

Name: *

Email: *

Verification: *

Examine the description of the CUSTOMERS table:

For customers whose income level has a value, you want to display the first name and due amount as 5% of their credit limit. Customers whose due amount is null should not be displayed.
Which query should be used?

• A.SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_incoms_level IS NOT NULLAND due_amount IS NOT NULL;
• B.SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level != NULLAND cust_credit_level !=NULL;
• C.SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level IS NOT NULLAND cust_credit_limit IS NOT NULL;
• D.SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level <> NULLAND due_amount <> NULL;
• E.SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level != NULLAND due_amount !=NULL;

Comment: *

Name: *

Email: *

Verification: *