Oracle Certification demand and Career Benefits

splitQ151. The security administrator wants to assign user bob to a netsec role so that the user can run the ifconfig(1M) and snoop(1M) commands with a rights profile named NSM. Which entries will be contained in the /etc/security/exec_attr file after the required RBAC configuration has been implemented when using privileges rather than uid 0? A. NSM:bob:cmd:::/sbin/ifconfig:privs=sys_net_config

splitQ291. Which statement about the enabling of table compression in Oracle Database 11g is true?A. Compression can be enabled at the table, tablespace, or partition level for direct loads only.B. Compression can be enabled only at the table level for both direct loads and conventional DML.C. Compression can be enabled at the table, tablespace, or partition level for conventional DML only.D. Com

splitQ91. Identify a correct statement about profile classes. A. Credit checking is managed in Receivables and Credit Management. B. Late charge type includes adjustment, debit memo, and interest invoice. C. Profile classes can be assigned to party, customer account, and account site levels. D. Profile classes can be assigned at the site level if the site has active bill-to and ship-to addres

splitQ171. You must add additional network ports to your SPARC-based workstation. You have a Quad Fast Ethernet card. The system is currently powered off for scheduled maintenance. Which steps make the card accessible by the operating system? A. remove the system cover; install the qfe card in an available SBus slot; power on the system; log in to the system as root; verify the card is working

splitQ281. How long will this backup be allowed to run?Backup as compressed backupset duration 2:00 minimize load database ;A. 2 minutesB. 2 hoursC. 2 daysD. The command will generate an error.E. This backup is not constrained by any time limitation.Answer: BQ282. You create two resource plans, one for data warehouse loading jobs at night and the other for application jobs at day time. You want

splitQ121. Identify two features of a table-validated Value Set. (Choose two.) A. A table-validated Value Set has no list of approved values associated with it. B. Table-validated Value Sets obtain their lists of approved values from existing application tables. C. The values in a table-validated Value Set are stored in Oracle Application Object Library's tables. D. In a table-validated V

splitQ191. SystemA has a file system named /library that contains a library of files to be shared to the entire company. Each remote system has read-only access to this file system through the /library mount point. Occasionally, serverA goes down for maintenance and users can no longer access the data in the library. Therefore, you have configured a second server, named systemB, that users can a

splitQ271. Which of the following would be affected by setting NLS_LENGTH_SEMANTICS=CHAR?A. All objects in the databaseB. Tables owned by SYS and SYSTEMC. Data dictionary tablesD. NCHAR columnsE. CHAR columnsAnswer: EQ272. View the Exhibit to examine the metrics with a threshold.Which statement is true regarding the Number of Transactions (per second) metric?A. Oracle uses statistical relevance

splitQ131. Identify two statements that apply to Oracle Collections. (Choose two.) A. It is a Web-based self-service application. B. It can be used to place an invoice in dispute. C. It enables customers to see their own Oracle Receivables account information, such as balances. D. It can be used to initiate the Oracle Approvals Management (AME) credit memo request workflow from Oracle Collect

splitQ201. Which two entries are valid for the contents of the /etc/hostname.ce0 file? (Choose two.) A. corprouter1 B. 192.168.10.1 C. ce0 192.168.10.1 D. ifconfig ce0 inet 192.168.10.1 Answer: A,B Q202. What are four types of AutoFS maps? (Choose four.) A. Slave B. Direct C. Binary D. Master E. Indirect F. Sparse G. Special H. Cannonical Answer: B,D,E,G Q203. Given: Which two statem

splitQ261. Identify the channel settings that can be performed using the CONFIGURE CHANNEL or ALLOCATE CHANNEL commands in RMAN (choose all that apply)A. Limiting the input/output (I/O) bandwidth consumptionB. Specifying the size of backup sets and backup piecesC. Specifying vendor-specific information for a media managerD. Specifying the parallelism for backup and restore operationsAnswer: ACQ26

splitQ141. Your client wants the ability to report with Financial Statements Generator (FSG) and perform account inquiry at the summary (business unit) level of its Cost Center segment. A business unit is a group of cost centers and a business unit manager typically has several cost centers under his or her responsibility. Which option will meet the client's requirements? A. Define parent co

splitQ211. You are installing Solaris 10 OS on a SPARC-based system with a graphical monitor and keyboard, but the installation starts up in CLI mode. Assuming you have typed the correct installation command, what is the cause? A. You used the DVD. B. The monitor is monochrome. C. Solaris OS is a text-only installation. D. The system has less than 384 megabytes of RAM. E. The system has less

splitQ191. After creating two new customers, LeftBank and RightSide, you create and complete an invoice for $105 ($100 plus $5 tax) for LeftBank. You immediately realize that you should have created the invoice for RightSide. Which three steps can you take to correct the situation? (Choose three.) A. Change the status of the invoice to incomplete. Delete the invoice, and then enter and complete

splitQ1. Given:11. public static void test(String str) {12. int check = 4;13. if (check = str.length()) {14. System.out.print(str.charAt(check -= 1) +", ");15. } else {16. System.out.print(str.charAt(0) + ", ");17. }18. } and the invocation:21. test("four");22. test("tee");23. test("to");What is the result?A. r, t, t,B. r, e, o,C. Compilation fails.D. An exception is thrown at runtime.Answer: CQ2

splitQ251. You are using a client system in your organization's NIS domain and you need to find the list of servers, which is held in the NIS map ypservers. You run the command: ypcat ypservers The command returns several blank lines. Which ypcat command displays the list of NIS servers? A. ypcat -v ypservers B. ypcat -V ypservers C. ypcat -l ypservers D. ypcat -k ypservers Answer: D

splitQ251. Examine the following scenario:The target database instance is running. The most recent backup available for the target database was taken two days ago. Log files switches have occurred in last two days. The target database is duplicated on the same host, using the Recovery Manager (RMAN) duplicate command as follows:RMAN> RUN{ALLOCATE AUXILIARY CHANNEL aux 1 DEVICE TYPE DISK;DUPLIC

splitQ101. - (Topic 1) See the Exhibit and examine the structure of the PROMOTIONS table: Exhibit: Using the PROMOTIONS table, you need to find out the average cost for all promos in the range $0-2000 and $2000-5000 in category A. You issue the following SQL statements: Exhibit: What would be the outcome? A. It generates an error because multiple conditions cannot be specified for the WHEN

splitQ211. Identify four functions of the Invoice Validation process. (Choose four.) A. applying any required holds B. releasing any qualifying holds C. applying all prepayments and discounts D. validating the General Ledger accounting information E. validating and creating accounting entries for the invoice F. ensuring that the total amount of all distributions equals the invoice total G.

splitQ11. Given:1. public class Boxer1{2. Integer i;3. int x;4. public Boxer1(int y) {5. x = i+y;6. System.out.println(x);7. }8. public static void main(String[] args) {9. new Boxer1(new Integer(4));10. }11. }What is the result?A. The value "4" is printed at the command line.B. Compilation fails because of an error in line 5.C. Compilation fails because of an error in line 9.D. A NullPointerExcep