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 12 of 14.

1. Question 145: Which two statements are true about User Authentication in an Oracle Database? (Choose two.)
2. Question 147: You issued this command: DROP TABLE hr.employees; Which three statements are true? (Choose three.)
3. Question 149: Examine this query: SELECT TRUNC(ROUND(156.00,-2),-1) FROM DUAL What is the result?
4. Question 150: Which three statements are true about the Oracle Database server during and immediately after SHUTDOWN TRANSACTIONAL? (Choose three.)
5. Question 151: Which three are benefits of using temp UNDO when performing DML on global temporary tables? (Choose three.)
6. Question 152: TBS1 is a permanent user-defined tablespace. Oracle Managed Files (OMF) is not used in this database. Examine this command: DROP TABLESPACE tbsl; Which two wil…
7. Question 153: Which two statements are true about segment types in an Oracle Database? (Choose two.)
8. Question 154: Which three tasks are performed by background processes in an Oracle database instance? (Choose three.)
9. Question 155: Which two statements are true about constraints? (Choose two.)
10. Question 157: Which three statements are true about roles? (Choose three.)