image

Solution of Assignment Synopsis & Project Dissertation Report


Note: ⇩    Fill the Name, Email and Mobile to get unlock the priclist...!!!!

PRODUCT DETAILS

Online-Typing-and-Filling

Title Name Amity Solved Assignment MCA 5th Sem for Distributed Database System
University AMITY
Service Type Assignment
Course MCA
Semester Semester-V Course: MCA
Short Name or Subject Code Distributed Database System
Commerce line item Type Semester-V Course: MCA
Product Assignment of MCA Semester-V (AMITY)
Price

PRICE INR

Click to View Price
Download File (Purchase the product for download...!!!)

Solved Assignment


  Questions :-

                                                                                                                                                 DISTRIBUTED DATABASE SYSTEM

Note: Question serial number  may be change. Kindly find and search.

Section A

1 .        What is Distributed Database Management System? Discuss some problems to which subjects to DDBMS.            

2 .        Differentiate between Single-Site Processing Single-Site Data (SPSD) and Multi-Site Processing Multi-Site Data (MPSD).            

3 .        Discuss the methodologies of Data Replication in Distributed Database Management System.     

4 .        Explain the difference between File Server and Client Server architecture. 

5 .        Explain the Allocation Algorithms in DDBMS. Discuss the factors leading to different types of Algorithms.            

6 .         Discuss the following components of DDBMS

             Transaction Processor

             Application Processor

            Transaction Manager

             Data Processor

             Data Manager

 

 

Section B

Case Detail : 

Case Study

Consider the following relation.

EMPLOYEE (EMP, NAME, ADDRESS, SKILL, PROJ-ID)

EQUIPMENT (EQP-ID, EQP-TYPE, PROJECT)

Suppose that EMLOYEE relation is horizontally fragmented by PROJ-ID and each fragment is stored locally at its corresponding project site.  Assume that the EQUIPMENT relation is stored in its entirely at the Tokyo location.  Describe a good strategy for processing each of the following queries:

 

1.         Find the join of relations EMPLOYEE and EQUIPMENT.

2.         Get all employee for projects using EQP-TYPE as "Welding Machine".

3.         Find all employees of the project using equipment number 110.

 

 

Section C

Question No.  1           Marks - 10

________________________________________

 1)   ____ is used to reveal the meaning of data.          

Options          

  •  Raw facts
  •  Knowledge
  •  Formatting
  •  Information

 

Question No.  2           Marks - 10

___________________________________ provide(s) a description of the data characteristics and the set of relationships that link the data found within the database.  

Options         

  • Queries
  •  End-user data
  •  Metadata
  •  Information

 

Question No.  3           Marks - 10

________________________________________

A(n) ____ might be written by a programmer or it might be created through a DBMS utility program.     

Options        

  • Query
  •  operating system
  •  database management system
  •  application program

 

Question No.  4           Marks - 10

________________________________________

A(n) ____ database is used by an organization and supports many users across many departments.           

Options          

           

  •  Desktop
  •  Workgroup
  •  enterprise
  •  transactional

 

Question No.  5           Marks - 10

________________________________________

A ____ database supports data distributed across several different sites.   

Options         

  •  single-user
  •  Multiuser
  •  centralized
  •  distributed

 

Question No.  6           Marks - 10

________________________________________

A workgroup database is a(n)____ database.

Options                     

  •  single-user
  •  Multiuser
  •  enterprise
  •  distributed

 

Question No.  7           Marks - 10

________________________________________

Most decision-support data are based on historical data obtained from ____.        

Options         

  •  operational databases
  •  data warehouses
  •  enterprise databases
  •  workgroup databases

 

 

Question No.  8           Marks - 10

________________________________________

 The relational data model was developed in the ____.        

Options

  •  1960s
  •  1970s
  •  1980s
  •  1990s

 

 

Question No.  9           Marks - 10

________________________________________

The ____ model was developed to allow designers to use a graphical tool to examine structures rather

than describing them with text.         

