Oracle Certification demand and Career Benefits

splitQ51. Choose three correct statements about ASM disk group attributes set from the ASMCA Create Disk Group A. The field labeled ASM Compatibility sets the compatible.asm attribute. B. When creating a disk group with ASMCA, the default setting for the ASM Compatibility field (compatible.asm) is 10.1. C. The Database Compatibility field (compatible.rdbms) sets the minimum version level for a

splitQ21. The database instance was recently started up. Examine the following parameter settings for the database instance: NAME TYPE VALUE result_cache_max_result integer 5 result_cache_max_size big integer 0 result_cache_mode string MANUAL result_cache_remote_expiration integer 0 You reset the value for the result_cache_max_size parameter by issuing the following command: SQL> ALTER S

splitQ21. There was an error while applying a patch. The AutoPatch error message indicates that the FND_INSTALL_PROCESSES table already exists. AutoPatch asks if you want to drop the table. Which two steps need to be performed before dropping the table? (Choose two.) A. Shut down the concurrent managers process. B. The users need to log out of Oracle Applications. C. Determine if there are err

splitQ41. Which three statements are true about ASM Cloud File System (ACFS) encryption? A. A copy of an encrypted file is not encrypted unless it is created in an encrypted directory. B. acfsutil encr init is used to establish role separation between encryption managers and encryption auditors. C. acfsutil encr off can be run by an encryption manager who may not have system administrator priv

splitQ21. Identify the statement that reflects the functionality of the Create Accounting Process.A. The Create Accounting Process creates subledger accounting entries.B. You can use the Create Accounting Process to create subledger accounting entries and validate the invoices.C. The Create Accounting Process is used to create subledger accounting entries and transfer the transactions to General

splitQ21. You are about to configure an AI server and you need to determine if NWAM is configured, if the system has a manually configured IP interface. Which command gives you this information? A. nscfg list B. netadm list C. netcfg list D. svcs network/physical Answer: C Q22. Which option describes how to revert a service back to a previous version? A. Issue the svccfg delcust command.�

splitQ11. Which are the two interface tables that transaction data will be imported to when using the Autoinvoice Feature?A. AR_INTERFACE_CONTS_ALLB. AR_INTERFACE_CONT_ALLC. RA_INTERFACE_SALES_ALLD. RA_INTERFACE_DISTRIBUTIONS_ALLE. RA_INTERFACE_DIST_ALLAnswer: C,DExplanation:Note: AutoInvoice Gather Statistics Allowed: If you set this profile option to Yes, then when you submit AutoInvoice, the p

splitQ21. You are a member of two Custom Security Groups. One groupallows you to delete contacts,whereas theother does not. What happens when you try to delete a contact? A. You are prompted with an error message stating that you do not have access to delete contacts. B. You are asked to contact an administrator to delete the contact. C. You are able to delete the contact and remain a member

splitQ1. A telecom company wishes to generate monthly bills to include details of customer calls, listed in order of time of call. Which table organization allows for generating the bills with minimum degree of row sorting? A. a hash cluster B. an index cluster C. a partitioned table D. a sorted hash cluster E. a heap table with a rowid column Answer: B Q2. Your database is running in ar

splitQ91. Click the Exhibit button. Which three statements are true? (Choose three.) A. /dev/fssnap/0 has the backing store file on the server 129.147.12.105. B. ufsdump 1ufN /dev/rmt/0 /dev/dsk/c0t2d0s0 /dev/rfssnap/0 will run the incremental backup of /dev/dsk/c0t2d0s0 to /dev/rmt/0. C. fssnap -d /etc will delete snapshot /dev/rfssnap/0. D. fssnap -d /etc will automatically delete the back

splitQ1. You administer a growing network of systems, each using an /etc/inet/hosts file to identify IP addresses of other systems. You find that it is difficult to keep each system's /etc/inet/hosts file up to date. What are three solutions to this problem? (Choose three.) A. configure your network to use NIS B. configure your network to use FTP C. configure your network to use NFS D. confi

splitQ31. ACME is working on setting up security for *PUBLIC, individual users, and roles. When JOE user has two roles assigned to him: Role1=APUSER sequence 10 and Role2=APADMIN sequence 15) and signs in with the *ALL role, what is the hierarchy that security records read when a user attempts to access an application or perform an action?A. User -> *PUBLIC -> Role1 -> Role2B. User ->

splitQ31. Where can you find the generated report file after running the Validate APPS schema task in the Oracle Applications R12 E-Business Suite setup? A. <APPL_TOP>/admin/<APPS schema name>.lst B. <RDBMS ORACLE_HOME>/admin/out/<SID>.lst C. <AD_TOP>/admin/out/<APPS schema name>.lst D. <APPL_TOP>/admin/<context_name>/out/<SID>.lst E. <

splitQ101. When you're performing active database duplication, a backup of what kind is required?A. A current RMAN backup-set backup is required.B. No backup is required.C. An RMAN image backup is required.D. A manual backup is required.E. A "duplicate" preparatory backup is required.Answer: BQ102. Another DBA issues a shutdown abort command on a database on which you were running an online

splitQ61. Your system has been upgraded from Oracle Database 10g to Oracle Database 11g. You imported SQL Tuning Sets (STS) from the previous version. After changing the OPTIMIZER_FEATURE_ENABLE parameter to 10.2.0.4 and running the SQL PerformanceAnalyzer, you observed performance regression for a few SQL statements. What would you do with these SQL statements?A. Set OPTIMIZER_USE_PLAN_BASELINE

splitQ1. Which three statements are true concerning activation of a user-defined policy in Oracle 12c Clusterware? A. When a policy is first created, it is initially active. B. When a policy is activated, nodes may be reassigned to server pools based on the policy definition. C. An administrator-defined policy may be activated using the srvctl utility. D. When a policy is activated, resource

splitQ21. In the CLI for the gateway switch, the command [option][option] . . . format of commands is used for . A. General hardware administration B. InfiniBand fabric control and management C. ILOM access D. Launching the web interface Answer: B Explanation: 6. If you cannot connect to ILOM over the network, which connection method would you use? A. USB B. Serial connection C. Web D.

splitQ91. - (Topic 2) A local repository is available on this system and you need to enable clients to access this repository via HTTP. The repository information is: PUBLISHERTYPESTATUSURI solarisoriginonlinehttp://sysA.example.com Identify two of the steps that are required to make the local repository on this server available to the client via HTTP. A. On the server: set the pkg/inst_root

splitQ1. Given the code fragment: List<String> empDetails = Arrays.asList(“100, Robin, HR”, “200, Mary, AdminServices”, “101, Peter, HR”); empDetails.stream() .filter(s-> s.contains(“1”)) .sorted() .forEach(System.out::println); //line n1 What is the result? A. 100, Robin, HR 101, Peter, HR B. E. A compilation error occurs at line n1. C. 100, Robin, HR 101, Pet

splitQ11. You have setup the following ZFS file systems: NAME USED AVAIL REFER MOUNTPOINT datapool 197K 72.8G 29.5K /datapool datapool/data 24.5K 72.8G 24.5K /datapool/data datapool/web 24.5K 72.8G 24.5K /datapool/web You want to limit the amount of disk space that the /data/pool/web file system can consume. Which command would set the limit for the /data/pool/web file system so that it would c