The standard EMP table contains 14 records corresponding to the employess of the corporation.One of those records has a NULL value stored in the MGR column.If Issue the following command on the table: select count(mgr) from emp; What is the count?

Keep practicing — related questions

• If emp table having 10 records what is the output of : select * from emp where rownum=8;
• What will be the output of following Select 8 from Emp ? Emp table has 10 rows
• The EMP table contains these columns: LAST NAME VARCHAR2(25) SALARY NUMBER(6,2) DEPARTMENT_ID NUMBER(6) You...
• The EMP table contains these columns: LAST NAME VARCHAR2(25) SALARY NUMBER(6,2) DEPARTMENT_ID NUMBER(6) You...
• The EMP table contains these columns: LAST NAME VARCHAR2(25) SALARY NUMBER(6,2) DEPARTMENT_ID NUMBER(6) You...
• The EMP table contains these columns: LAST NAME VARCHAR2(25) SALARY NUMBER(6,2) DEPARTMENT_ID NUMBER(6) You...
• Emp table has 10 rows. How many rows will be fetched against the following query? Select 10 from emp where ...
• If emp table is having 10 rows, which of the below queries executes successfully without error? A) delete f...