Exam Details
| Subject | advance database management system | |
| Paper | ||
| Exam / Course | mca | |
| Department | ||
| Organization | Gujarat Technological University | |
| Position | ||
| Exam Date | June, 2017 | |
| City, State | gujarat, ahmedabad |
Question Paper
1
Seat No.: Enrolment
GUJARAT TECHNOLOGICAL UNIVERSITY
MCA SEMESTER- V• EXAMINATION-SUMMER 2017
Subject Code: 2650004 Date:06/06/2017
Subject Name: Advanced Database Management Systems
Time: 02.30 PM TO 05.00 PM Total Marks: 70
Instructions:
1. Attempt all questions.
2. Make suitable assumptions wherever necessary.
3. Figures to the right indicate full marks.
Q.1
What is Data Model and Data Abstraction. Explain in brief three categories of Data Models. How are they related to three levels of the three schema architecture?
07
Explain buffering of blocks. How does double buffering improve block
access time?
07
Q.2
Explain in brief the distributed concurrency control based on a
distinguished copy of a data item in DDBMS.
07
Explain in brief the decisions to be taken during Physical Database Design.
07
OR
What are the differences between tuple versioning and attribute versioning. Discuss the concept of attribute versioning with example.
07
Q.3
What is the difference between discretionary and mandatory access control
07
How does multilevel indexing improve the efficiency of searching an index file? Write an algorithm for searching a nondence multilevel primary index with t levels.
07
OR
Q.3
What is role-based access control? In what ways is it superior to DAC and MAC.
07
What are the different types of statistics required for Query tuning?
07
Q.4
What is Write-Ahead Logging? Explain the concept of Steal/No-Steal and Force/No-Force. What is the usage of dirty bit and pin-unpin bit?
07
What is GIS? Explain any four methods defined by GIS standards
for testing spatial relations and spatial analysis.
07
OR
Q.4
What are the before image (BFIM) and after image (AFIM) of a data item? What is the difference between in-place updating and shadowing, with respect to their handling of BFIM and AFIM?
07
List Object-Relational support in SQL-99 and explain any one of them in
detail.
07
Q.5
What is the purpose of SQL*Loader? Discuss the process of bulk inserts with SQL*Loader in Direct Path mode.
07
Explain infrastructure-based mobile architecture and Discuss the data management issues in Mobile Databases.
07
OR
Q.5
What is the function of service listener in oracle? Explain the purpose of SQL*Loader.
07
Explain the following
1. Oracle Net Configuration
2. Service name and Listener in oracle.
07
Seat No.: Enrolment
GUJARAT TECHNOLOGICAL UNIVERSITY
MCA SEMESTER- V• EXAMINATION-SUMMER 2017
Subject Code: 2650004 Date:06/06/2017
Subject Name: Advanced Database Management Systems
Time: 02.30 PM TO 05.00 PM Total Marks: 70
Instructions:
1. Attempt all questions.
2. Make suitable assumptions wherever necessary.
3. Figures to the right indicate full marks.
Q.1
What is Data Model and Data Abstraction. Explain in brief three categories of Data Models. How are they related to three levels of the three schema architecture?
07
Explain buffering of blocks. How does double buffering improve block
access time?
07
Q.2
Explain in brief the distributed concurrency control based on a
distinguished copy of a data item in DDBMS.
07
Explain in brief the decisions to be taken during Physical Database Design.
07
OR
What are the differences between tuple versioning and attribute versioning. Discuss the concept of attribute versioning with example.
07
Q.3
What is the difference between discretionary and mandatory access control
07
How does multilevel indexing improve the efficiency of searching an index file? Write an algorithm for searching a nondence multilevel primary index with t levels.
07
OR
Q.3
What is role-based access control? In what ways is it superior to DAC and MAC.
07
What are the different types of statistics required for Query tuning?
07
Q.4
What is Write-Ahead Logging? Explain the concept of Steal/No-Steal and Force/No-Force. What is the usage of dirty bit and pin-unpin bit?
07
What is GIS? Explain any four methods defined by GIS standards
for testing spatial relations and spatial analysis.
07
OR
Q.4
What are the before image (BFIM) and after image (AFIM) of a data item? What is the difference between in-place updating and shadowing, with respect to their handling of BFIM and AFIM?
07
List Object-Relational support in SQL-99 and explain any one of them in
detail.
07
Q.5
What is the purpose of SQL*Loader? Discuss the process of bulk inserts with SQL*Loader in Direct Path mode.
07
Explain infrastructure-based mobile architecture and Discuss the data management issues in Mobile Databases.
07
OR
Q.5
What is the function of service listener in oracle? Explain the purpose of SQL*Loader.
07
Explain the following
1. Oracle Net Configuration
2. Service name and Listener in oracle.
07
Other Question Papers
Subjects
- advance database management system
- advanced biopharmaceutics & pharmacokinetics
- advanced medicinal chemistry
- advanced networking (an)
- advanced organic chemistry -i
- advanced pharmaceutical analysis
- advanced pharmacognosy-1
- advanced python
- android programming
- artificial intelligence (ai)
- basic computer science-1(applications of data structures and applications of sql)
- basic computer science-2(applications of operating systems and applications of systems software)
- basic computer science-3(computer networking)
- basic computer science-4(software engineering)
- basic mathematics
- basic statistics
- big data analytics (bda)
- big data tools (bdt)
- chemistry of natural products
- cloud computing (cc)
- communications skills (cs)
- computer aided drug delivery system
- computer graphics (cg)
- computer-oriented numerical methods (conm)
- cyber security & forensics (csf)
- data analytics with r
- data mining
- data structures (ds)
- data visualization (dv)
- data warehousing
- data warehousing & data mining
- database administration
- database management system (dbms)
- design & analysis of algorithms(daa)
- digital technology trends ( dtt)
- discrete mathematics for computer science (dmcs)
- distributed computing (dc1)
- drug delivery system
- dynamic html
- enterprise resource planning (erp)
- food analysis
- function programming with java
- fundamentals of computer organization (fco)
- fundamentals of java programming
- fundamentals of networking
- fundamentals of programming (fop)
- geographical information system
- image processing
- industrial pharmacognostical technology
- information retrieving (ir)
- information security
- java web technologies (jwt)
- language processing (lp)
- machine learning (ml)
- management information systems (mis)
- mobile computing
- molecular pharmaceutics(nano tech and targeted dds)
- network security
- object-oriented programming concepts & programmingoocp)
- object-oriented unified modelling
- operating systems
- operation research
- operations research (or)
- pharmaceutical validation
- phytochemistry
- procedure programming in sql
- programming skills-i (ps-i-fop)
- programming skills-ii (ps-oocp)
- programming with c++
- programming with java
- programming with linux, apache,mysql, and php (lamp)
- programming with python
- search engine techniques (set)
- soft computing
- software development for embedded systems
- software engineering
- software lab (dbms: sql & pl/sql)
- software project in c (sp-c)
- software project in c++ (sp-cpp)
- software quality and assurance (sqa)
- statistical methods
- structured & object oriented analysis& design methodology
- system software
- virtualization and application of cloud
- web commerce (wc)
- web data management (wdm)
- web searching technology and search engine optimization
- web technology & application development
- wireless communication & mobile computing (wcmc)
- wireless sensor network (wsn)