Oracle Oracle Certifications 1Z0-083 Questions & Answers

• Question 271:

  Which two are true about common objects? (Choose two.)

  A. They can be created only in CDB$ROOT.

  B. They can be only metadata-linked in an application container.

  C. They can exist in user-defined schemas only in application containers.

  D. They can exist in CDB$ROOT and an application root.

  E. They can be extended data-linked in CDB$ROOT.

  F. They can be created only in an application root.

  Correct Answer: DF

  A common object is defined in either the CDB root or an application root, and can be referenced using metadata links or object links. A local object is every object that is not a common object. Database-supplied common objects are defined in CDB$ROOT and cannot be changed. Oracle Database does not support creation of common objects in CDB$ROOT.

  You can create most schema objects-such as tables, views, PL/SQL and Java program units, sequences, and so on—as common objects in an application root. If the object exists in an application root, then it is called an application common object. ACCORDING THE LECTURE, CORRECT ANSWERS ARE: DF

  D: they can exist in CDB$ROOT and application root.

  F: they can be created only in application root.

  Reference: https://blog.toadworld.com/2017/08/01/oracle-multi-tenant-application-containers-part-iii-sharing-of-data-in-application-common-objects

• Question 272:

  Which three actions are performed by the Oracle Preinstallation RPM, oracle-database-server-xxxx-preinstall, for Oracle Grid Infrastructure, where xxxx is the Oracle version and release? (Choose three.)

  A. performing checks to ensure minimum configuration requirements for Oracle Grid Infrastructure are met

  B. creating the oracle OS user

  C. creating the OSDBA (dba) group

  D. creating thte oraInventory (oinstall) group

  E. creating the grid OS user

  F. configuring the OS for Oracle Automatic Storage Management shared storage access

  Correct Answer: BCD

  When installed, the Oracle Preinstallation RPM does the following: Automatically downloads and installs any additional RPM packages needed for installing Oracle Grid Infrastructure and Oracle Database, and resolves any dependencies Creates an oracle user, and creates the oraInventory (oinstall) and OSDBA (dba) groups for that user As needed, sets sysctl.conf settings, system startup parameters, and driver parameters to values based on recommendations from the Oracle Preinstallation RPM program Sets hard and soft resource limits Sets other recommended parameters, depending on your kernel version Sets numa=off in the kernel for Linux x86_64 machines. Reference: https://docs.oracle.com/cd/E11882_01/install.112/e41961/prelinux.htm#CWLIN2932

• Question 273:

  While backing up to an SBT channel, you determine that the read phase of your compressed Recovery Manager (RMAN) incremental level 0 backup is a bottleneck.

  FORCE LOGGING is enabled for the database.

  Which two could improve read performance? (Choose two.)

  A. Increase the size of tape I/O buffers.

  B. Disable FORCE LOGGING for the database.

  C. Increase the size of the database buffer cache.

  D. Enable asynchronous disk I/O.

  E. Increase the level of RMAN multiplexing.

  Correct Answer: DE

  In RMAN operation, asynchronous Disk I/O is always better than synchronous I/O as a server process can begin an I/O and then perform other work while waiting for the I/O to complete. On operating systems that do not support native asynchronous I/O, the database can simulate it with special I/O slave processes (DBWR_IO_SLAVES)