• Description: Fundamentals I
• Passing Score: 75%
• Practice Test - Number of questions: 99 questions
• Simulation Test - Number of questions: 99 questions
• Simulation Test Duration: 90 minutes
• Has explanations: No

You created a table using the following command: SQL> CREATE TABLE oe.orders_history (ord_id NUMBER(4), ord_date DATE, cust_id NUMBER(4), ord_tot NUMBER(11,2)) PCTUSED 40 PCTFREE 30 INITRANS 5 MAXTRANS 10 STORAGE (INITIAL 32K NEXT 32K PCTINCREASE 50 MINEXTENTS 5 MAXEXTENTS 100) TABLESPACE users;

Answer(s)

1. a month, you realize that the rows in the table are no longer required and you decide totruncate the table by using the following command:SQL> TRUNCATE TABLE oe.orders_history REUSE STORAGE;What are the two effects of this command? (Choose two.)A. No undo data is generated.
2. The delete trigger on the table, if any, is executed.
3. All rows are removed and only one extent is retained.
4. All rows are removed but no extents are deallocated.
5. All rows are removed and five extents are retained due to MINEXTENTS.

a month, you realize that the rows in the table are no longer required and you decide totruncate the table by using the following command:SQL> TRUNCATE TABLE oe.orders_history REUSE STORAGE;What are the two effects of this command? (Choose two.)A. No undo data is generated.

All rows are removed but no extents are deallocated.