The ()of employees in this company has doubled.
Observe the structure of the table employees:
The table contains 8475 records.
One of the employees wants to know the names of all employees of the company. For this, he fires the following query:
SELECT * FROM EMPLOYEES ORDER BY emp_fname;
Since the operation performed on executing the query cannot fit into memory, it requires disk space to complete the operation.
Which of the following types of segments will Oracle allocate to complete the operation and to provide the required result?()
You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace:
ALTER TABLE employees SHRINK SPACE CASCADE;
Which statement is correct in this scenario?()
免费的网站请分享给朋友吧