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

1. Question 168: Examine this command: CREATE UNDO TABLESPACE undotbs01 DATAFILE 'undotbs_01.dbf' SIZE 100M - AUTOEXTEND ON; Which two actions must you take to ensure UNDOTBS01…
2. Question 169: You execute this command: CREATE SMALLFILE TABLESPACE sales DATAFILE '/u01/app/oracle/sales01.dbf SIZE 5G - SEGMENT SPACE MANAGEMENT AUTO; Which two statements…
3. Question 170: Which three activities are recorded in the database alert log? (Choose three.)
4. Question 171: In one of your databases, you create a user, HR, and then execute this command: GRANT CREATE SESSION TO hr WITH ADMIN OPTION; Which four actions can HR perform…
5. Question 172: You execute this query: SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE), 'MON'), 'dd `Monday for` fmMonth rrrr') What is the result?
6. Question 174: st You need to calculate the number of days from 1 January 2019 until today. Dates are stored in the default format of DD-MON-RR. Which two queries give the re…