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 5 of 22.

  1. Question 46: The user SCOTT owns the CUST table that is placed in the SALES tablespace. The user SCOTT opens a session and executes commands as follows: SQL> INSERT INTO cu…
  2. Question 47: Which two statements are true about the (PMON) background process in Oracle Database 12c? (Choose two.)
  3. Question 48: Which three statements are true about Oracle Restart? (Choose three.)
  4. Question 49: Which three statements are true about space usage alerts? (Choose three.)
  5. Question 51: Which two statements describe the relationship between a scheduler window, a resource manager plan, and a job class? (Choose two.)
  6. Question 52: Your database is configured in ARCHIVELOG mode, and daily full database backups are taken. RMAN is configured to perform control file autobackups. Which statem…
  7. Question 53: You want to upgrade an Oracle Database running Oracle Database 11g to Oracle Database 12c. Which three tasks should be performed before a manual upgrade? (Choo…
  8. Question 54: Which three statements are true about Automatic Workload Repository (AWR)? (Choose three.)
  9. Question 55: Your multitenant container database, CDB1, is running in ARCHIVELOG mode and has two pluggable databases, HR_PDB and ACCOUNTS_PDB. An RMAN backup exists for th…
  10. Question 56: Examine the following steps: A DBA grants the CREATE TABLE system privilege with ADMIN OPTION to the user SIDNEY. grants the CREATE TABLE system privilege to t…