View the Exhibits and examine the structure of the COSTS and PROMOTIONS tables.
You want to display PROD_IDS whose promotion cost is less than the highest cost PROD_ID in a promotion time interval.
Examine this SQL statement:

Exhibit 1.

Exhibit 2.

What will be the result?

• A.It executes successfully and gives the required result
• B.It gives an error because the GROUP BY clause is not valid
• C.It gives an error because the ALL keyword is not valid
• D.It executes successfully but does not give the required result

Comment: *

Name: *

Email: *

Verification: *

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

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

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: *

In one of your databases, user KING is:
1. Not a DBA user
2. An operating system (OS) user
Examine this command and its output:

What must you do so that KING is authenticated by the OS when connecting to the database instance?

• A.Unset REMOTE_LOGIN_PASSWORDFILE
• B.Grant DBA to KING
• C.Set OS_AUTHENT_PREFIX to OPS$
• D.Have the OS administrator add KING to the OSDBA group
• E.Alter user KING to be IDENTIFIED EXTERNALLY

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about table data storage in an Oracle Database? (Choose three.)

• A.A table row piece can be chained across several database blocks
• B.Multiple row pieces from the same row may be stored in different database blocks
• C.Data block free space is always contiguous in the middle of the block
• D.Index block free space is always contiguous in the middle of the block
• E.Multiple row pieces from the same row may be stored in the same block
• F.Data block headers contain their own Data Block Address (DBA)

Comment: *

Name: *

Email: *

Verification: *