Which statement is true about Oracle Net Listener?

• A.It acts as the listening endpoint for the Oracle database instance for all local and non-local user connections.
• B.A single listener can service only one database instance and multiple remote client connections.
• C.Service registration with the listener is performed by the listener registration process monitor (LREG) process of each database instance.
• D.The listener.ora configuration file must be configured with one or more listening protocol addresses to allow remote users to connect to a database instance.
• E.The listener.ora configuration file must be located in the ORACLE_HOME/network/admin directly.

Comment: *

Name: *

Email: *

Verification: *

On your Oracle 12c database, you issue the following commands to create indexes:
SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customer_id, sales_rep_id) INVISIBLE;
SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customer_id, sales_rep_id);
Which two statements are true? (Choose two.)

• A.Only the ORD_CUSTOMER_IX2index is created.
• B.The optimizer evaluates index access from both the indexes before deciding on which index to use for a query execution plan.
• C.Both the indexes are updated when a new row is inserted, updated, or deleted in the ORDERStable.
• D.Only the ORD_CUSTOMER_IX1index is created.
• E.Both the indexes are created: however, only ORD_CUSTOMER_IX2index is visible.

Comment: *

Name: *

Email: *

Verification: *

You upgrade your Oracle database in a multiprocessor environment. As a recommended you execute the following script:
SQL > @utlrp.sql
Which two actions does the script perform?

• A.Parallel compilation of only the stored PL/SQL code
• B.Sequential recompilation of only the stored PL/SQL code
• C.Parallel recompilation of any stored PL/SQL code
• D.Sequential recompilation of any stored PL/SQL code
• E.Parallel recompilation of Java code
• F.Sequential recompilation of Java code

Comment: *

Name: *

Email: *

Verification: *

Examine the contents of SQL loader control file:

Which three statements are true regarding the SQL* Loader operation performed using the control file?

• A.An EMP table is created if a table does not exist. Otherwise, if the EMP table is appended with the loaded data.
• B.The SQL* Loader data file myfile1.dat has the column names for the EMP table.
• C.The SQL* Loader operation fails because no record terminators are specified.
• D.Field names should be the first line in the both the SQL* Loader data files.
• E.The SQL* Loader operation assumes that the file must be a stream record format file with the normal carriage return string as the record terminator.

Comment: *

Name: *

Email: *

Verification: *

In which two scenarios do you use SQL* Loader to load data?

• A.Transform the data while it is being loaded into the database.
• B.Use transparent parallel processing without having to split the external data first.
• C.Load data into multiple tables during the same load statement.
• D.Generate unique sequential key values in specified columns.

Comment: *

Name: *

Email: *

Verification: *