Which two statements are true about substitution variables?

• A.A substitution variable can be used only in a select statement.
• B.A substitution variable prefixed with & always prompts only once for a value in a session.
• C.A substitution variable used to prompt for a column name must be enclosed in single quotation marks.
• D.A substitution variable can be used with any clause in a select statement.
• E.A substitution variable prefixed with to prompts only once for a value in a session unless it is set to undefined in the session
• F.A substitution variable used to prompt for a column name must be enclosed in double quotation marks.

Comment: *

Name: *

Email: *

Verification: *

The INVOICE table has a QTY_SOLD column of data type NUMBER and an INVOICE_DATE column of data type DATE.
NLS_DATE_FORMAT is set to DD-MON-RR.
Which two are true about data type conversions involving these columns in query expressions? (Choose two.)

• A.qty_sold = '0554982' uses implicit conversion
• B.CONCAT (qty_sold, invoice_date) : requires explicit conversion
• C.invoie_date > '01-02-2019' : uses implicit conversion
• D.qty_sold BETWEEN '101' AND '110' : uses implicit conversion
• E.invoice_date = '15-march-2019' : uses implicit conversion

Comment: *

Name: *

Email: *

Verification: *

In one of your databases, the user HR has the password HRMGR. You want to connect to a database instance whose listener listens on port 1531 by using this statement:
CONNECT HR/HRMGR@orcl
No name server is used.
Which statement is true about ORCL?

• A.It must be the value of the SERVICE_NAMES parameter on the client side
• B.It must resolve to a valid connect descriptor in the server's tnsnames.ora file
• C.It must resolve to a valid connect descriptor in the client's tnsnames.ora file
• D.It must be the name of the database to whose instance HR wishes to connect
• E.It must be the name of the server running the database to whose instance HR wishes to connect

Comment: *

Name: *

Email: *

Verification: *

Examine these commands:

Which two statements are true about the sqlldr execution? (Choose two.)

• A.It overwrites data in EMP with data in EMP.DAT
• B.It generates a sql script that it uses to load data from EMP.DAT to EMP
• C.It uses the database buffer cache to load data
• D.It generates a log that contains control file entries, which can be used with normal SQL*Loader operations
• E.It appends data from EMP.DAT to EMP

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about User Authentication in an Oracle Database?

• A.Operating System authentication may be used for system-privileged administrative users.
• B.Password File authentication is supported for any type of database user.
• C.REKOTE_LOGIN_PASSMOREFiLE must be set to exclusive to permit password changes for system-privileged administrative users.
• D.Password File authentication must be used for system-privileged administrative users.
• E.Password authentication must be used for system-privileged administrative users.

Comment: *

Name: *

Email: *

Verification: *