1z0-083 Free Practice Test

You plan to install Oracle Grid Infrastructure for a Standalone Server and Oracle Database for the first time on a server.
Examine this command and its outcome:
<>

1. A. oracle will be an owner of the Oracle Inventory.
2. B. oracle must be the owner of every Oracle Database installation.
3. C. oracle can own an OracleDatabase installation but not an Oracle Grid Infrastructure installation.
4. D. oracle will be granted the SYSASM privilege when installing the Oracle Database software.
5. E. The user account, oracle, and group, oinstall, can be used for all Oracle software installations.

Correct Answer: CD

Which three are true about managing memory components in an Oracle database instance? (Choose three.)

1. A. With Automatic Shared Memory Management, the database instance can increase the Large Pool size byreducing the Shared Pool size.
2. B. With Automatic Memory Management, the database instance can increase the System Global Area size by reducing the Program Global Area size.
3. C. Automatically tuned and resized System Global Area components will always revertto their initial sizes after an instance restart.
4. D. Automatic Memory Management must be used together with locking the System Global Area into physical memory.
5. E. With Automatic Shared Memory Management, the database instance can increase the Program Global Area size by reducing the System Global Area size.
6. F. On Line Transaction Processing systems often use less Program Global Area than Decision Support Systems.

Correct Answer: AEF

Application PDBs, SALES_APP1 and SALES_APP2, must be created and they must access common tables of the SALES_APP application.
Examine these steps:
* 1. Install the SALES_APP application, including the commontables, in the application root.
* 2. Install the SALES_APP application in the application root and the common tables in both the CDB root and the application root.
* 3. Create an application seed.
* 4. Install the SALES_APP application in the application seed.
* 5. Create the SALES_APP1 and SALES_APP2 application PDBs.
* 6. Sync the SALES_APP1 and SALES_APP2 application PDBs with the application root.
* 7. Sync the SALES_APP1 and SALES_APP2 application PDBs with the application seed.
* 8. Sync the application seed withthe application root.
Which are the minimum required steps in the correct sequence?

1. A. 3,4,1,6,8
2. B. 1,5,6
3. C. 1,3,5,6,7
4. D. 1,3,5,7
5. E. 2,5,6

Correct Answer: B

Which four are true about duplicating a database using Recovery Manager (RMAN)? (Choose four.)

1. A. Duplication can be done by having the auxiliary databaseinstance pull backup sets from the target database instance.
2. B. A connection to an auxiliary instance is always required.
3. C. A subset of the target database can be duplicated.
4. D. A new DBID is always created for the duplicated database.
5. E. A connection tothe recovery catalog instance is always required.
6. F. A backup of the target database is always required.
7. G. Duplication can be done by having the target database instance push copies to the auxiliary database instance.
8. H. A connection to the target database instance is always required.

Correct Answer: ABCG
A duplicate database is a copy of your target database. With the FOR STANDBY clause, it keeps the same unique database identifier(DBID); If FOR STANDBY not specified it creates a new DBID. The duplicate database can include the same content or only a subset from the source database. It can be in the same host or a separate host. The principal work of the duplication is performed by the auxiliary channels.These channels correspond to a server session on the auxiliary instance on the destination host for backup based duplication. For active database duplication the target channels perform the work of pushing data file copies to the auxiliary instance (if number of allocated target channels is greater than the number of allocated auxiliary channels).

Which two are facets of performance planning that should always be considered or implemented for an Oracle Database environment? (Choose two.)

1. A. defining primary keys for all tables to speed up all queries
2. B. using check constraints to speed upupdates
3. C. defining foreign keys for all tables to speed up joins
4. D. the physical data model
5. E. the configuration of storage arrays

Correct Answer: AE