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

1. Question 200: You conned using SQL Plus to the root container of a multitenant container database (CDB) with SYSDBA privilege. The CDB has several pluggable databases (PDBs)…
2. Question 201: What is the effect of specifying the "ENABLE PLUGGABLE DATABASE" clause in a "CREATE DATABASE" statement?
3. Question 202: In your multitenant container database (CDB) with two pluggable database (PDBs). You want to create a new PDB by using SQL Developer. Which statement is true?
4. Question 203: You want to prevent a group of users in your database from performing long-running transactions that consume huge amounts of space in the undo tablespace. If t…
5. Question 204: Which activity is audited by default and recorded in the operating system audit trail irrespective of whether or not database auditing is enabled?
6. Question 205: Your database instance is started by using a server parameter file (SPFILE). You execute the following command to change the value of the LOG_BUFFER initializa…
7. Question 206: Which two statements are true about SQL *Loader Express Mode in an Oracle 12c database? (Choose two.)
8. Question 207: Examine the command to perform a data pump export operation on a source database:
   gt; expdp hr/hr DIRECTORY=dumpdir DUMPFILE=emp1.dmp VIEWS_AS_TABLE=emp_dept On…
9. Question 208: Which three statements are true when the listener handles connection requests to an Oracle 12c database instance with multithreaded architecture enabled In UNI…
10. Question 210: Your database is in NOARCHIVELOG mode. You want to enable archiving for the database. Examine the steps: 1. Execute the ALTER DATABASE ARCHIVELOG command. 2. E…