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

1. Question 23: Which two statements are true about date/time functions in a session where NLS_DATE_FORMAT is set to DD-MON-YYYY HH24:MI:SS? (Choose two.)
2. Question 24: Which three statements are true concerning logical and physical database structures? (Choose three.)
3. Question 25: Which two statements are true about the SET VERIFY ON command? (Choose two.)
4. Question 27: The ORCL database has RESUMABLE__TIMEOUT = 7200 and DEFERRED_SEGMENT_CREATION = FALSE User U1 has a 1 MB quota in tablespace DATA. U1 executes this command: SQ…
5. Question 29: Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)
6. Question 30: Which three statements are true about inner and outer joins? (Choose three.)
7. Question 31: A script abc.sql must be executed to perform a job. A database user HR, who is defined in this database, executes this command: $ sqlplus hr/hr@orcl @abc.sql W…
8. Question 33: The SCOTT/TIGER user exists in two databases, BOSTON_DB and DALLAS_DB, in two different locations. Each database has a tnsnames.ora file defining DALLAS_DB as…
9. Question 34: The EMPLOYEES table contains columns EMP_ID of data type NUMBER and HIRE_DATE of data type DATE. You want to display the date of the first Monday after the com…
10. Question 35: Which statement is true about the INTERSECT operator used in compound queries?