Consider the following schema - LOCATIONS (subject...
Guiding State PSC aspirants since 2016 50,000+ students · 1,000+ final selections Exam Calendar Results Call 9116926003
pscnotes
Pick your state
MPSC Prelims previous year questions

Consider the following schema - LOCATIONS (subject_code, department_name, location_id, city); Which code snippet will alter the table LOCATIONS and add a column named Address, with datatype VARCHAR2(100)?

Asked in Mizoram PSC 4.Technical Paper-II

  1. ALTER TABLE locations ADD (address varchar2(100));
  2. ALTER TABLE locations ADD COLUMN(address varchar2(100));
  3. MODIFY TABLE locations ADD COLUMN (address varchar2(100));
  4. None of the above.

Answer under review: our editors are checking this question. Try the other MPSC Prelims previous year questions questions meanwhile.

More MPSC Prelims previous year questions questions

All 7,163 MPSC Prelims previous year questions questions →