{"id":610,"date":"2021-04-04T07:12:46","date_gmt":"2021-04-04T07:12:46","guid":{"rendered":"https:\/\/bcisnotes.com\/fourthsemester\/?p=610"},"modified":"2021-04-04T07:12:46","modified_gmt":"2021-04-04T07:12:46","slug":"database-management-system-spring2015-pokhara-university-bcis","status":"publish","type":"post","link":"https:\/\/bcisnotes.com\/fourthsemester\/database-management-system-spring2015-pokhara-university-bcis\/","title":{"rendered":"Database Management System || Spring,2015 || Pokhara University || BCIS"},"content":{"rendered":"

Database Management System<\/h2>\n

This is the question set Database Management System Spring 2015, which was taken by the Pokhara University.<\/p>\n

Pokhara University \u2013 Database Management System Spring 2015<\/strong><\/p>\n

 <\/p>\n\n\n\n\n\n\n
Level:\u00a0 Bachelor<\/td>\nSemester \u2013Spring<\/td>\n\u00a0Year: 2015<\/td>\n<\/tr>\n
Program: BCIS<\/td>\n\u00a0Full Marks: 100<\/td>\n<\/tr>\n
Course: Database Management System<\/td>\n\u00a0 Pass Marks: 45<\/td>\n<\/tr>\n
\u00a0\u00a0\u00a0\u00a0 Time:\u00a0 3hrs.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Section “A”<\/p>\n

Very Short Answer Questions<\/strong><\/p>\n

Attempt all the questions.<\/p>\n

    \n
  1. What is DBMS?<\/li>\n
  2. Who are the database users?<\/li>\n
  3. What are attributes? Define primary Key.<\/li>\n
  4. What is database instance? Illustrate with example.<\/li>\n
  5. What are characteristics of relational database?<\/li>\n
  6. What is Database Anomalies?<\/li>\n
  7. Define integrity constraint.<\/li>\n
  8. What are aggregate functions?<\/li>\n
  9. Define time stamp protocols.<\/li>\n
  10. Define remote backup system.<\/li>\n<\/ol>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Section “B”<\/strong><\/p>\n

    Descriptive Answer Questions<\/strong><\/p>\n

    Attempt any six questions<\/p>\n

      \n
    1. What is join in a database? Explain its types with suitable examples.<\/li>\n
    2. What is transaction? Explain about locking.<\/li>\n
    3. Define data normalization? Explain 1NF, 2NF,3NF with suitable example.<\/li>\n
    4. Consider the following relations:<\/li>\n<\/ol>\n

      Course(course_id, title, dept_name, credits)
      \nStudent(ID, name, dept_name,tot_cred)
      \nInstructor ( ID, name, dept_name, salary)
      \nWrite SQL statements:<\/p>\n