Options          

  •   hierarchical
  •  network
  •  object-oriented
  •  entity relationship

 

 

Question No.  10         Marks - 10

________________________________________

 The relational model’s creator, E. F. Codd, used the term relation as a synonym for ____.

Options                 

  •  index
  •  Key
  •  table
  •  relationship

 

Question No.  11         Marks - 10

________________________________________

The set of possible values for an attribute is a ____. 

Options          

  •    Domain
  •  Range
  •  set
  •  Key

 

 

Question No.  12         Marks - 10

________________________________________

 ____ attributes can have several values.       

Options          

  •  Composite
  •  Simple
  •  Single-valued
  •  Multivalued

 

 

Question No.  13         Marks - 10

________________________________________

Making sure all ____ are identified is a very important part of a database designer’s job.  

Options             

  •  business rules
  •  cardinalities
  •  derived attributes
  •  relationships

 

Question No.  14         Marks - 10

________________________________________

If an entity can exist apart from one or more related entities, it is said to be ____-independent.    

Options             

  •  Existence
  •  Relationship
  •  business
  •  weak

 

Question No.  15         Marks - 10

________________________________________

If an employee within an EMPLOYEE entity has a relationship with itself, that relationship is known

as a ____ relationship.

Options                    

  •  Self
  •  self-referring
  •  looping
  •  Recursive

 

Question No.  16         Marks - 10

________________________________________

 An attribute that is part of a key is known as a(n) ____ attribute.   

Options                     

  •  Important
  •  Nonprime
  •  prime
  •  entity

 

Question No.  17         Marks - 10

________________________________________

 The ____ depicts the arrangement of higher-level entity supertypes (parent entities) and lower-level entity subtypes (child entities).           

Options                     

  •  subtype discriminator
  •  inheritance
  •  specialization hierarchy
  •  entity supertype

 

 

Question No.  18         Marks - 10

________________________________________

 ____ data refer to data whose values change over time and for which you must keep a history of the data changes.           

Options                   

  •  Time-sensitive
  •  Time-variant
  •  Historical
  •  Change-based

 

 

Question No.  19         Marks - 10

________________________________________

According to the data modeling checklist, ____ should clearly define participation and cardinality

rules.   

Options                     

  •  Entities
  •  naming conventions
  •  relationships
  •  attributes

 

Question No.  20         Marks - 10

________________________________________

Some RDBMS (like Oracle) will automatically ____ data changes when issuing data definition

commands.     

Options                     

  •  ROLLBACK
  •  COMMIT
  •  UPDATE
  •  INVOKE

 

Question No.  21         Marks - 10

________________________________________

 ____ requires that all operations of a transaction be completed.   

Options                     

  •  Specificity
  •  Atomicity
  •  Durability
  •  Time stamping

 

Question No.  22         Marks - 10

________________________________________

 A single-user database system automatically ensures ____ of the database, because only one

transaction is executed at a time.       

Options                   

  •  serializability and durability
  •  atomicity and isolation
  •  serializability and isolation
  •  atomicity and serializability

 

Question No.  23         Marks - 10

________________________________________

 A(n) ____ condition occurs when two or more transactions wait for each other to unlock data.    

Options                    

  •  Deadlock
  •  exclusive lock
  •  binary lock
  •  two-phase lock

 

Question No.  24         Marks - 10

________________________________________

On the server side, the DBMS environment must be properly configured to respond to clients requests in the fastest way possible, while making optimum use of existing resources. The activities required to achieve that goal are commonly referred to as ____ tuning.           

Options                     

  •  client and server
  •  database
  •  SQL performance
  •  DBMS performance

 

 

Question No.  25         Marks - 10

________________________________________

 ____ is/are the central activity during the parsing phase in query processing.         

Options                     

  •  Database statistics
  •  Data sparsity
  •  SQL query
  •  Query optimization

 

Question No.  26         Marks - 10

________________________________________

The ____ must be set large enough to permit as many data requests to be serviced from cache as possible.         

