Upgrade Oracle DBA 11g to Oracle Database 12c Free Practice Exam Questions

53 real Upgrade Oracle DBA 11g to Oracle Database 12c exam questions with answers and AI explanations. Oracle certification prep — page 2 of 6.

Question 11: In your database, the tbs percent used parameter is set to 60 and the tbs percent free parameter is set to 20. Which two storage-tiering actions might be autom…
Question 12: You create a table with the period for clause to enable the use of the Temporal Validity feature of Oracle Database 12c. Examine the table definition: create t…
Question 13: Which three types of failures are detected by the Data Recovery Advisor (DRA)?
Question 14: Examine the RMAN command: RMAN> SET ENCRYPTION IDENTIFIED BY <password> ON FOR ALL TABLESPACES; RMAN> BACKUP DATABASE PLUS ARCHIVELOG; Which type of encryption…
Question 15: Which two statements are true about recovering logically corrupted tables or table partitions from an RMAN backup?
Question 16: Your database has a table customers that contains the columns cust_name, amt_due, and old_status. Examine the commands executed and their output: SQL>UPDATEcus…
Question 17: You want to back up a database such that only formatted blocks are backed up. Which statement is true about this backup operation?
Question 18: Your database instance is started using an SPFILE. You are connected to cdb$root, as a DBA. You issue: SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SCOPE=BOTH; W…
Question 19: Which four actions are possible during an Online Datafile Move operation?
Question 20: What can be automatically implemented after the SQL Tuning Advisor is run as part of the Automated Maintenance Task?