Advanced Database Management System MCA paper Nov 2021

  • Subject Code: - PGCA 1953
  • Subject Name: - Advanced Database Management System
  • Date of Examination: - Nov 2021
  • Class: - MCA 1st
  • Exam Mode: - Online

Instructions to Candidates

  1. Attempt any FIVE question(s), each question carries 14 marks.

QUESTIONS

  1. What is DBMS? Explain the different components of DBMS. What are the advantages of DBMS over Traditional File Processing system?
    2.
  2. What is an ER model? What are the different types of attributes and how are they represented in ER diagrams? Explain the concept of strong and weak entity sets with the help of examples.
    3.
  3. What is Functional Dependency? Explain in detail the first three Normal Forms and the Boyce Codd Normal form (Along with anomalies and examples).
    4.
  4. Define Relational Algebra. Explain the fundamental operations of Relational Algebra with the help of examples.
    5.
    1. What is a Parallel Database? What are the benefits of Parallel Database?
    2. Discuss the locking protocols used in distributed serializability.
    6.
    1. What are the advantages of a distributed database management system over a centralized DBMS?
    2. Explain Concurrency Control and Recovery in Distributed Databases.
    7.
  7. What is a Spatial Database System? Explain the different spatial data types, data structures and methods of storage.
    8.
  8. Explain in detail multidimensional database system. Also explain what are NOSQL databases?
    9.

ANSWERS:

Q1.

Top

Comments

Post a Comment

Popular posts from this blog

Programming in Python MCA paper Nov 2021

Subject Code: - PGCA 1951 Subject Name: - Programming in Python Date of Examination: - Nov 2021 Class: - MCA 1st Exam Mode: - Online Instructions to Candidates Attempt any FIVE question(s), each question carries 14 marks. QUESTIONS Write a function in Python, INSERTQ(A,data) and DELETEQ(A) for performing insertion and deletion operations in a Queue. A is the list used for implementing queue and data is the value to be inserted. How can you traverse, insert and delete elements from an array using inbuilt functions. Elaborate using Python code. Write a Python program to delete the first occurrence of the given word in a List, where words can repeat. Write a Python program to check whether a string is a palindrome or not using recursion. ...
Read more

Advanced JAVA MCA paper May 2021

Subject Code: - PGCA 1918 Subject Name: - Advanced JAVA Date of Examination: - May 2021 Class: - MCA 2nd Exam Mode: - Online Instructions to Candidates Attempt any FIVE question(s), each question carries 14 marks. QUESTIONS Define servlet? How servlet is different from applet? Discuss about HttpServletRequest and HttpServletResponse classes and its methods. What is struts? Explain the features, architecture and working diagram of struts framework What are the elements of JSP page? Give the purpose and role of each element also show the use of request and response objects in JSP with proper JSP example. What are cookies? Compare the session tracking with cookies and session object with their pros and cons. How to create Javabean? Describe various techniques available for using...
Read more

Computer Networks BCA paper Nov 2021

Subject Code: - UGCA 1913 Subject Name: - Computer Networks Date of Examination: - Nov 2021 Class: - BCA 3rd Exam Mode: - Online Instructions to Candidates Attempt any FIVE question(s), each question carries 12 marks. QUESTIONS What is Unguided Network Media? Explain its types, merits and demerits. Why multiple access is required in LAN technologies? Compare FDM, TDM and SDM. Differentiate between circuit, message and packet switching. What is OSI reference model? Compare it with TCP / IP model. Discuss the various issues in session and presentation layer. Differentiate between simplex, half duplex and full duplex channels. Define routing. Explain any one algorithm of routing. Write a note on flow control and buffering. ...
Read more