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

1. Question 90: You executed a DROP USER CASCADE on an Oracle 11g release 1 database and immediately realized that you forgot to copy the OCA.EXAM_RESULTS table to the OCP sch…
2. Question 93: Which two statements are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose two.)
3. Question 94: You have a production Oracle 12c database running on a host. You want to install and create databases across multiple new machines that do not have any Oracle…
4. Question 95: Examine the command: SQL> ALTER SYSTEM SET ENABLE_DDL_LOGGING=TRUE; Which two statements are true in this scenario? (Choose two.)
5. Question 96: What is the outcome of the SHUTDOWN ABORT command?
6. Question 97: Which statement is true about a database in ARCHIVELOG mode?
7. Question 99: Which four are true about creating and running a remote database scheduler jobs? (Choose four.)
8. Question 100: Which four statements are true about database instance behavior? (Choose four.)
9. Question 102: Your production database uses file system storage. You want to move storage to Oracle Automatic Storage Management (ASM). How would you achieve this?
10. Question 103: You want to create a locally managed tablespace called NEWTBS to store segments with different extent sizes. Which set of tablespace attributes can be specifie…