Oracle Database Administration I Free Practice Exam Questions

136 real Oracle Database Administration I exam questions with answers and AI explanations. Oracle certification prep — page 6 of 14.

1. Question 62: In the ORCL database, UNDOTBS1 is the active undo tablespace with these properties: 1. A size of 100 MB 2. AUTOEXTEND is off 3. UNDO_RETENTION is set to 15 min…
2. Question 63: In one of your databases, the user HR has the password HRMGR. You want to connect to a database instance whose listener listens on port 1531 by using this stat…
3. Question 64: Which two tasks can you perform using DBCA for databases? (Choose two.)
4. Question 65: In the SALES database, DEFERRED_SEGMENT_CREATION is TRUE. Examine this command: SQL> CREATE TABLE T1(c1 INT PRIMARY KEY, c2 CLOB); Which segment or segments, i…
5. Question 66: Which two statements are true about the PMON background process? (Choose two.)
6. Question 68: In your data center, Oracle Managed Files (OMF) is used for all databases. All tablespaces are smallfile tablespaces. SALES_Q1 is a permanent user-defined tabl…
7. Question 69: Which three statements are true about undo segments and the use of undo by transactions in an Oracle database instance? (Choose three.)
8. Question 70: Which two statements are true about Enterprise Manager (EM) Express?
9. Question 71: Which three functions are performed by dispatchers in a shared server configuration? (Choose three.)
10. Question 73: Which three files are used by conventional path SQL*Loader when the TABLE option is not specified? (Choose three.)