Given the following SQL procedure output: Table Physical Obs % Deleted EMPLOYEE_ADDRESSES 424 5.0% EMPLOYEE_PAYROLL 424 5.0%
Which SQL query will produce a report for tables in the ORION library which have had at least 5% of their physical rows deleted, as shown above?
A. select MEMNAME 'Table', NOBS 'Physical Obs', DELOBS/NOBS '% Deleted' format=percent6.1 from dictionary.tables where LIBNAME='ORION' AND DELOBS/NOBS >= .05; B. select Table_Name, Num_Rows 'Physical Obs', Deleted_Rows/Num_Rows '% Deleted' format=percent6.1 from dictionary.DBA_TABLES where TABLESPACE_NAME='ORION' AND Deleted_Rows/Num_Rows >= .05; C. select MEMNAME 'Table', NLOBS 'Physical Obs', DELOBS/NLOBS LABEL='% Deleted' format=percent6.1 from dictionary.tables where LIBNAME='ORION' AND DELOBS/NLOBS >= .05;
D. select MEMNAME 'Table', NOBS 'Physical Obs', DELOBS/NOBS LABEL='% Deleted' format=percent6.1 from dictionary.members where LIBNAME='ORION' AND DELOBS/NOBS >= .05;
correct_answer = "A"
Why the choice "C" is wrong? To me it looks like both the choices "A" and "C" are correct. Can someone please explain why the choice "C" is incorrect.
... View more