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

1. Question 90: The STORES table has a column START_DATE of data type DATE, containing the date the row was inserted. You only want to display details of rows where START_DATE…
2. Question 91: Which two statements are true about Oracle synonyms? (Choose two.)
3. Question 93: Which two statements are true about INTERVAL data types? (Choose two.)
4. Question 95: You start your database instance in NOMOUNT state. Which two actions are performed? (Choose two.)
5. Question 96: Which two statements are true about the Oracle Data Dictionary? (Choose two.)
6. Question 97: Which three statements are true about sequences in a single instance Oracle database? (Choose three.)
7. Question 98: You want to apply the principle of Least Privilege in all your live databases. One of your requirements is to revoke unnecessary privileges from all users who…
8. Question 99: Which three statements are true about performing Data Manipulation Language (DML) operations on a view with no INSTEAD OF triggers defined? (Choose three.)
9. Question 100: Which three statements are true about indexes and their administration in an Oracle database? (Choose three.)
10. Question 102: In the promotions table, the PROMO_BEGIN_DATE column is of data type DATE and the default date format is DD-MON-RR. Which two statements are true about express…