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

1. Question 118: Which statement is true about database links?
2. Question 119: Which compression method is recommended for Direct-Path Insert operations?
3. Question 121: Which three actions are ways to apply the principle of least privilege? (Choose three.)
4. Question 122: Which two statements are true about substitution variables? (Choose two.)
5. Question 123: Your database instance is started with an SPFILE. A PFILE is also available. You execute this command: ALTER SYSTEM SET DB_CACHE_SIZE=100K; Where is the value…
6. Question 124: The CUSTOMERS table has a CUST_LAST_NAME column of data type VARCHAR2. The table has two rows whose CUST_LAST_NAME values are Anderson and Ausson. Which query…
7. Question 125: Which two statements are true about views? (Choose two.)
8. Question 126: Which three statements are true about Resumable Space Allocation in Oracle databases? (Choose three.)
9. Question 128: Which three statements are true regarding single row subqueries? (Choose three.)
10. Question 129: Which three statements are true about using SQL*Plus? (Choose three.)