Oracle Certification demand and Career Benefits

splitQ31. You are administering a multitenant container database (CDB) cdb1that has multiple pluggable databases (PDBs). As the sys user on cdb$root, you execute the commands: SQL> CREATE USER C##ADMIN IDENTIFIED BY orc1123; SQL> GRANT CREATE SESSION to C##ADMIN CONTAINER=ALL; SQL> GRANT CREATE USER TO C##ADMIN CONTAINER=ALL; Which two statements are true about the c##admin user that

splitQ131. While installing the OS, you select DNS as a name service. As you continue the installation, what information is required to complete the DNS client installation? (Choose two) A. The domain name must be set for this client. B. The node name for the primary DNS server must be set on this client. C. the IP address of the primary DNS server must be set on this client. D. The user name

splitQ151. You have setup the following ZFS file systems: 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 consume no more than 2GB of disk space? A. zfs set quota=2G datapool/web B. set zfs quota 2G datapool/web C. quota datapool/web 2G D. zfs set quota -2G datapo

splitQ41. You plan to use Enterprise Manager to locate and stage patches to your Oracle Home. The software library has been configured to be downloaded to /u01/app/oracle and your "My Oracle Support" credentials have been entered. You want to start the provisioning daemon in order to use the deployment procedure manager to view, edit, monitor, and run deployment procedures. How would you start

splitQ11. During a proactive database performance monitoring routine, on examining the AWR report you find that log file sync appears among the top 5 wait events.What does this event indicate?A. Frequent logfile switches are occurring.B. Redo is generated faster than LGWR can write it out.C. Frequent commits or rollbacks are taking place in the application.D. Frequent incremental checkpoints are

splitQ51. What are the three elements involved in submitting a concurrent request? (Choose three.) A. Selecting Operating Unit B. Selecting report language C. Providing completion option D. Defining a submission schedule E. Selecting the request or request set to be submitted Answer: CDEQ52. Which three are true about internal bank accounts? (Choose three.) A. They are defined to disburse

splitQ161. Given:3. import java.util.*;4. public class Hancock {5. // insert code here6. list.add("foo");7. }8. }Which two code fragments, inserted independently at line 5, will compile without warnings? (Choose two.)A. public void addStrings(List list) {B. public void addStrings(List<String> list) {C. public void addStrings(List<? super String> list) {D. public void addStrings(List&l

splitQ21. - (Topic 2) Click the Exhibit button. Which two are true? (Choose two.) A. Every Dippy must be associated with at least one Zippy. B. Every Dippy must be associated with exactly one Zippy. C. It is valid for a Zippy to be associated with more than one Dippy. D. It is valid for a Zippy to have no associated Dippy. E. Every Zippy must be associated with exactly one Dippy. F. It is

splitQ31. Given the code fragment: List<String> listVal = Arrays.asList(“Joe”, “Paul”, “Alice”, “Tom”); System.out.println ( // line n1 ); Which code fragment, when inserted at line n1, enables the code to print the count of string elements whose length is greater than three? A. listVal.stream().filter(x -> x.length()>3).count() B. listVal.stream().map(x -> x

splitQ61. Identify three valid methods of opening, pluggable databases (PDBs). A. ALTER PLUGGABLE DATABASE OPEN ALL ISSUED from the root B. ALTER PLUGGABLE DATABASE OPEN ALL ISSUED from a PDB C. ALTER PLUGGABLE DATABASE PDB OPEN issued from the seed D. ALTER DATABASE PDB OPEN issued from the root E. ALTER DATABASE OPEN issued from that PDB F. ALTER PLUGGABLE DATABASE PDB OPEN issued from an

splitQ1. You are a project manager on a fixed-bid contract. This contract has actually been positioned as a "loss leader" within your company because it is your first contract with this customer. The hope is that you can prove yourself to the customer and win additional business at higher margins down the road. The margins for this contract are very slim. What would be the best solution to set u

splitQ41. Consider a situation where a worker failed with a core dump and cannot be restarted. Although the worker is listed as running in the adctrl utility, there is no operating system-level process for the erring worker. In this situation, the only option is to restart the patch. What are the steps performed to restart the patch? 1. Tell the manager that a worker acknowledges quit. 2. Rest

splitQ171. Which method could be utilized to identify both DML operations and the SQL statements needed to undo those operations for a specific schema owner? (Choose all that apply.)A. Query DBA_TRANSACTION_QUERY for TABLE_NAME, OPERATION, and UNDO_SQL.Limit rows by START_SCN and TABLE_OWNER.B. Query FLASHBACK_TRANSACTION_QUERY for TABLE_NAME, OPERATION, and UNDO_SQL. Limit rows by START_SCN and

splitQ1. You configured the Flash Recovery Area (FRA) for your database. The database instance is running in ARCHIVELOG mode. The default location for the archived redo log files is the Flash Recovery Area. Which two files are removed automatically if the space is required in the FRA as per the retention policy? (Choose two.)A. Flashback log filesB. Backups that have become obsoleteC. User manage

splitQ161. Identify three E-Business Tax setup options. (Choose three.)A. set up supplierB. set up tax regimesC. set up tax recovery ratesD. set up taxes and tax ratesE. set up currency exchangeAnswer: BCDQ162. Peter, the GL accountant, tells you that he has defined the budget and that the budget amounts have been entered and approved by management. After approval, he wants his assistant account

splitQ21. Identify the four setup options that control supplier defaults. (Choose four.) A. financial options B. payables options C. receiving options D. purchasing options E. Payables system setup F. Trading Community Architecture (TCA) Answer: ABDEQ22. In order for supplementary data sources to be registered in Oracle Bill Presentment Architecture (BPA), they must be interfaced with wh

splitQ11. Given: 11. public static void main(String[] args) { 12. Object obj = new int[] { 1, 2, 3 }; 13. int[] someArray = (int[])obj; 14. for (int i : someArray) System.out.print(i + " "); 15. } What is the result? A. 1 2 3 B. Compilation fails because of an error in line 12. C. Compilation fails because of an error in line 13. D. Compilation fails because of an error in line 14.

splitQ1. What three statements are true about Storage Domains? A. They help to isolate data at the Disk Enclosure level to meet security or regulatory compliance. B. They help to optimize performance by isolating different data types that may conflict each other. C. They are ideal for use with multitenancy environments to ensure physical isolation. D. They are licensed by a number of domains.

splitQ1. You have completed an OS installation in a PDom and, after subsequent reboots, you observe an error message regarding the pseudo- cdrom. Which command do you use to clear it? A. clear faults B. reset /HOSTx C. boot -r D. power off Answer: C Reference: http://docs.oracle.com/cd/E19095-01/sfv890.srvr/817-3956-12/system_overview.html Q2. Which two statements are correct regarding t

splitQ51. You have a login-path named “adamlocal” that was created by using the mysql_config_editor command. You need to check what is defined for this login_path to ensure that it is correct for you deployment. You execute this command: $ mysql_config_editor print –login-path=adamlocal What is the expected output of this command? A. The command prints all parameters for the login-path.