Exam Details
| Subject | advance database management system | |
| Paper | ||
| Exam / Course | mca | |
| Department | ||
| Organization | Gujarat Technological University | |
| Position | ||
| Exam Date | November, 2017 | |
| City, State | gujarat, ahmedabad |
Question Paper
Seat No.: Enrolment
GUJARAT TECHNOLOGICAL UNIVERSITY
MCA SEMESTER V • EXAMINATION WINTER 2017
Subject Code: 650004 Date:29/11/2017
Subject Name: Advance Data Base Management Systems
Time: 10:30 am to 01: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
Do as Directed
1. Define Dense index
2. What do you mean by Dirty bit?
3. Differentiate interleaved concurrency v/s parallel concurrency.
4. List out various database utilities that help the DBA manage database system.
5. What is the use of BLOB?
6. DES stand for
7. The description of database is called the
7
Q.1
1. Explain Three- schema architecture with diagram
2. Write a note on Double Buffering
4
3
Q.2
List out and Explain advantages of DBMS approach
7
Q.2
What is tuning? What are the goals of it? Discuss types of problems encountered during it. Also discuss the different types of statistics required for it.
OR
7
Q.2
What do you mean by key field ?Explain in brief the concepts of primary index, clustering index and secondary index
7
Q.3
Write a note on PKI with its six ingredients and Digital signature
7
Q.3(b)
Why deferred update technique is called NO UNDO/REDO method? Discuss deferred update technique in a single user environment with example.
OR
7
Q.3
Write a note on WAL, Steal/No-steal approach and Force/no-Force approach
7
Q.3
List out four main control measures that are used to provide security of data. Explain Access control and action performed by DBA for security in brief.
7
Q.4
Explain Fixed length records, variable length records, spanned records and un-spanned records with example.
7
Q.4
Give functions of Temporal database. List out various temporal data types. Explain the concepts of valid time and transaction time dimension with example.
OR
7
Q.4
Explain in brief distributed concurrency control based on distinguished copy of a data item in DDBMS.
7
Q.4
List the object relational features included in SQL-99.Give an example of each
7
Q.5
What is GIS? List out and explain various characteristics of data in GIS.
7
Q.5
Explain bulk insert using SQL* loader.
OR
7
Q.5
Write a note on Mobile computing architecture.
7
Q.5
Explain oracle Net configuration in detail.
7
GUJARAT TECHNOLOGICAL UNIVERSITY
MCA SEMESTER V • EXAMINATION WINTER 2017
Subject Code: 650004 Date:29/11/2017
Subject Name: Advance Data Base Management Systems
Time: 10:30 am to 01: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
Do as Directed
1. Define Dense index
2. What do you mean by Dirty bit?
3. Differentiate interleaved concurrency v/s parallel concurrency.
4. List out various database utilities that help the DBA manage database system.
5. What is the use of BLOB?
6. DES stand for
7. The description of database is called the
7
Q.1
1. Explain Three- schema architecture with diagram
2. Write a note on Double Buffering
4
3
Q.2
List out and Explain advantages of DBMS approach
7
Q.2
What is tuning? What are the goals of it? Discuss types of problems encountered during it. Also discuss the different types of statistics required for it.
OR
7
Q.2
What do you mean by key field ?Explain in brief the concepts of primary index, clustering index and secondary index
7
Q.3
Write a note on PKI with its six ingredients and Digital signature
7
Q.3(b)
Why deferred update technique is called NO UNDO/REDO method? Discuss deferred update technique in a single user environment with example.
OR
7
Q.3
Write a note on WAL, Steal/No-steal approach and Force/no-Force approach
7
Q.3
List out four main control measures that are used to provide security of data. Explain Access control and action performed by DBA for security in brief.
7
Q.4
Explain Fixed length records, variable length records, spanned records and un-spanned records with example.
7
Q.4
Give functions of Temporal database. List out various temporal data types. Explain the concepts of valid time and transaction time dimension with example.
OR
7
Q.4
Explain in brief distributed concurrency control based on distinguished copy of a data item in DDBMS.
7
Q.4
List the object relational features included in SQL-99.Give an example of each
7
Q.5
What is GIS? List out and explain various characteristics of data in GIS.
7
Q.5
Explain bulk insert using SQL* loader.
OR
7
Q.5
Write a note on Mobile computing architecture.
7
Q.5
Explain oracle Net configuration in detail.
7
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)