Which statement is true about the shared server configuration?

Your database uses Automatic Memory Management, and has the large pool configured.You issue the following command:SQL> ALTER SYSTEM SET SHARED_SERVERS = 5;Which statement is true about the shared server configuration?Reference: https://docs.oracle.com/cd/E71588_01/HTMIG/configuring-SHARED-SERVERS-parameter.htm#HTMIG29492 Question: Which statement is true about the shared server configuration? Options: It is enabled only if the SHARED_SERVER_SESSIONS parameter is configured. It is enabled … Read more

What would you define to implement this?

You must configure Oracle Data Redaction for the EMP table to satisfy the following requirements:RANDOM redaction on the SAL and COMM columnsPARTIAL redaction on the HIREDATE column FULL redaction on the MGR columnWhat would you define to implement this?You can redact columns of different data types, using different redaction types, for one table or view.1. … Read more

Which statement is correct?

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); SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders(customer_id, sales_rep_id);Which statement is correct? Question: Which statement is correct? Options: Only the ORD_CUSTOMER_IX1 index is created and it is visible. Both the indexes are created and both of … Read more

Which two statements are true when the listener handles connection requests to an Oracle 12c database instance with multithreaded architecture enabled in UNIX?

Which two statements are true when the listener handles connection requests to an Oracle 12c database instance with multithreaded architecture enabled in UNIX? Question: Which two statements are true when the listener handles connection requests to an Oracle 12c database instance with multithreaded architecture enabled in UNIX? Options: The local listener may pass the request … Read more

Identify the prerequisite for configuring and accessing Enterprise Manager (EM) express for an Oracle 12c database.

Identify the prerequisite for configuring and accessing Enterprise Manager (EM) express for an Oracle 12c database.Execute the DBMS_XDB_CONFIG.SETHTTPSPORT procedure.Reference: https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/access-em-database-express-12c.html Question: Identify the prerequisite for configuring and accessing Enterprise Manager (EM) express for an Oracle 12c database. Options: Create a SYSMAN user with the SYSDBA role as an administrator for EM express. Configure the DISPATCHERS … Read more

What is the significance of the dml_lock_timeout period of 600 seconds in the preceding command?

To complete the online redefinition procedure, you execute the following command;EXECUTE DBMS_REDEFINITION.FINISH_REDEF_TABLE(‘SH’, ‘SALES’, ‘INT_SALES’, 600);What is the significance of the dml_lock_timeout period of 600 seconds in the preceding command?Wait up to 600 seconds for required locks on SH.SALES:EXECUTE DBMS_REDEFINITION.FINISH_REDEF_TABLE (‘SH’, ‘SALES’, ‘INT_SALES’, 600);Reference: http://oradb-srv.wlv.ac.uk/E50529_01/ARPLS/d_redefi.htm#ARPLS042 Question: What is the significance of the dml_lock_timeout period of 600 … Read more

Which three statements are true about adaptive SQL plan management?

Which three statements are true about adaptive SQL plan management? Question: Which three statements are true about adaptive SQL plan management? Options: It adds new; bettor plans automatically as fixed plans to the baseline. The non-accepted plans are automatically accepted and become usable by the optimizer if they perform better than the existing accepted plans. … Read more

Which two statements are true regarding SQL*Loader Express Mode in an Oracle 12c database?

Which two statements are true regarding SQL*Loader Express Mode in an Oracle 12c database? (Choose two.)Reference: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/sutil/oracle-sql-loader-express-mode.html#GUID-0F35B551-861B-450D-8BF3-2312893A67D7 Question: Which two statements are true regarding SQL*Loader Express Mode in an Oracle 12c database? Options: You cannot have multiple SQL*Loader data files. The DEGREE_OF_PARALLELISM parameter is set to AUTO. If no data file is specified, it uses … Read more

Which is true about the result of this command?

You are connected to a pluggable database (PDB) as a common user with DBA privileges.The STATISTICS_LEVEL parameter is PDB_MODIFIABLE. You execute the following: SQL > ALTER SYSTEM SET STATISTICS_LEVEL = ALL SID = ‘*’SCOPE = SPFILE;Which is true about the result of this command?http://docs.oracle.com/database/121/ADMIN/cdb_pdb_admin.htm#ADMIN14017 Question: Which is true about the result of this command? Options: … Read more

Which statement is true?

Your multitenant container database (CDB) contains several pluggable databases (PDBs).A common user C##A_ADMIN, is created with connect privileges.You execute this command from the root container:SQL> GRANT create tablespace to C##A_ADMIN;Which statement is true? Question: Which statement is true? Options: The command executes successfully, enabling the C##A_ADMIN user to create a tablespace only in the root … Read more