Which of the following commands is correct to delete the values in the relation teaches? (A) Delete from teaches; (B) Delete from teaches where Id = 'Null'; (C) Remove table teaches; (D) Drop table teaches;
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: A. Delete from teaches;
More APSC Prelims previous year questions questions
- Which one of the following statements possibly contains the error? (A) Select * from emp where empid=10003; (B) Select empid from emp where empid=10006; (C) Select empid from emp; (D) Select empid where empid= 1009 and Lastname = 'GELLER';
- In a strict two-phase locking protocol
- Memory management technique in which a system stores and retrieves data from secondary storage for use in main memory is called
- ______ operations do not preserve non-matched tuples.
- Why is the following statement erroneous? SELECT dept_name, ID, avg(salary) FROM instructor GROUP BY dept_name;
- 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