Which two are true about conventional path SQL load? (Choose two.)

• A.It does not generate UNDO.
• B.It cannot load data into clustered tables.
• C.It always generates redo.
• D.It enforces referential integrity constraints.
• E.It locks objects being processed.

Comment: *

Name: *

Email: *

Verification: *

Examine these commands:

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

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

Comment: *

Name: *

Email: *

Verification: *

In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1.
The TNSNAMES.ORA file in $ORACLE_HOME/network/admin in the database home contains:

Which statement is true?

• A.Dynamic service registration cannot be used for this database instance
• B.The LREG process registers services dynamically with the LISTENER_1 listener
• C.LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration
• D.There are two listeners named LISTENER and LISTENER_1 running simultaneously using port 1521 on the same host as the database instances
• E.The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registration

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

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

Comment: *

Name: *

Email: *

Verification: *