You need to configure fine-grained access control to external network resources from within your database. You create an access control list (ACL) using theDBMS_NETWORK_ACL_ADMIN package.Which statement is true regarding the ACL created?
While deploying a new application module, the software vendor ships the application software along with appropriate SQL plan baselines for the new SQLs being introduced. Which two statements describe the consequences? (Choose two.)
Which statement is true regarding online redefinition for the migration of BasicFile LOBs to SecureFile LOBs?
You have applications that have frequently executed queries, and produce small and static result sets. You configure the sqlnet.ora file in the client machine to set a nonzero value for the OCI_RESULT_CACHE_MAX_SIZE parameter.What is the purpose of this configuration?
Which two statements are true with respect to the maintenance window? (Choose two.)
The INV_HISTORY table is created using the command:The following data has been inserted into the INV_HISTORY table:You would like to store the data belonging to the year 2006 in a single partition and issue the command:SQL> ALTER TABLE inv_history -MERGE PARTITIONS -FOR(TO_DATE('15-feb-2006','dd-mon-yyyy')),FOR(TO_DATE('15-apr-2006'))INTO PARTITION sys_py;What would be the outcome of this command?
