Oracle Database 12c: Installation and Administration Free Practice Exam Questions

211 real Oracle Database 12c: Installation and Administration exam questions with answers and AI explanations. Oracle certification prep — page 21 of 22.

Question 239: A user establishes a connection to a database instance by using an Oracle Net. You want to ensure that: 1. The user account must be locked after five consecuti…
Question 240: You are required to migrate your 11.2.0.3 database as a pluggable database (PDB) to a multitenant container database (CDB). The following are the possible step…
Question 241: What happens if a maintenance window closes before a job that collects optimizer statistics completes?
Question 242: You have just completed a manual upgrade of an Oracle 11g Database to Oracle Database 12c. The Post-Upgrade Status Tool reports an INVALID status for some of t…
Question 243: You must track all transactions that modify certain tables in the sales schema for at least three years. Automatic undo management is enabled for the database…
Question 244: You are the DBA supporting an Oracle 11g Release 2 database and wish to move a table containing several DATE, CHAR, VARCHAR2, and NUMBER data types, and the ta…
Question 245: Which two are true concerning a multitenant container database with three pluggable database? (Choose two.)
Question 246: An application accesses a small lookup table frequently. You notice that the required data blocks are getting aged out of the default buffer cache. How would y…
Question 247: You notice a performance change in your production Oracle database and you want to know which change has made this performance difference. You generate the Com…
Question 249: In your multitenant container database (CDB) containing pluggable database (PDBs), you granted the CREATE TABLE privilege to the common user C # # A_ADMIN in r…