Oracle Database Administration II - 1Z0-083 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

You issued this command:
RMAN> BACKUP RECOVERY FILES;
Which two are true? (Choose two.)

A. All non-Oracle files in the current FRA that have not been backed up already, are backed up. B. All Oracle recovery files in the current fast recovery area (FRA) are backed up. C. All Oracle recovery files not in the current FRA that have not been backed up already, are backed up. D. All Oracle recovery files in the current FRA that have not been backed up already, are backed up. E. These backups can be written to disk or SBT.

Discussion 0

Correct Answer: C,D Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 2

You execute this command successfully:
SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
What is the outcome?

A. It creates a copy of the control file in the fast recovery area (FRA). B. It updates the alert log with the location and contents of the control file C. It creates a file that contains RMAN scripts to create a duplicate database. D. It creates a file that contains SQL statements to re-create the control file. E. It creates a binary backup of the control file.

Discussion 0

Correct Answer: D Vote an answer

Question 3

Which two are true about backup set compression using RMAN default compression? (Choose two.)

A. Binary compression adds CPU overhead to backup operations. B. Compression can be done only for locally managed tablespaces. C. Compressed backups cannot have a section size defined. D. Unused blocks below the high water mark are backed up. E. Compressed backups can be written only to media.

Discussion 0

Correct Answer: A,B Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 4

Which two are true about Oracle Grid Infrastructure for a Standalone Server?

A. Oracle Restart can attempt to restart a failed ASM instance automatically. B. It allows Oracle Restart binaries to be installed without installing ASM. C. It must be installed after Oracle Database software is installed. D. It must be installed before Oracle Database software is installed. E. It allows ASM binaries to be installed without installing Oracle Restart. F. Oracle Restart can be used without using ASM for databases.

Discussion 0

Correct Answer: A,F Vote an answer

Question 5

You must transport the UNIVERSITYtablespace from one database to another.
The UNIVERSITYtablespace is currently open read/write.
The source and destination platforms have different endian formats.
Examine this list of actions:
1. Make the UNIVERSITY tablespace read-only on the source system.
2. Export the UNIVERSITYtablespace metadata using EXPDP.
3. Convert the UNIVERSITYtablespace data fies to the destination platform format using RMAN on the source system.
4. Copy the UNIVERSITYtablespace data files to the destination system.
5. Copy the Data Pump dump set to the destination system.
6. Convert the UNIVERSITYtablespace data files to the destination platform format using RMAN on the destination system.
7. Import the UNIVERSITYtablespace metadata using IMPDP.
8. Make the UNIVERSITY tablespace read/write on the destination system.
Which is the minimum number of actions required, in the correct order, to transport the UNIVERSITYtablespace?

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

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 6

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

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

Discussion 0

Correct Answer: B,C,D Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 7

Which three resources are always shared among CDB$ROOT and pluggable databases (PDBs)?
(Choose three.)

A. undo tablespaces B. the log writer process (LGWR) C. the Process Monitor Process (PMON) D. the data dictionary in CDB$ROOT E. temporary tablespaces F. SYSAUX tablespaces

Discussion 0

Correct Answer: B,C,D Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 8

Which two are true about changing the LOCAL_UNDO_ENABLED property to false in a CDB?
(Choose two.)

A. After the change, only a common user with the required privilege can create an undo tablespace in CDB&ROOT. B. After the change, only one undo tablespace can exist in CDB$ROOT. C. After the change, any user with the required privilege can create an undo tablespace in the PDBs. D. Any new PDB and existing PDBs are automatically configured to use the default undo tablespace in CDB$ROOT. E. After the change, each existing PDB has to be reopened for the new undo mode to take effect. F. Undo tablespaces existing in PDBs must be dropped before the change.

Discussion 0

Correct Answer: A,E Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 9

In which two situations can you use Database Upgrade Assistant? (Choose two.)

A. when the operating system (OS) needs to be changed as part of the upgrade B. when the target and source database are on the same platform C. when a character set conversion is required during the upgrade D. when the hardware platform needs to be changed as part of the upgrade E. when multiple pluggable databases in a container database have to be upgraded in a specific sequence

Discussion 0

Correct Answer: B,E Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 10

Examine the description of the SALES table:

Examine this statement:
CREATE TABLE mysales (prod_id, cust_id, quantity_sold, price)
AS
SELECT product_id, customer_id, quantity_sold, price
FROM sales
WHERE 1 = 2;
Which two statements are true?

A. MYSALES is created with 2 rows. B. MYSALES is created with 1 row. C. MYSALES is created with no rows. D. MYSALES will have no constraints defined regardless of which constraints might be de-fined on SALES. E. MYSALES has NOT NULL constraints on any selected columns which had that constraint in the SALES table.

Discussion 0

Correct Answer: C,E Vote an answer