Why is the following statement erroneous? SELECT dept_name, ID, avg(salary) FROM instructor GROUP BY dept_name;
Asked in APSC 66 12/ Junior Manager (Electrical / Mechanical / IT/ INSTRUMENTATION) , in Assam Power Generation Corporation Limited (APGCL) (Advt. No. 12/, dtd 25-04-) ELECTRICAL ENGINEERING ME 2023
Show answer
Answer: D. None of the above
More APSC Prelims previous year questions questions
- The ability to query data as well as insert, delete and alter tuples is offered by
- ______ is a set of one or more attributes taken collectively to uniquely identify a record.
- CPU fetches the instruction from memory according to the value of
- In operating system, which of the following is/are CPU scheduling algorithm(s)?
- The FCFS algorithm is particularly troublesome for
- If a process fails, most operating systems write the error information to a/an
- A computer system has a 36-bit virtual address space with a page size of 8K, and 4 bytes per page table entry. How many pages are there in the virtual address space?
- With round-robin scheduling algorithm in a time-shared system