Options                     

  •  data cache
  •  SQL cache
  •  sort cache
  •  optimizer mode

 

Question No.  27         Marks - 10

________________________________________

The ____ table space is used to store end-user data.          

Options                     

  •  System
  •  user data
  •  temporary
  •  rollback segment

 

Question No.  28         Marks - 10

________________________________________

 ____ is a disadvantage of a DDBMS.       

Options                     

  •  Processor independence
  •  User-friendly interface
  •  Security
  •  Faster data access

 

 

Question No.  29         Marks - 10

________________________________________

  ____ is an advantage of a DDBMS.          

Options                    

  •  Reduced operating cost
  •  Simplicity of management and control
  •  Decreased storage requirements
  •  Decreased training cost

 

 

Question No.  30         Marks - 10

________________________________________

____ is the highest level of transparency. The end user or programmer does not need to know that a database is partitioned.     

Options                     

  •  Performance
  •  Fragmentation
  •  Location
  •  Local mapping

 

Question No.  31         Marks - 10

________________________________________

 ____’s main goal is to provide a comprehensive and consistent definition of all data within an organization.     

Options                     

  •  DBMS
  •  OLAP
  •  Data warehousing
  •  MDM

 

Question No.  32         Marks - 10

________________________________________

One of the main characteristics of an OLAP system is ____ .         

Options                    

  •  They use single-dimensional data analysis techniques
  •  They provide complex command-line end-user interfaces
  •  They provide minimal database support
  •  They support client/server architecture

 

Question No.  33         Marks - 10

________________________________________

Conceptually, MDBMS end users visualize the stored data as a three-dimensional cube known as a ____.           

Options                     

  •  multi cube
  •  data matrix
  •  data cube
  •  hyper cube

 

Question No.  34         Marks - 10

________________________________________

Computed or derived facts are sometimes called ____to differentiate them from stored facts.      

Options                     

  •  Details
  •  Attributes
  •  metrics
  •  fact tables

 

 

Question No.  35         Marks - 10

________________________________________

A ____ schema is a type of star schema in which the dimension tables can have their own dimension

tables. 

Options                     

  •  Snowflake
  •  starflake
  •  mesh
  •  matrix

 

Question No.  36         Marks - 10

________________________________________

 A(n) ____is a dynamic table that not only contains the SQL query command to generate the rows, but also stores the actual rows.          

Options                     

  •  OLAP
  •  materialized view
  •  star schema
  •  data cube

 

 

Question No.  37         Marks - 10

________________________________________

Another name for a database server-side extension is ____. 

Options                     

  •  Web server
  •  Web application server
  •  star schema
  •  data cube

 

Question No.  38         Marks - 10

________________________________________

 ____ are general statements of direction or action that communicate and support DBA goals.      

Options                     

  •  Standards
  •  Policies
  •  Documentation
  •  Procedures

 

Question No.  39         Marks - 10

________________________________________

Classifying users into ____, according to common access needs, facilitates the DBA’s job of

controlling and managing the access privileges of individual users. 

Options                     

  •  user groups
  •  sections
  •  authorization schemes
  •  policy definitions

 

Question No.  40         Marks - 10

________________________________________

 A(n) ____ data dictionary is not updated automatically and usually requires a batch process to be run.     

Options                     

  •  Active
  •  passive
  •  static
  •  dynamic

  Answers :-

Only after macking the payment you would be able to see the answer...!!!

Review

Average user rating

4.8 / 5

Rating breakdown

5
80% Complete (danger)
1
4
80% Complete (danger)
1
3
80% Complete (danger)
0
2
80% Complete (danger)
0
1
80% Complete (danger)
0

January 29, 2015
This was nice in buy
Assignment from solve zone is probably one of the first preference of students.

October 09, 2016
This was nice in buy
I recommend a website that was really helpful throughout your session.

March 19, 2017
Some day ago
This was nice in buy
This was good in buy . I found all the answer correct and meaningful and had scored good marks
Back to top