Exam Details

Subject database management system
Paper paper 14
Exam / Course m.c.a
Department
Organization Nalanda Open University
Position
Exam Date April, 2018
City, State bihar, patna


Question Paper

N A L A N D A O P E N U N I V E R S I T Y
Master of Computer Application Part-II
PAPER-XIV [Practical]
(Database Management System)
Annual Examination, 2018
Time 2 Hours. SET-II Full Marks 20
Answer all the Questions. All questions carry equal marks.
1. Create the following tables with the fields given below
EMP ENAME, DOB, ADDR1, ADDR2, CITY, DOJ, MOB_NO, DEPT_NO, SALARY)
DEPT (DEPT_NO, DEPT_NAME, LOCATION)
Select an appropriate primary key. Input at least 10 meaningful records. Select appropriate
data types for all the fields.
2. For the above tables designed in Q.1, answer the following queries using SQL:
To display all the employees ENO, ENAME working in FINANCE_DEPT.
To display all the employees ENO whose salary is 50,000 per month?
To display the location of HR_DEPT.
Display the difference of DOJ and till date (in months).
Alter the table EMP to add a column COUNTRY with an appropriate data type.



Other Question Papers

Subjects

  • (internet concepts and web design
  • accounting & financial management
  • advanced database design
  • advanced discrete mathematics
  • advanced internet technologies
  • advanced internet technologies and computer graphics set-i
  • advanced internet technologies and computer graphics set-ii
  • application development with .net framework
  • artificial intelligence and knowledge management
  • c and assembly language programming
  • communication skill
  • communication skills
  • computer graphics and multimedia
  • computer networking
  • computer organization
  • computer organization and assembly language programming
  • data and file structures
  • data communication and computer networks
  • database management system
  • design and analysis of algorithm
  • discrete mathematics
  • internet concepts and web design
  • introduction to database management systems
  • lab (for data and file structures, networking and java programming)
  • laboratory course
  • management and information system
  • mcs-041 : operating systems
  • numerical and statistical computing
  • object oriented analysis and design
  • object oriented programming using java
  • object oriented technologies and java programming
  • operating system
  • operating system concepts and networking management
  • operating systems
  • principles of management and information systems
  • problem solving and programming
  • problem solving using c
  • software engineering
  • system analysis and design
  • systems analysis and design
  • unix and oracle
  • unix and oracle set-i
  • unix and oracle set-ii