Oracle Certification demand and Career Benefits

splitQ121. A junior administrator wants to mount an XFS file system on a Solaris 10 OS workstation. This file system is NOT supported in the Solaris OS. Which five file systems are natively supported in the Solaris 10 OS? (Choose five.) A. UDFS B. NTFS C. HSFS D. PCFS E. VFS F. UFS G. DFS H. NFS Answer: A,C,D,F,H Q122. Which Solaris tools allow a system administrator to remotely manage

splitQ31. In the high availability services' provided by Oracle Clusterware are used to protect Oracle resource such as RAC database instances, RAC database services, and other components of the Oracle Infrastructure, and non-Oracle resources as well. Which two statements are true about the high availability capabilities of Oracle HA services? A. RAC databases may have their instances faile

splitQ51. A medium-sized multinational company based in US has two business groups (B6), BGI (for US) and B62 (for Europe), with position approval hierarchies HI and H2, respectively. The company has a policy that only the Controllers and those above them can approve capital Items on requisitions and purchase orders. However, the Purchase Manager (who reports to the Controller) must also be able

splitQ101. Examine this PeopleCode snippet: Local Rowset &RSCUST, &RSSTUD;&RSCUST = GetRowset(RECORD.CUST_TBL);&RSSTUD = CreateRowset(RECORD.STUDENT_TBL);&RSCUST.CopyTo(&RSSTUD, RECORD.CUST_TBL, RECORD.STUDENT_TBL); Select the two correct statements. (Choose two.)A. &RSCUST is a stand-alone rowset object that references the rows in PS_CUST_TBL.B. &RSSTUD is a stand

splitQ191. For which of the following can you use Segment Shrink? (Choose all that apply.)A. Heap tablesB. Tables with function-based indexesC. IndexesD. Partitions and subpartitionsE. None of the aboveAnswer: ACDQ192. To clean up old records that are in a Flashback Data Archive and are past the retention period, what must the DBA do?A. TRUNCATE the archive table.B. DROP the Flashback Data Archi

splitQ41. ABC Company in the United Kingdom has three subsidiaries in three different countries. It consolidates the accounts of all subsidiaries and the headquarters by using the average balances. John is new to Oracle General Ledger. He has just joined ABC Company. He needs to consolidate for the current month. On completion of the consolidation, John was not able to tally the consolidated figu

splitQ11. For which two requirements would you use the Database Resource Manager? A. limiting the CPU used per database call B. specifying the maximum number of concurrent sessions allowed for a user C. specifying the amount of private space a session can allocate in the shared pool of the SGA D. limiting the degree of parallelism of operations performed by a user or group of users E. specif

splitQ41. In your Database, the TBS PERCENT USED parameter is set to 60 and the TBS PERCENT FREE parameter is set to 20. Which two storage-tiering actions might be automated when using information Lifecycle Management (ILM) to automate data movement? A. The movement of all segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespac

splitQ1. Examine these two statements:Which three are true about the MRKT tablespace?A. The MRKT tablespace is created as a small file tablespace, because the file size is less than the minimum required for big file files.B. The MRKT tablespace may be dropped if it has no contents.C. Users who were using the old default tablespace will have their default tablespaces changed to the MRKT tablespace

splitQ11. Given/var/svc/log/network-ssh:default.log: [ Jan 26 16:54:28 Leaving maintenance because clear requested. ] [ Jan 26 16:54:28 Enabled. ] [ Jan 26 16:54:28 executing start method ("/lib/svc/method/sshd start") ] Could not load host key: /etc/ssh/ssh_host_rsa_key Could not load host key: /etc/ssh/ssh_host_dsa_key Disabling protocol version 2. Could not load hostkey or GSS-API mechan

splitQ11. Which statement describes the function of the Segment Advisor?A. It advises on the usage frequency of the database objectsB. It advises on the currently validity status of the databaseC. Itidentifies database objects that have unused space that can be reclaimedD. It identifies the space requirements for the database objects based on their usage and growth statistics.Answer: CQ12. Which

splitQ41. Select these items attribute groups. (Choose three)A. General planningB. Order managementC. Periodic manufacturingD. Process manufacturingE. Discrete manufacturingF. Repetitive manufacturingAnswer: ABDQ42. The implementation team of a small distribution company wants to setup the order entry process quickly.Which three required steps are needed to enter a customer order? (Choose three)

splitQ41. XYZ is a metal fabrication company. It wants to classify all metals and plastics into two major groups. There are many subgroups in metals and plastics. All the subgroups are linked to their major group. This group classification is extensively used in all the reports in the organization. Which Oracle functionality can meet the above requirement? A. Catalogs B. Categories C. Catalog

splitQ1. Which of the following is a valid way of putting a tablespace named DAVE_TBS into hot backup mode?A. alter tablespace DAVE_TBS backup mode;B. alter tablespace DAVE_TBS start backup;C. alter tablespace DAVE_TBS begin backup;D. alter tablespace DAVE_TBS backup begin;E. alter tablespace DAVE_TBS backup;Answer: CQ2. Which three statements about performance analysis by SQL Performance Analyz

splitQ81. A user in a session executed the following SQL statement to set the optimizer mode:ALTER SESSION SET OPTIMIZER_MODE = ALL_ROWSWhat impact would it have on the goal of the optimizer for that session? (Choose all that apply.)A. Statement level OPTIMIZER_MODE hints take precedence over the session-level setting.B. The OPTIMIZER_MODE parameter set at instance level takes precedence over the

splitQ31. Which types of invoices can be automatically generated (without any manual intervention), if the appropriate setup steps have been performed? (Choose three.)A. Interest InvoicesB. Recurring InvoicesC. Purchase order (PO) matched invoicesD. Pay on receipt invoicesE. Withholding tax invoicesAnswer: ADEQ32. In the course of implementing Oracle General Ledger, you and your customer have cr

splitQ101. - (Topic 2) Which statement about java.util is incorrect? A. It contains the collections framework. B. It contains classes necessary to implement networking applications. C. It contains HashSet and Vector. D. It contains classes used to manipulate dates. Answer: B Q102. - (Topic 2) You are asked to create a Dog class that exposes the Dog class String name and int breed to othe

splitQ21. Your are the DBA supporting an Oracle 11g Release 2 database and wish to move a table containing several DATE, CHAR, VARCHAR2, and NUMBER data types, and the table’s indexes, to another tablespace. The table does not have a primary key and is used by an OLTP application. Which technique will move the table and indexes while maintaining the highest level of availability to the applic

splitQ51. Which of the following statements are true about the XACML standard and architecture? A. The Policy Enforcement Point (PEP) is where permit / deny access decisions are made. B. The Policy Information Point (PIP) provides information such as user attributes or environmental data that may be used to make access control decisions. C. XACML defines an XML schema used to represent rules f

splitQ31.  <exception-type>java.lang.ClassCastException</exception-type> Q32. Your web application requires the ability to load and remove web files dynamically to the web container’s file system? Which two HTTP methods are used to perform these actions? (Choose two) A. PUT B. POST C. SEND D. DELETE E. REMOVE F. DESTROY Answer: ADQ33.  // insert code here Q34. Which an