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

  1. Question 74: Which two statements are true regarding a SAVEPOINT? (Choose two.)
  2. Question 75: The INVOICE table has a QTY_SOLD column of data type NUMBER and an INVOICE_DATE column of data type DATE. NLS_DATE_FORMAT is set to DD-MON-RR. Which two are tr…
  3. Question 76: Examine this SQL statement: SELECT cust_id, cust_last_name `Last Name` FROM customers - WHERE country_id = 10 - UNION - SELECT cust_id CUST_NO, cust_last_name…
  4. Question 77: You want to write a query that prompts for two column names and the WHERE condition each time it is executed in a session but only prompts for the table name t…
  5. Question 78: You want to use table compression suitable for OLTP that will: 1. Compress rows for all DML statements on that table 2. Minimize the overheads associated with…
  6. Question 79: Which two statements are true about views used for viewing tablespace and datafile information? (Choose two.)
  7. Question 80: Which three statements are true about the Oracle Data Dictionary? (Choose three.)
  8. Question 83: You have been tasked to create a table for a banking application. One of the columns must meet three requirements: 1. Be stored in a format supporting date ari…
  9. Question 87: Which three Oracle database space management features will work with both Dictionary and Locally managed tablespaces? (Choose three.)
  10. Question 89: Which two queries execute successfully? (Choose two.)